[SOLVED] php/html help

[will35010]

I'm using this code to populate a select box. I want the names to show up as last name, first name and the dl field hidden. I want to use dl as the value since it will always be unique. Thanks.

 

function getDrivers()
{
$sql = "SELECT fname, lname, dl FROM drivers";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['fname']."\">".$row['lname']."\n  ";
}

[lonewolf217]

<?php
function getDrivers()
{
   $sql = "SELECT fname, lname, dl FROM drivers";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"$row['dl']\">".$row['lname'].",".$row['fname']."</option>";
}

[Alex]

Well, if it's a function you want it to return, rather than echo.. right?

 

function getDrivers()
{
$sql = "SELECT fname, lname, dl FROM drivers";
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
  $list .= '<option value="' . $row['dl'] . '">' . $row['lname'] . ', ' . $row['fname'] . '</option>';
}
return $list;
}

[will35010]

Thanks!!!