I'm attempting to use an if statment during a while mysql_fetch_array, however, the if statement only uses the first Record in the array. How do I make the decision process for each record?

// Printing results in HTML
while ($rows = mysql_fetch_array($result)) {
    extract ($rows);
    echo $JeffandMary;
    if ($jeffandmary = "Yes")
          echo "<p>Jeff and Mary</p>";
      else
           echo "<p>No</p>" ;
    }

Look more closely at that, you're using the assignment operator, not a comparison operator (e.g. '==').

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

also note that $rows is now an array (due to mysql_fetch_array), so to get specific records, use $rows[$i], where $i is an identifier to a specific record.

I think theres another function to allow you to reference the array as an associate array, for instance $row['id'], would return the record named 'id'. quite handy.

check the php website, http://www.php.net/array and http://www.php.net/mysql

Many shoes,

James/SiliconFuRy

i would like to know whether the code below really working?

while ($rows = mysql_fetch_array($result)) {
    extract ($rows);
    echo $JeffandMary;
    if ($jeffandmary = "Yes")
          echo "<p>Jeff and Mary</p>";
      else
           echo "<p>No</p>" ;
    }

I ask is because I have a similar code that want to compare the value in a row to a variables.Example I have var $emNo='000080';

then have a code :
$query = "select * from ACCOUNT order by ACC_ID";
$r = mysql_query($query);
while ($row = mysql_fetch_array($r, MYSQL_NUM)) {
if ($row[1] == $emNo){
return true;
}
else return false;


}//end while

My first record in Account table is EMP_NUM=00001. When I put the value emNo as ''00001', it can compare and return true. But when I put value emNo as '00080', it return false, where as the account table has the EMP_NUM=00080.
Looks like it always compare only the first row. What is wrong with my code?