[SOLVED] Adding If statement to while statement

[ifis]

I have an array that dispalys information a specific user has inputed into the table.  I want the users to be able to update the passed field if it is blank.  So I want to add an if statement that says if Passed == 'null' {echo "form..."} else echo ". $row['Passed?'] . "

How would I do it?  Here is the code I currently have.

$sql = "SELECT * FROM Endorsementlog WHERE Username= '{$_SESSION['myusername']}'";
$result=mysql_query($sql);

echo "<h3>Endorsement Log:</h3>";
echo "<table border='0'>
<tr>
<th>Date</th>
<th>Student</th>
<th>Endorsement</th>
<th>Passed</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Date'] . "</td>";
  echo "<td>" . $row['Student'] . "</td>";
  echo "<td>" . $row['Endorsement'] . "</td>";
  if ( $row['Passed?'] .== 'null')
echo"<form id='elog' name='form2' method='post' action=''>
  <select name='Passed?' id='Passed?'>
    <option>Yes</option>
    <option>No</option>
  </select>
</form>";
else
  echo "<td>" . $row['Passed?'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>

Any suggestions?  Thanks

[papaface]

You have no {} on your if/else statement.

[ifis]

I added the {, but am getting the message:"Parse error: parse error, unexpected '.' "

if I take out the '.', will it still sequence to the next row?  Here is the current code.

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Date'] . "</td>";
  echo "<td>" . $row['Student'] . "</td>";
  echo "<td>" . $row['Endorsement'] . "</td>";
  if (. $row['Passed?']== 'null')
  {
echo"<form id='elog' name='form2' method='post' action=''>
  <select name='Passed?' id='Passed?'>
    <option>Yes</option>
    <option>No</option>
  </select>
</form>";
}
else
{
  echo "<td>" . $row['Passed?'] . "</td>";
  	}
  echo "</tr>";
echo "</table>";

 

[revraz]

Remove all those periods.

[papaface]

Should be:

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Date'] . "</td>";
  echo "<td>" . $row['Student'] . "</td>";
  echo "<td>" . $row['Endorsement'] . "</td>";
  if ($row['Passed?']== 'null')
  {
echo"<form id='elog' name='form2' method='post' action=''>
  <select name='Passed?' id='Passed?'>
    <option>Yes</option>
    <option>No</option>
  </select>
</form>";
}
else
{
  echo "<td>" . $row['Passed?'] . "</td>";
  	}
  echo "</tr>";
echo "</table>";

[ifis]

Thanks, i got to that code.  But I am still getting the error message:"Parse error: parse error, unexpected $ in ... on line 233."  Line 233 is after the last line of the code.  I think this means I probably have an undefined variable somewhere.

[revraz]

Means you have a open bracket some where } ] )

[ifis]

Just found that missed }.  Thanks for the help!