Help with a specific mysql error...

Gremmie · 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>';

spyrule · 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.