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

Re: [PHP] multiple outputs to mysql_query()

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

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 > set. I'm used to just doing a do/while statement for a single mysql output > per row. I'd do this: '; $result = mysql_query("SELECT * from table WHERE type='default'")

[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 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 - '; $result = mysql_query("SELECT * from table WHE