Grabbing The Row ID

[inulled]

<?php
include("processing/config.php");

$connect = mysql_connect($db_host, $db_user, $db_pass)
or die ("Couldn't Connect to Server");
$db = mysql_select_db($db_name, $connect)
or die ("Couldn't Select Database");

$song = mysql_query("SELECT DISTINCT id, url, songname, artists, song_desc FROM music WHERE id=id");
if (!$song) {
exit('Error Fetching Song Details: ' . mysql_error() . '</p>');
}

$song = mysql_fetch_array($song);

$url = $song['url'];
$url = htmlspecialchars($url);
?>

How do I grab each individual row in my database by the id. The code above only seems to output 1 entry. Any clues?

[bradgrafelman]

inulled wrote:

The code above only seems to output 1 entry.

That's because you only retrieve the first result from the result set. If you want to get all results from the result set, then you have to call the 'fetch' function until it returns FALSE (indicating you've reached the end of the set).

Also, if you're wanting to select all rows, why have a WHERE condition at all?

[inulled]

That would do it... Lol thanks man