Posted by Norman Peelman on 02/28/06 04:52

"Paddy Joy" <patrick.joy2@mail.dcu.ie> wrote in message
news:12051ocrtplbt51@corp.supernews.com...
> Hi,
>
> I'm running a query to return the contents of a MySQL table. I need to
> be able to use the returned data more than once in my page so instead of
> going through each row one by one using mysql_fetch_row() is it possible
> to store the result set in a dataset or 2-d table? This way I would only
> have to run one query on the database.
>
> Anybody got any ideas on this, is there a standard way of doing this?
>
> thanks,
> Paddy

Try this too:

while ($row = mysql_fetch_array($result)) {$data_array[] = $row;}

Norm
---


--
FREE Avatar hosting at www.easyavatar.com

[Back to original message]