Re: mysql php - while loops

2002-02-27 Thread DL Neil
Craig, [BTW there is a set of PHP lists, including PHP-DB - mentioned because 'purists' sometimes object to 'PHP questions'!?] > >>The following lists 12 items from a fruits table. > >> > >>$results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice > >>FROM fruits"); > >>while (

Re: mysql php - while loops

2002-02-26 Thread Sommai Fongnamthip
if you decide to display only first 4 item try to used limit clause after the SQL statement. otherwise use any count variable within your loop. Sommai At 20:33 26/2/2002 -0600, Paul DuBois wrote: >At 18:42 -0600 2/26/02, Craig Westerman wrote: >>The following lists 12 items from a fruits table

Re: mysql php - while loops

2002-02-26 Thread Paul DuBois
At 18:42 -0600 2/26/02, Craig Westerman wrote: >The following lists 12 items from a fruits table. > >$results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice >FROM fruits"); >while ($data = mysql_fetch_array($results)) >{ >?> > - - > - >} > >How would I modify the loop to disp

mysql php - while loops

2002-02-26 Thread Craig Westerman
The following lists 12 items from a fruits table. $results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice FROM fruits"); while ($data = mysql_fetch_array($results)) { ?> - - - <> [EMAIL PROTECTED] - Befo