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>";

[kakki]

change this

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

to this

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

[Dysan]

Oh yeah, no semi colon. Cheers!

Using CSS & the following code, how do I display the 3 piece of information retrieved from the database, in different colours?

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

[kakki]

thats for one @ least

echo '<td style="background-color:#FFDDDD; ">'.$record++ . ") " . $row['Name'] . "<br>";

[Dysan]

How do I change the text colour of the following, so they are all displayed using different colours:

e.g

• Firstname displays in red

• Lastname displays in green

• Sex displays in blue

[kakki]

$record = 1;
while($row = mysql_fetch_array($result))
{
  $sex = substr($row['Sex'], 0, 1);
  echo "<tr>";
  echo '<td style="background-color:#FF0000; ">';

echo  $record++;
echo ')';
echo '</td><td style="background-color:#00FF00; ">';
 echo $row['Name'] ;
echo '</td><td>';
  echo $row['Species'] 
echo '</td><td style="background-color:#0000FF; ">';
 " (" . $sex . ")" . 
echo '</td>';
  echo "</tr>";
}
echo "</table>";

[kakki]

you may have to format that ;-)