Why Doesn't This Work?

[Dysan]

Why doesn't this work? - I'm trying to display just the letter M if record contains Male, and F id the record contains Female.

 

$record = 1;
while($row = mysql_fetch_array($result))
{
  $sex = substr($row['Sex'], 0, 1;
  echo "<tr>";
  echo "<td>" . $record++ . ") " . $row['Firstname'] . "<br>" . $row['Lastname'] . "</td>";
  echo "<td>" . $sex . "</td>";
  echo "</tr>";
}
echo "</table>";

[pocobueno1388]

You didn't close the substr() function.

 

$sex = substr($row['Sex'], 0, 1);

 

[Barand]

That should have given you

 

"Parse error: syntax error, unexpected ';' in C:\Inetpub\wwwroot\test\xxxxxx.php on line 4"

 

which tells you immediately there is a problem there - perhaps something missing before the ';' ?

 

If it didn't I recommend you turn your error reporting on.