[SOLVED] Count Num rows

[SirChick]

Hey, i made a sql to count the number of rows found but it says its not a valid supplied arguement....

Not sure how its typed correctly but this is how i done it:

 

$CountRows = "SELECT * FROM messages WHERE Reciever='$Username'";
			$numrows = mysql_num_rows($CountRows);

			If ($numrows == 3){
			Die('3 is max');
			}

 

The Error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\composeletterprocess.php on line 37

 

[Orio]

You need to run the query first

mysql_query($CountRows);

 

Orio.

[SirChick]

$CountRows = "SELECT * FROM messages WHERE Reciever='$Username'";
			mysql_query($CountRows);
			$numrows = mysql_num_rows($CountRows);

			If ($numrows == 3){
			Die('The letter box that belongs to this user is full, perhaps upgrade to better means of communication on the game?');
			}

 

Still getting the problem though =/

[darkfreaks]

are you connecting to your database using mysql_select_db? otherwise it wont connect.

[mattal999]

try:

 

$CountRows = "SELECT * FROM messages WHERE Reciever='$Username'";
			$numrows2 = mysql_query($CountRows);
			$numrows = mysql_num_rows($numrows2);

			If ($numrows == 3){
			Die('The letter box that belongs to this user is full, perhaps upgrade to better means of communication on the game?');
			}

[envexlabs]

The post above has it right.

 

you weren't putting the mysql_query into a variable.

 

to make things easier try going like this:

 

$myquery = mysql_query('SELECT * FROM `table`');

$matt = mysql_num_rows($myquery);

 

Just alot simpler