I've done the searching

[bobo]

here is a full example that I actually use on my local server. Excuse the french text
where you see the include of connection.php, you wont need that, this is the same connection stuff as above.

<table width="560" border="0" cellspacing="1" cellpadding="2">
   <tr bgcolor="#c7c7c7">
   <td width="160" align="center" class="reg_font">Nom</td>
   <td width="180" align="center" class="reg_font">Courriel</td>
   <td width="110" align="center" class="reg_font">T&#233;l&#233;phone</td>
   </tr>
	<?php
	include "connection.php";
	$query = "select * from contacts where id != '3' order by lname";
	$Statement = mysql_query($query);
	while($myid = mysql_fetch_array($Statement)) {
	$the_id = $myid["id"];
	$last_name = $myid["lname"];
	$first_name = $myid["fname"];
	$email = $myid["e_address"];
	$phonenum = $myid["phone"];
	if($bg == "#ededf7"){
	$bg = "#e7e7e7";
	}else{
	$bg = "#ededf7";
	}
	if(empty($phonenum)){
	$phonenum = "&nbsp;";
	}
	echo "<tr bgcolor=\"".$bg."\">\n";
	echo "<td class=\"reg_font\">".$last_name.", ".$first_name."</td>\n";
	echo "<td class=\"reg_font\"><a href=\"mailto:".$email."\" class=\"link_font\">".$email."</a></td>\n";
	echo "<td class=\"reg_font\">".$phonenum."</td>\n";
	echo "<tr>\n";
	}
	?>
	</table>