Error in script

[cmaclennan]

Hi Guys,

 

Hoping someone can shed some light on this for me I have a page to search for open tickets in a database but I get the warning when i load the page: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\open_search.php on line 25

 

here is the portion of code I am working with around line 25.

 

// Count the number of records
$query = "SELECT COUNT(*) FROM tickets WHERE status='Open' ORDER BY category ASC";
$result = @mysql_query ($query);
$row = mysql_fetch_array ($result, MYSQL_NUM);
$num_records = $row[0];

 

Thanks in advance for your help.

[Ken2k7]

Something's wrong with the query.

 

Use this -

// Count the number of records
   $query = "SELECT COUNT(*) FROM tickets WHERE status='Open' ORDER BY category ASC";
   $result = mysql_query ($query) or die(mysql_error());
   $row = mysql_fetch_array ($result, MYSQL_NUM);
   $num_records = $row[0];

 

Any errors from that?

[cmaclennan]

Thanks that worked, much appreciated as always.