Fetching Single Row

[eugene2009]

i ran into a problem...

 

Just a quick narrowed down example..

$query = mysql_connect ($db_hostname, $db_username, $db_pass) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($db_name);

$id = $_GET['id']; //gets the id from url

$query = "SELECT * FROM comments WHERE id='$id'"; //select records with passed id
$result = mysql_query($query); //perform the query
$row = mysql_fetch_row($result);


echo 'The customers name is, '.$row['name'].' and he made a purchase on, '.$row['date'].'.<BR>';

?>

What am I doing wrong?

[Zyx]

Just a quick look to the manual should help:

 

http://docs.php.net/mysql_fetch_row

 

mysql_fetch_row() returns an array with numerical indexes. The function you are looking for is mysql_fetch_assoc().

 

BTW. Do not create so many variables when you do not need them and use some form of error reporting:

 

$result = mysql_query('SELECT * FROM `comments` WHERE `id` = \''.$_GET['id'].'\'') or die(mysql_error());
if($row = mysql_fetch_assoc($result))
{
    // row fetched
}
else
{
    // no results
}

 

That's much better...