Hi

while(...)
{
do whatever
}

mysql_data_seek ($mysqlresultid, 0)

while(...)
{
do whatever
}

mysql_data_seek ($mysqlresultid, 0)
etc

will set the pointer back to the beginning of the result set, so you can
scan through it as many times as you need to, without needing to repeat the
query.


HTH

Peter

> -----Original Message-----
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: 23 October 2001 19:48
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to