SECLECT COUNT

[Anon]

Hello,

how can I count results from a query?

			$result="SELECT us_contact.nom,us_contact.prenom,us_commande.id_commande
					 FROM us_contact
					 LEFT JOIN us_commande ON us_commande.email=us_contact.email
					 WHERE id_soiree='$id_soiree' AND n_validation>=2 AND n_validation<4
					 ORDER BY nom,prenom";
			$Query=mysql_query($result);
			$row=mysql_result($Query);
			echo count($row);

[[deleted]]

mysql_num_rows($row);
will return a integer.

http://www.php.net/manual/en/function.mysql-num-rows.php , for more infos.

ali

[Anon]

Thanks for your help but it does not seem to work:

			$result="SELECT us_contact.nom,us_contact.prenom,us_commande.id_commande
					 FROM us_contact
					 LEFT JOIN us_commande ON us_commande.email=us_contact.email
					 WHERE id_soiree='$id_soiree' AND n_validation>=2 AND n_validation<4
					 ORDER BY nom,prenom";
			$Query=mysql_query($result);
			$row=mysql_result($Query);
			$num=mysql_num_rows($row);
			$tables=$num/2;

[[deleted]]

$result="SELECT us_contact.nom,us_contact.prenom,us_commande.id_commande
FROM us_contact
LEFT JOIN us_commande ON us_commande.email=us_contact.email
WHERE id_soiree='$id_soiree' AND n_validation>=2 AND n_validation<4
ORDER BY nom,prenom";
$Query=mysql_query($result);
$num=mysql_num_rows($Query);
$tables=$num/2;

sorry for this untreansperency, but i have little problems reading you code. Better would be:

$sql="SELECT us_contact.nom,us_contact.prenom,us_commande.id_commande
FROM us_contact
LEFT JOIN us_commande ON us_commande.email=us_contact.email
WHERE id_soiree='$id_soiree' AND n_validation>=2 AND n_validation<4
ORDER BY nom,prenom";
$result=mysql_query($sql);
echo $intNumRows = mysql_num_rows($result);
...

give it a try.

your mistake were:
$Query=mysql_query($result);
$row=mysql_result($Query);

both lines do "execute" a sql command. i deleted one of them in both versions written above.

ali