read db error

[anfetienne]

i have this code that reads a database so i can echo specific things back to the page....i had help on it before and when i left the code it was working i go back to it to check it works and it wont display any values from the db on a page

here is the code

<?
$errorM = '<div align="center"><h2><center>NOTE: Please make sure that you have saved your editorial before uploading any images.</center></h2></div>';

$user="********";
$pass="********";
$data="auctionTemps";

mysql_connect(localhost,$user,$pass);

@mysql_select_db($data) or die( "Unable to select database");

// Select column 1 from table name where column name = $your_var.
$sql = "SELECT * FROM savedTemps WHERE tempID = '{$tempID}'";
// If mysql_query returns false, we'll die with the error.
$result = mysql_query( $sql ) or die( mysql_error );
 
// If a there is a match
if ( mysql_num_rows( $result ) > 0 )
{
$row = mysql_fetch_array( $result );

}

else{
echo $errorM;
}

mysql_close();
?>

I am using <? echo $row['title'];?> to show values to a page.....is something wrong? should it be print instead of echo?

[Markus]

or die( mysql_error );

// should be:
or die( mysql_error() );

Do a print_r() on $row to see it's contents.

[anfetienne]

like this print_r($row)?

[Markus]

like this print_r($row)?

yes .

[anfetienne]

ok thanks again markus