Re: Simple while loop skipping first row of array
| From: | André Cerqueira | Date: | Sun, 15 Feb 2004 23:51:27 +0000 |
| Subject: | Re: Simple while loop skipping first row of array | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177752@lists.php.net to get a copy of this message | ||
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
just fixing something hehe
echo "<select name=\"cats\">";
$result = mysql_query("select * from cats order by title");
if ($result) {
while ($c = mysql_fetch_array($result)) {
echo "<option value=\"$c[id]\">$c[title]</option>";} } echo "</select>"; André cerqueira wrote:
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:Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAMAYCaxdA/5C8vH8RAsXOAKCl/DfLLO9tC+4nk4S5a0g1pgSVfwCeIsiG MOflQLGII4Aojg1qF4hHHn0= =RYbS -----END PGP SIGNATURE----------BEGIN PGP SIGNATURE-----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