Help with a specific mysql error...

registered · Posted: Sun Aug 26, 2007 9:35 pm

Remove the line that has the first $db->sql_fetchrow(). You want to only call $db->sql_fetchrow() inside your loop. That is why you are loosing the first row. Something like this:

Code:




$sql3 = "SELECT DispositionCode FROM ".$prefix."_SunMediaManualPhoneListDispositionCodes";


$result3 = $db->sql_query ($sql3) or die(mysql_error());





echo '<select name="outcome">';


while ($row3 = $db->sql_fetchrow($result3)) { 


   echo '<option>'.$row3["DispositionCode"].'</option>'; 


}


echo '</select>';

Worker Joined: Jun 06, 2006 Posts: 105

Awww yeah!,

Thank you so VERY VERY much. I have been beating my brain for the better part of an hour of that stupid little trick! LOL!.

huhhhhh... now I just gotta dump this info back into the Db. lol.