[SOLVED] Guys, what am I doing wrong?

[ballhogjoni]

I have this code here, but it only shows the first record in the db. I know there are multiple records that meet this criteria. What am I doing wrong?

 

$query = mysql_query("SELECT email, fname, lname FROM pageOneInfo_Test WHERE date = '".$date."' AND soldProductTo = '0'") or die(mysql_error());
$row = mysql_fetch_array($query);
echo $row['email'].'<br>'.$row['fname'];

[p2grace]

You need to throw it in a while statement.

 

<?php
$query = mysql_query("SELECT email, fname, lname FROM pageOneInfo_Test WHERE date = '".$date."' AND soldProductTo = '0'") or die(mysql_error());
while($row = mysql_fetch_assoc($query)){
  extract($row);
  echo $email.'<br>'.$fname;
}
?>