Rechercher php
cabyge
Messages postés
22
Statut
Membre
-
cabyge Messages postés 22 Statut Membre -
cabyge Messages postés 22 Statut Membre -
voila j'aimerais effectuer une recherche par le sexe des personne inscrite mais il ne poste rien; le probleme vient de ou? l'affichage et la requete?
<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbbase = "rencontre";
$connexion = mysql_connect("$dbhost","$dbuser","$dbpass");
$connect=mysql_select_db($dbbase);
if(isset($_POST['sexe']))
{
$sexe=$_POST['sexe'];
$req="SELECT * FROM inscrit WHERE 'sexe' like '$sexe';";
$result=mysql_query($req);
if(!mysql_num_rows($result))
{echo "Personne trouvée!";
}
else
{echo "$result";}
}
?>
<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbbase = "rencontre";
$connexion = mysql_connect("$dbhost","$dbuser","$dbpass");
$connect=mysql_select_db($dbbase);
if(isset($_POST['sexe']))
{
$sexe=$_POST['sexe'];
$req="SELECT * FROM inscrit WHERE 'sexe' like '$sexe';";
$result=mysql_query($req);
if(!mysql_num_rows($result))
{echo "Personne trouvée!";
}
else
{echo "$result";}
}
?>
1 réponse
-
probleme resolu
if(isset($_POST['sexe']))
{
$sexe=$_POST['sexe'];
$req="SELECT * FROM inscrit WHERE sexe like '%".$sexe."%';";
$result=mysql_query($req);
if(!mysql_num_rows($result))
{
echo "Personne trouvée!";
}
else
{
echo"<table width=400 border=3>";
while ($val= mysql_fetch_array($result))
{
echo "<tr><td>";
echo $val["nom"];
echo "</div></td></tr>";
}
}
}
