mysql_fetch_array Error Message

[tomraffe]

Im getting the error message.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\websites\1130\e-discounts.co.uk\cms6\content\admin.php on line 308

Any ideas why this is? And a solution?
register_globals apparently needs to be on and I think it is. Would this be causing the error? Any ideas on how to find out if it is on or not?

The line in question is
while (list($LID, $Website, $URL) = mysql_fetch_array($query)) {

Cheers,
Tom

[pyro3k]

mysql_fetch_array returns an array of results

while (list($LID, $Website, $URL) = mysql_fetch_array($query)) {

^ you cant use it in this fashion

try using

while ($row = mysql_fetch_array($query)) {

then comparing the $row array with your list

[samudasu]

It means that something is wrong with query. This could be due to a bad query, database selection, or a failed mysql connection.

You should code similar to this to find where the problem exists:

mysql_connect('host', 'username', 'pass') or die('can\'t connect');
mysql_select_db('database') or die('can\'t select database');
mysql_query($sql) or die('sql query failed');

[herve]

Yes, as samudasu said, there's an error in your SQL query.

If you dynamically create your SQL query, you can put a

$cmd = "SELECT * FROM mytable WHERE ".$somevar."=".$somevalue;
print $cmd;

Before the mysql_query() call.

This will show you the exact SQL query you're trying to run.

If the syntax error is not that obvious at that time, then try to add a

print mysql_error();

just after your mysql_query() call.

This will show you the exact error inside the SQL query.