combine two rows for menu!!!

[vent]

trying to combine first and last name for drop down menu. Got it working for on but it does not work with two!!! i can get a $fullname to print but not in the menu...

any help would be great.

code:
<?
include("../conf.php");
include("../functionstwo.php");

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");

$resulttwo=mysql_query("SELECT first_name, last_name_FROM_users ORDER BY first_name");

while ($row = mysql_fetch_array($resulttwo)) {
$first_name = $row['first_name'];
$last_name = $row['last_name'];

if ($first_name != "") {
$fullname = trim("$first_name $last_name");
} else {
$fullname = trim("$last_name");
}

$display_story .= "$fullname, $first_name $last_name<BR>";

$row_array=mysql_fetch_row($resulttwo);
$string='<select name=photographers><option value=>pick photographer</option>';

for ($i=0;$i<mysql_num_rows($resulttwo);$i++)
{
if ($row_array[0]=="")
{
$row_array=mysql_fetch_row($resulttwo);
}
else{
$string .='<option value="'.$row_array[0].'">'.$row_array[0];
$row_array=mysql_fetch_row($resulttwo);}
}
}
$string .='</SELECT>';
echo $string;
echo "<br>
$display_story";
?>

[kevinsequeira]

i dont understand the logic in the while loop cause you are using mysql_fetch_array inside the loop quite a few time thus moving to the next record inside the loop rather than letting the loop do it for you.

try this

<?php
print("<select name=photographers>");
print("<option value=0>pick photographer</option>");
while ($row = mysql_fetch_array($resulttwo)) {
  $first_name = $row['first_name'];
  $last_name = $row['last_name'];
  if ($first_name != "") {
  	$fullname = $first_name." ".$last_name;
  } else {
  	$fullname = $last_name;
  }
		$fullname = trim($fullname);
  print("<option value=".$row[0].">".$fullname."</option>");
}
print("</select>"); 
?>

reg
kevin

[vent]

thanks i got this working before and gonna stick with it for now. will try yours out later on as i tlooks a lot neater.

what i got=
<?
include("conf.php");
include("functionstwo.php");

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");

$resultone=mysql_query("SELECT lname_FROM_geluser ORDER BY lname");

$resulttwo=mysql_query("SELECT fname, lname_FROM geluser ORDER BY fname");

$row_array=mysql_fetch_row($resulttwo);
$row_arraytwo=mysql_fetch_row($resultone);
$string='<select name=photographers><option value=>pick photographer</option>';
for ($x=0;$x<mysql_num_rows($resultone);$x++)
for ($i=0;$i<mysql_num_rows($resulttwo);$i++)
{
if ($row_array[0]=="")
{
$row_array=mysql_fetch_row($resulttwo);
$row_arraytwo=mysql_fetch_row($resultone);

}
else{
$string .='<option value="'.$row_array[0].' '.$row_arraytwo[0].'">'.$row_array[0].' '.$row_arraytwo[0];
$row_arraytwo=mysql_fetch_row($resultone);
$row_array=mysql_fetch_row($resulttwo);}
}

$string .='</SELECT>';
echo $string;
?>