mysql_num_rows and related
Posted: Mon Jan 06, 2003 10:12 am
This is driving me crazy and i am so tired of working around it... can some one please tell me why every time i try to run "mysql_num_rows" it gives me the following message
---code---
$CheckButtonIN_QRY = "select * from tregON where Active = 1 and tempNav=1 and tempName='".$zoneitT."'";
$CheckButtonIN_Result = mysql_query($CheckButtonIN_QRY);
$rrr=mysql_num_rows(CheckButtonIN_Result);
---msg ---
* * * Supplied argument is not a valid MySQL result resource xxxxxxxx
i looked in the manual and i did not find any information about it being deprecated.!... yet it worked on another server that we had but it does not work now. Both are using teh same version of mysql.
i am having similar problem whenever i try to retrieve the fields, table names........ just about anything that does not have a SELECT, INSERT, or UPDATE.
if i am doing something wrong, please let me know so i can kik my self in the axx

---code---
$CheckButtonIN_QRY = "select * from tregON where Active = 1 and tempNav=1 and tempName='".$zoneitT."'";
$CheckButtonIN_Result = mysql_query($CheckButtonIN_QRY);
$rrr=mysql_num_rows(CheckButtonIN_Result);
---msg ---
* * * Supplied argument is not a valid MySQL result resource xxxxxxxx
i looked in the manual and i did not find any information about it being deprecated.!... yet it worked on another server that we had but it does not work now. Both are using teh same version of mysql.
i am having similar problem whenever i try to retrieve the fields, table names........ just about anything that does not have a SELECT, INSERT, or UPDATE.
if i am doing something wrong, please let me know so i can kik my self in the axx