ERROR in script

[russian_god]

<?
@ $db=mysql_connect("$host", "$username", "$pass");
if(!$db)
{
echo "could not connect to database";
}
$select=mysql_select_db("codec_db");
if(!$select)
{
echo "cant select";
}
$sql=mysql_query("SELECT * FROM tableNAME WHERE id=$id") or die(mysql_error());
if (mysql_num_rows($sql)=="1")
{
while ($row=mysql_fetch_array($sql)
{
echo"$row[message]";
}
}
if (mysql_num_rows($sql)==0)
{
echo "no rows";
}

?>

Why doesn't this script work???

[khaine]

what error is it returning?

[Anon]

I wonder - what happens if you move the '@' in the first line from where it is to just before the mysql_connect? Better yet, what happens if it's left off completely?

Does $id have a value?

Why do you have an entire while loop if there's only one record?

What happens if there is more than one record?

Like Mark says - what's happening now?

[russian_god]

OK!!!
HOW CAN I DISPLAY Message depending on $id number
##echo"$row[message]"; ##
when this script runs!

$id has a value!!!!!!

<?
@ $db=mysql_connect("$host", "$username", "$pass");
if(!$db)
{
echo "could not connect to database";
}
$select=mysql_select_db("codec_db");
if(!$select)
{
echo "cant select";
}
$sql=mysql_query("SELECT * FROM tableNAME WHERE id=$id") or die(mysql_error());
............
...........
............

?>

[khaine]

My version of a connect script looks like.

<?
$conn=mysql_connect(localhost, $username, $pass);
if(!$conn)
{
echo mysql_error();
exit;
}
$dbname=mysql_select_db("user", $conn);
if(!$dbname)
{
echo mysql_error();
exit;
}
$query="select * from table where id like '".$id."';";
$result=mysql_query($query, $conn);
if ( !$result )
{
echo mysql_error();
exit;
}

$fields=mysql_fetch_array($result);
?>

After this lot $fields hold an array of the first row of fields from the database.

Try this and see what happens.

Mark.