Display Data From MySQL Table

$query = "SELECT * FROM customers where id='$id'";
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
$result = mysql_query($query) or die("Couldn't execute query");

while ($row= mysql_fetch_array($result))
{
$id= $row["id"];
$fname= $row["fname"];
$lname= $row["lname"];
$name=$fname." ".$lname;
$phone= $row["phone"];
$email= $row["email"];
$address= $row["address"];
$dd= $row["dd"];
$dm= $row["dm"];
$dy= $row["dy"];
}