Compter des lignes dans une table ! (View Single Post)

**Spycam** · #2 01-07-2004, 18:02

Code:

require("confmysql.php");
$mysql_link = mysql_connect("$sql_serveur", "$sql_user", "$sql_password");
$requete = "SELECT COUNT(id) FROM $sql_table WHERE etat = occaz";
$result = mysql_db_query("$sql_bdd", $requete);
mysql_close($mysql_link);
echo "$result voiture(s)";

Je ferais çà :

Code:

require("confmysql.php");
$mysql_link = mysql_connect("$sql_serveur", "$sql_user", "$sql_password");
$requete = "SELECT * FROM $sql_table WHERE etat = 'occaz'";
$result = mysql_query($requete);
mysql_close($mysql_link);
$voiture=mysql_num_fields($result);
echo ($voiture." voiture(s)");

ou alors çà ( + lourd ) :

Code:

require("confmysql.php");
$mysql_link = mysql_connect("$sql_serveur", "$sql_user", "$sql_password");
$requete = "SELECT * FROM $sql_table WHERE etat = 'occaz'";
$result = mysql_query($requete);
mysql_close($mysql_link);
$voiture=0;
while(mysql_fetch_array($result) ==TRUE)
{ $voiture++; }
echo ($voiture." voiture(s)");

C'est à tester...