code not working anymore

[sjm08]

$result=mysql_query("select * from express_interest WHERE id=$id");

$name=mysql_result($result,0,"name");

$id=mysql_result($result,0,'id');

$message=mysql_result($result,0,"message");

$email=mysql_result($result,0,"email");

print mysql_error();

?> ??? ??? ???

[fenway]

Move the mysql_error() line to the _query() line in a die() statement.

[rhodesa]

What "isn't working" about it? Blank page, is it printing an error? Where is $id set and what is it's value?

 

And it won't work one second and not the next. Something changed. I would make sure error reporting is on and do what fenway says (which is to change the code to the following:

 

<?php
$result=mysql_query("select * from express_interest WHERE id=$id")
  or die("MySQL Error: ".mysql_error());
$name=mysql_result($result,0,"name");
$id=mysql_result($result,0,'id');
$message=mysql_result($result,0,"message");
$email=mysql_result($result,0,"email");
?>