[SOLVED] Extract Row

[Clinton]

If I use the extract(row) function how do I change the following to recognize that?

 

<? if ($row{'dob'}=='0000-00-00') echo " "; else echo date('n/j/Y',strtotime($row{'dob'})); ?>

[Barand]

Use $dob in place of $row['dob']

[Clinton]

That makes sense. I gave it a shot, however, and I"m getting an error:

 

Parse error: syntax error, unexpected T_IF, expecting ',' or ';' in /trainingreport.php on line 31

 

<?php while ($row=mysql_fetch_assoc($result)){
extract($row);
echo"<tr> <td>$lname $fname $mname</td> <td>" if ($dob=='0000-00-00') echo " "; else echo date('n/j/Y',strtotime({$dob})); "</td> <td>$cdl</td> </tr>";
}
?>

[jonsjava]

forgot a semicolon.

<?php while ($row=mysql_fetch_assoc($result)){
extract($row);
echo"<tr> <td>$lname $fname $mname</td> <td>"; if ($dob=='0000-00-00') echo " "; else echo date('n/j/Y',strtotime({$dob})); "</td> <td>$cdl</td> </tr>";
}
?>

[Clinton]

Oh the power of a semicolon. Your English teacher would be proud. :-) What about this one?

 

Parse error: syntax error, unexpected '{', expecting ')' in trainingreport.php on line 31

[Clinton]

Never mind. Got it. :-) Thanks a million folks.

[jonsjava]

didn't need the brackets in strtotime

<?php while ($row=mysql_fetch_assoc($result)){
extract($row);
echo"<tr> <td>$lname $fname $mname</td> <td>"; if ($dob=='0000-00-00') echo " "; else echo date('n/j/Y',strtotime($dob)); "</td> <td>$cdl</td> </tr>";
}
?>