mysql_num_rows() error.....
Posted: Sat Mar 13, 2004 2:40 pm
hi
when i run the following query:
$result = mysql_db_query( $thisdb, 'SHOW fields FROM $tablename");
$num = mysql_num_rows( $result);
i get the following error:
Warning: mysql_num_rows(): supplied arguement is not a valid MySQL result resource
I have echoed out the query and it knows what the variables are and it runs fine in MySQL front.
Can anyone help?
when i run the following query:
$result = mysql_db_query( $thisdb, 'SHOW fields FROM $tablename");
$num = mysql_num_rows( $result);
i get the following error:
Warning: mysql_num_rows(): supplied arguement is not a valid MySQL result resource
I have echoed out the query and it knows what the variables are and it runs fine in MySQL front.
Can anyone help?