problem with code

[Ladydee]

I am trying to et the name and email address from MySql. Part of this is working, I am getting the emall address but not the name.
Here is the code I am using:

Code: Select all

<?php
   
      $sql = "select * from subscribers";

   $result = mysql_query($sql);
   $num_rows=mysql_num_rows($result);
   echo "<div align=right class=FormTitle>Total No. of Customers : " . $num_rows."</div>";
   $sno = 0;
$noofrecord = mysql_num_rows($result);
if ($start == "" && $end == "")
{
   $start = 1;
   $end = 20;
}

   while($row=mysql_fetch_array($result))
   {
   if ($id == $end)
   {
break;
   }
     
    $id++;
   
    $id = $row["id"];
    $email = $row["email"];
   $name = $row["name"];
   
   

echo "<tr class=TableFields><td>$email<td>$name</td>";
echo "<td class=LinkText align=center><a href=newsmailerlist.php?action=2&email=$email>Edit</a></td>";
echo "<td class=LinkText align=center><a href=newsmailerlist.php?action=3&email=$email>Delete</a></td>";

}
   
?>

Can someone tell me what I need to change or add to make this work?

Thank you Ladydee

[KingCrunch]

What you get instead of "name"? Try vardump($row);