MYSQL error

[ggp]

Hi.

I am getting this error. Could you help plzz? thanks

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Online Services\Apache2\htdocs\searchexample1.php on line 49

line49: while ($row = mysql_fetch_array($result))


[HTML]
[/PHP]


<?php

$sql = ("SELECT * FROM ..... WHERE .....");

$conn = mysql_connect("","") OR DIE (mysql_error());
mysql_select_db("cartonlots", $conn) OR DIE (mysql_error());

$result = mysql_query ($sql, $conn);
echo "<TABLE BORDER=2>";

while ($row = mysql_fetch_array($result))
{
echo "<TR><TD>".$row["image_id"]."<TD>".$row["smdescription"]; }

echo "</TABLE>";
?>


[/PHP]
[/HTML]

[Fumigator]

Check your query to see if it failed and if it did print mysql_error().

[ggp]

Is not error there sorry it says warning.

[Fumigator]

Your query is failing but you didn't bother to check to see if it is failing, you're just going right in to trying to use the query's resource, which isn't a valid resource, because the query failed, so you are getting a warning about the resource not being valid, which is being caused by your query failing, which you are not checking on.