to display multiple records with same name

[vijy]

hai friends,

can anyone of you say to display multiple records with same name.for example if i am searching for name xxxxx.i have five records with same name xxxxx,but it displays only one...

can you help me........................

[penagate]

You'll need to elaborate: Records where? How are you retrieving them?
Post your code.

[vijy]

friend,
I am searching the data through name ..for example if i am searching for name sridhar.i have nine records in my table with same name sridhar but from different address,DOB,Email,...etc.according to my code it dipalys the frist record only not displaying nine records,thats my pbm. here is my code..


if(isset($_POST["submit"]))
{
$to_email=$_POST["email_surf"];
$to_nom=$_POST["nom_surf"];
$tab_compare="select * from particulier where email='$to_email' and nom ='$to_nom'";
$mysql_execute=mysql_query($tab_compare) or die(mysql_error());
$count_rows=mysql_num_rows($mysql_execute);

$i=1;
while($tb_info=mysql_fetch_array($mysql_execute))
{
$a_id=$tb_info[0];
$a_nom=$tb_info["nom"];
$a_prenom=$tb_info["prenom"];
$a_pays=$tb_info["pays"];
$a_email=$tb_info["email"];
}

}


this my table to display the records

<table cellpadding="0" cellspacing="0" border="1" width="669">
<tr>
<td align="center" width="99" bgcolor="#FFF0E1" class="f1">Nom</td>
<td align="center" width="100" bgcolor="#FFF0E1" class="f1">Prénom</td>
<td align="center" width="120" bgcolor="#FFF0E1" class="f1">Pays</td>
<td align="center" width="150" bgcolor="#FFF0E1" class="f1">E-mail</td>
<td align="center" width="120" bgcolor="#FFF0E1" class="f1">Détails complete</td>
<td align="center" width="80" bgcolor="#FFF0E1" class="f1">Effacer</td>
</tr>

<tr>
<td align="center" width="99" class="text"><?=$a_nom;?></td>
<td align="center" width="100" class="text"><?=ucfirst($a_prenom);?></td>
<td align="center" width="120" class="text"><?=ucfirst($a_pays);?></td>
<td align="center" width="150" class="text"><?=$a_email;?></td>
<td align="center" width="120" class="text"><a href="viewfullparticul.php? id=<?echo $a_id;?>"><img src="../images/view_img.png" width="16" height="16" alt="" border="0"></a></td>
<td align="center" width="80" class="text"><a href="delparticul.php?id=<?echo $a_id;?>" onClick="javascript:del()"><img src="../images/b_drop.png" width="16" height="16" alt="" border="0"></a></td>

can u help mee friend..


and another help can you able to send me sample query using NOT equal operator.i had used '!=' it but not working.
thank you for replying
yours friendly,
sridhar.R