RE: FN-FORUM loop in php

date posted 25th June 2002 14:26

sorry to butt in but this is far from neat and gives no indication
of how you're actually planning to get the info from the result of
the query.

The neatest way to get data from a mysql result resource, imho, is
mysql_fetcharray() (or whatever the exact name is).


Tim Ward
www.chessish.com

> Ron,
>
> $result = mysql_query('your sql query here');
> $num_results = mysql_num_rows($result);
>
> for ($i=0; $i < $num_results; $i++)
> {
> 'your display code here'
> }
>
> will do the job quite neatly
>
> Steve
>
> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] Behalf Of Rob Garbutt
> Sent: 25 June 2002 13:39
> To: [EMAIL REMOVED]
> Subject: FN-FORUM loop in php
>
>
> hi all,
>
> how would you echo the following database retrieval in a list until all
> the rows have been echoed?
>
> i've a feeling its a while loop type statement, but aren't too sure.
>
> tia
>
> Robin Garbutt