[SOLVED] Dropdown from query. Always lists 1 missing.

[Greaser9780]

The following is some of my code for a dropdown box from a query. I tried ORDERing the info many ways. There are 12 names in the table but it always shows 11. What am I missing?

 

<select  name='1name'>

<?php

$sql1=mysql_query("SELECT * FROM draft_teams WHERE teamid > '0' ORDER BY name DESC") or die(mysql_error());

$res1=mysql_fetch_array($sql1);

$rst1=$res1['name'];

while ($res1 = mysql_fetch_array($sql1, MYSQL_ASSOC)){

  echo "<option value='" . $res1['name'] . "'>" . $res1['name'] . "</option>";

}

?>

</select><br>

 

[Yesideez]

Try this:

<select  name='1name'>
<?php
$sql1=mysql_query("SELECT * FROM draft_teams WHERE teamid > '0' ORDER BY name DESC") or die(mysql_error());
while ($res1 = mysql_fetch_array($sql1, MYSQL_ASSOC)){
   echo "<option value='" . $res1['name'] . "'>" . $res1['name'] . "</option>";
}
?>
</select>

[Orio]

You called mysql_fetch_array once before the loop, so one is "missing".

 

Try this:

<select  name='1name'>
<?php
$result1 = mysql_query("SELECT * FROM `draft_teams` WHERE teamid > 0 ORDER BY name DESC") or die(mysql_error());
while ($row = mysql_fetch_assoc($result1))
   echo "<option value='" . $row['name'] . "'>" . $row['name'] . "</option>";
?>
</select>

 

 

Orio.

[Greaser9780]

I think I get it. Because I called it outside the while loop already that's why it left one out.

[Yesideez]

You got it!

[Orio]

I think I get it. Because I called it outside the while loop already that's why it left one out.

Exactly

When one result "missing", in most cases it means you called mysql_fetch_array() before the loop.

 

lol Yesideez, I can't handle your speed!

 

Orio.

[Yesideez]

lol Yesideez, I can't handle your speed!

 

Orio.

Yeah but you're explaining it in a bit more detail than I am if that's any consolation