Re: mysql_fetch_array
| From: | David Robley | Date: | Tue, 13 Jun 2000 02:47:36 +0000 |
| Subject: | Re: mysql_fetch_array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-1682@lists.php.net to get a copy of this message | ||
On 10 Jun, sarahana wrote:
> After doing select, how do you move the cursor to the next record?
>
> sarahana wrote:
>
>> If I select a column from a table, and use mysql_fetch_array to store
>> the data into an array, what can I do so that each row of the column
>> gets stored as an element in the arrray?
>>
>> What I actually want to do is select a column and list them in a select
>> menu, and I'm using "do while" to list each row as an option in the
>> menu. It would help if I knew how the data gets stored in the array in
>> "mysql_fetch_array"...
>>
>> Thanks!
>>
The documentation for mysql_fetch_array() should answer most of your
queries, and includes an example of looping through a mysql result set.
See also each() for traversing arrayt in general.
Cheers
--
David Robley | WEBMASTER & Mail List Admin
RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
AusEinet | http://auseinet.flinders.edu.au/
Flinders University, ADELAIDE, SOUTH AUSTRALIA