simple query question

[knowram]

Say I have a table named "Names" with 2 columns Name and date. in that table there are two rows the first has Sam in the name column and 4/23/07 in the date column. the second row also has Sam in the dame column but it has 4/24/07 in the date column. When I use the query I know select * from Names where Name = 'Sam' I get the values of the first row.

 

how do i get the info from the second row or move to the next row that has Sam in the Name column?

 

Thanks for the help

[benjaminbeazy]

$sql = "SELECT * from `Names` WHERE `Name`='Sam'";
$result = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_object($result)){
  echo "{$row['name']}, {$row['date']}<br/>";
}

[knowram]

Thanks i know it was simple i just haven't done it yet