[PHP] multiple outputs to mysql_query()

2001-07-08 Thread Adam
i want my mysql query result to output 2 mysql output rows for every tr set. I'm used to just doing a do/while statement for a single mysql output per row. example: //the code i have essentially does this - ?php echo 'table'; $result =

Re: [PHP] multiple outputs to mysql_query()

2001-07-08 Thread [EMAIL PROTECTED]
on 7/8/01 3:39 AM, Adam at [EMAIL PROTECTED] wrote: i want my mysql query result to output 2 mysql output rows for every tr set. I'm used to just doing a do/while statement for a single mysql output per row. I'd do this: ?php echo 'table'; $result = mysql_query(SELECT * from table WHERE

Re: [PHP] multiple outputs to mysql_query()

2001-07-08 Thread Adam
I'd do this: ?php echo 'table'; $result = mysql_query(SELECT * from table WHERE type='default'); $numrows = mysql_num_rows ($result); while ($numrows) { $row = mysql_fetch_row ($result); echo tr\ntd$row[0]/td\n; $row = mysql_fetch_row ($result); echo

Re: [PHP] multiple outputs to mysql_query()

2001-07-08 Thread [EMAIL PROTECTED]
on 7/8/01 5:53 AM, Adam at [EMAIL PROTECTED] wrote: thanks so much for the help, that'll be a great reference for any other similar types of output i need. some things i had to fix for others viewing this thread: while ($numrows) had to be changed to while ($numrows = 1) or the while