number of logins

[fife]

Hi

 

I have this code and when I echo the count it shows 1 when theres actually 5.  Have I wrote it wrong

 

$loginsq = mysql_query("SELECT email FROM logindetails WHERE email = ".$_SESSION['MM_Username']."");
			  $logins = mysql_fetch_array($loginsq);
			$logs = count($logins);
			echo $logs;

[Psycho]

mysql_fetch_array() gets the next (i.e. one) record from the result set. You are only retrieving one field, "email", so the count() for any one record would only be 1. If you want the number of records in the query result set you would use

$logs = mysql_num_rows($loginsq);

[ravens_chance]

You can also just use you query to get your count:

$loginsq = mysql_query("SELECT COUNT(email) FROM logindetails WHERE email = ".$_SESSION['MM_Username']."");

[fife]

cool guys cheers