Re: Simple while loop skipping first row of array
| From: | André Cerqueira | Date: | Sun, 15 Feb 2004 17:35:45 +0000 |
| Subject: | Re: Simple while loop skipping first row of array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177737@lists.php.net to get a copy of this message | ||
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
try:
echo "<select name=\"cats\">";
$result = mysql_query("select * from cats order by title");
while ($c = mysql_fetch_array($result)) {
echo "<option value=\"$c[id]\">$c[title]</option>";
}
echo "</select>";
Verdon Vaillancourt wrote:
I'm not sure I phrased my subject well, but...
The following is just to build a select menu from a table query result set.
It sort of works, but doesn't return the first row in the result set, ie if
I have the following rows in the table 'cats';
id title
==========
1 Pears
2 Oranges
3 Apples
4 Bananas
echo "<select name=\"cats\">";
$result = mysql_query("select * from cats order by title");
$categories = mysql_fetch_array($result);
if ($categories) {
while ($c = mysql_fetch_array($result)) {
echo "<option value=\"$c[id]\">$c[title]</option>";
}
}
echo "</select>";
The resulting select menu will only include Bananas, Oranges, Pears.
Am I missing something terribly obvious to one less newbie than me?
TIA, Verdon
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFAL631axdA/5C8vH8RAkmqAJwJndx7VZiNRGq/L7EIdDzvwJ6ksgCfT3Rc
Fsl2UFV3LW7k+cFvqzsC+xM=
=EmWf
-----END PGP SIGNATURE-----