sudden errors ?

[Anon]

hey, i just got some wierd results.. ive been working on a script and its been working perfectly, so i restarted the server and now it says that ive got errors.. the exact errors are:

Warning: Supplied argument is not a valid MySQL result resource in C:\HTTPD\HTDOCS\slothdog\scripts\catalog.php on line 9

Warning: Supplied argument is not a valid MySQL result resource in C:\HTTPD\HTDOCS\slothdog\scripts\catalog.php on line 10

Warning: Supplied argument is not a valid MySQL result resource in C:\HTTPD\HTDOCS\slothdog\scripts\catalog.php on line 14

the lines in question are (rows 7 - 25):

$query_string = "select * from dvds order by title";
$result = mysql_query($query_string);

->trouble:$column_count = mysql_num_fields($result);
->trouble: $row_count = mysql_num_rows($result);

$counter=1;

->trouble: while ($row = mysql_fetch_object($result)) {
$title=$row->title;
$studio=$row->studio;
$description=$row->description;
$image=$row->image;
$length=$row->length;
$buy=$row->cart;
$quanity=$row->quanity;

for ($column_num = 0;
$column_num < $column_count;
$column_num++)

it all worked fine earlier.. i didnt change anything, i just restared the machine.

[examancer]

for some reason your MySQL query is not completing successfully... maybe cause you aren't connected to the database or something.

[Anon]

i put in a line to echo connected sucessfully or not successfully and it comes up successfully every time.

[[deleted]]

error checking helps:

if (!mysql_query($your_statement))
{
echo mysql_error();
}
else
{
//process results.
}