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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
