[RESOLVED] I need a quick fix

[gszauer]

Hi all,
i dont have mutch time, so i will get right to the point,
i have a script to connect to a database, in there i have some colums, but only 3 of them that matter,
band_name
song_name
stars
I need to find a way to display those 3 colums (in that order) on an html page, and make a table (also to sort it by the stars value witch is a number)
I would appriciate any help, and am sorry if this just sounds like a nother please help me post, but this is urgent, and im not wery good with php yet...
Thanks for your time
~Gabor Szauer

[TobyRT]

you have your html - in the appropriate place add something along these lines

<?php
mysql_connect(connect to the db);
mysql_select_db(select your db);

//define the query
$query="SELECT band_name, song_name, stars FROM my_song_table";

//run the query (with error checking)
mysql_query($query) or die ("Error in query".mysql_error());

//if results are returned
if (mysql_num_rows($query) > 0) 
{
//start a table if there are results

echo '<table> 
            <tr><td>band</td></tr>
         <tr><td>song</td></tr>
         <tr><td>stars</td></tr>';

// put the results into an array

  while ($row=mysql_fetch_array($query) 
  { 

//put each new result into a row with 3 columns

  echo '<tr>
           <td>'.$row['band_name'].'</td>
           <td>'.$row['song_name'].'</td>
           <td>'.$row['stars'].'</td>
           </tr>';           

    }   //end what do do for each result in the array

//end what to do if results are found

echo '</table>';
} 

//tell it what to do if there aren't any results found.

else    

{

echo 'sorry - no songs in this database';

}

?>

[chrislive]

you would also want to sort the Sql query

//define the query
$query="SELECT band_name, song_name, stars FROM my_song_table ORDER BY 'stars' DESC"; 

if it goes the wrong way take out the DESC

[TobyRT]

oh yeah!

RTQ!