MySQL-Link resource error

[meeble]

I have the code:

$result = mysql_query("SELECT * FROM jobs order by jobnumber",$db);

while ($myrow = mysql_fetch_row($result)) {

echo blah

}

This brings up the error:

PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\

http://wwwroot\test\job_view.php

on line 22 PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\inetpub\

http://wwwroot\test\job_view.php

on line 24

What is causing these errors and why won't it work?

Many thanks

James

 

[sleipnir214]

Insufficient data for a meaningful answer.

Check to see whether mysql_query() has set $result to FALSE, and if so output the return of mysql_error(). Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!