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
fe
ROTECTED]]
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 mul
it with:
>
> $row[0]['colname']
>
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> 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 Resul
ing list) (E-mail); PHP-General (mailing
> list) (E-mail)
> Subject: RE: [PHP-DB] Using A Query Results Multiple Times
>
>
> Hi
>
> while(...)
> {
> do whatever
> }
>
> mysql_data_seek ($mysqlresultid, 0)
>
> while(...)
> {
> do whatever
> }
>
.
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