Jump to content

Search the Community

Showing results for tags 'artist'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 2 results

  1. Hi, I have to upgrade this artist webpage to html5 and responsive design. Before that, I'll preciate your critiques. Regards! MarĂ­a http://www.julianguerrero.com/
  2. I am working on a website for a company who does Karaoke and they need a song list. I have a sample page of a few songs selected from a sample database I set up. The MySQL and PHP I used organize the artists (removing the word "the" from the artist name), and then the songs when the artist has multiple songs on their list. However, when the artist has multiple entries in the database, I only want their name to appear in the first instance. For example: Adam Ant - Goody Two ShoesThe Beatles - Eleanor Rigby__________ - Hey Jude__________ - The Long and WInding RoadBlondie - Call Meetc. (obviously, this will be much more structured when appearing on the web page) As opposed to: Adam Ant - Goody Two ShoesThe Beatles - Eleanor RIgbyThe Beatles - Hey JudeThe Beatles - The Long and Winding RoadBlondie - Call Meetc. Here is my code as of now: <?php//Link to Database$link = mysql_connect('localhost','root','') or die("Could not connect!");$dblink = mysql_select_db('songlist') or die("Could not find database!"); //Order by Artist and Song, Removing THE from Artist$query = mysql_query("SELECT * FROM songs ORDER BY TRIM(LEADING 'The ' FROM artist), song"); //Start Tableecho "<table>"; //While Loopwhile ($row = mysql_fetch_array($query)) { //Declare Variables $artist = $row['artist']; $song = $row['song']; //Display Song List echo "<tr><td>" . $artist . "</td><td>" . $song . "</td></tr>"; } //End Tableecho "</table>"; //Close Connectionmysql_close($link);?> What should I add to get the desired effect? Thanks in advance,Mark
×
×
  • Create New...