[SOLVED] Erro with mysql_fetch_array?

[cmaclennan]

Hi Guys, I have a form that displays a list of database entries and I am getting the following error:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\show_rma.php on line 23

 

 

here is the code:

// Count the number of records
$query = "SELECT COUNT(*) FROM rma ORDER BY date ASC";
$result = mysql_query ($query);
$row = mysql_fetch_array ($result, MYSQL_NUM);
$num_records = $row[0];

 

 

Thanks

 

[Maq]

Even though your SQL syntax is correct, change your query to:

 

$result = mysql_query($query) or die(mysql_error());

 

It should display any errors.

 

You can also echo out your $query to see what exactly you're passing through.

[cmaclennan]

Thanks that did the trick I found my problem. Much Appreciated as always

[Maq]

Thanks that did the trick I found my problem. Much Appreciated as always

 

Sure np, do you mind sharing what it was?

 

Please mark topic solved, thanks.

[cmaclennan]

It was my own fault i had mistyped the table name.

[Maq]

It was my own fault i had mistyped the table name.

 

Doh!    That's what I was thinking because your syntax was correct.