RE: [PHP-DB] Using A Query Results Multiple Times
| From: | Adam Douglas | Date: | Wed, 24 Oct 2001 14:38:47 +0000 |
| Subject: | RE: [PHP-DB] Using A Query Results Multiple Times | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13668@lists.php.net to get a copy of this message | ||
Yes, I had the right code just was missing the mysql_data_seek. Thanks for
the help.
> -----Original Message-----
> From: Rick Emery [mailto:remery@excel.com]
> Sent: Tuesday, October 23, 2001 1:09 PM
> To: 'Adam Douglas'; PHP-DB (mailing list) (E-mail)
> Subject: RE: [PHP-DB] Using A Query Results Multiple Times
>
>
> You're on the right track. Did you try?:
>
> while( $row[] = mysql_fetch_array($result) );
>
> This should load each result row into a row of a
> multi-dimensional array.
>
> You would then access it with:
>
> $row[0]['colname']
>
> -----Original Message-----
> From: Adam Douglas [mailto:adouglas@venmarvent.com]
> Sent: Tuesday, October 23, 2001 1:48 PM
> To: PHP-DB (mailing list) (E-mail); PHP-General (mailing
> list) (E-mail)
> Subject: [PHP-DB] Using A Query Results Multiple Times
>
>
> I have an instance where I have to query my MySQL
> database and then
> use the multiple row results to create multiple pull down
> menus on a web
> page. My problem is how can I take the results of the query
> and use them
> more the once to create pull down menus? I've always used a
> while look to
> fetch each row of the results and have it create the pull
> down menu as it
> goes through each row. But doing it this way only stores one
> row of results
> in a variable. Is there a way I can grab all the results from
> a query that
> would go into an array so I could use it multiple times? I've looking
> briefly for a function to MySQL that would allow me to do
> this but haven't
> found anything unless I misunderstand mysql_fetch_array
> function. At first I
> thought I could loop through my while loop and have it put
> the results from
> the query of each row in to a multidimensional array. But
> then how would I
> add to the array after the initial row?
>
> BTW, I'm using PHP 3.0.16.... so I can't use the added array
> functions that
> PHP 4 has. I do plan on upgrading soon.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>
>