Crazy While Behavior

[thines]

I can't seem to see the issue...

$q2="SELECT id,handle from i6users where type = 2";
  $result2 = mysql_query($q2,$i6link) or die (mysql_error());

 echo"
 <table width=100%>
 <tr>
     <td class=lightblue>Type</td>
     <td class=lightblue>Selection</td>
 </tr>
 <tr>
 <td>Selling Realtor</td>
 <td><select name=\"i6f[SellingRealtor]\">";
 while ($row2 = mysql_fetch_object($result2)){
 echo "<option value=\"$row2->id\">$row2->handle</option>";
 }
 echo "
 </select>
 </td>
 </tr>
 <tr>
 <td>Buying Realtor</td>
 <td><select name=\"i6f[BuyingRealtor]\">";
 while ($row2 = mysql_fetch_object($result2)){
 echo "<option value=\"$row2->id\">$row2->handle</option>";
 }
 echo "
 </select>
 </td>

It populates the first select box, but not the second.

Please help!

Thanks

-Tim

[stolzyboy]

its because you used your query array up in the first while loop, to get the results you want simply duplicate the query and call it something different and run the result and while loop

[thines]

Thanks.

But, now I have this and the first one doesn't populate.

 echo"
 <table width=100%>
 <tr>
     <td class=lightblue>Type</td>
     <td class=lightblue>Selection</td>
 </tr>
 <tr>
 <td>Selling Realtor</td>
 <td><select name=\"i6f[SellingRealtor]\">";
 $q_7="SELECT id,handle from i6users where type = 2";
   $result_7 = mysql_query($q_7,$i6link) or die (mysql_error());
 while ($row_7 = mysql_fetch_object($result_7)){
 echo "<option value=\"$row2->id\">$row2->handle</option>";
 }
 echo "
 </select>
 </td>
 </tr>
 <tr>
 <td>Buying Realtor</td>
 <td><select name=\"i6f[BuyingRealtor]\">";
 $q2="SELECT id,handle from i6users where type = 2";
   $result2 = mysql_query($q2,$i6link) or die (mysql_error());
 while ($row2 = mysql_fetch_object($result2)){
 echo "<option value=\"$row2->id\">$row2->handle</option>";
 }
 echo "
 </select>
 </td>
 </tr>
 <tr>
 <td>Title Company</td>
 <td>Option</td>
 </tr>
 <tr>
 <td>Buyer's Insurance Company</td>
 <td>option</td>
 </tr>
 </table>
 ";

[thines]

my bad......i got it.

[stolzyboy]

this

echo "<option value=\"$row2->id\">$row2->handle</option>";

needs to be this

echo "<option value=\"$row_7->id\">$row_7->handle</option>";

[leatherback]

Hi,
If you fill a variable, you could populate both select boxes with one query, and you ca seperate the querying more from the page coding, keeping the whole thing a bit clearer to de-bug.:

$seller = "<select name=\"i6f[SellingRealtor]\">";
$buyer = "<select name=\"i6f[BuyingRealtor]\">";


$q_7="SELECT id,handle from i6users where type = 2"; 
    $result_7 = mysql_query($q_7,$i6link) or die (mysql_error()); 

while ($row_7 = mysql_fetch_object($result_7))
  { 
  $seller .= "<option value=\"$row_7->id\">$row_7->handle</option>";
  $buyer .= "<option value=\"$row_7->id\">$row_7->handle</option>";
  }

$buyer .= "</select>";
$seller .= "</select>";

echo $buyer;
echo $seller;