Re: multiple outputs to mysql_query()

> 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>\n<td>$row[0]</td>\n"; > $row = mysql_fetch_row ($result); > echo "<td>$row[0]</td>\n</tr>"; > $numrows = ($numrows - 2); > } > > echo '</table>'; > > ?> 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 statement would loop forever. (server hangup) i had to accomidate and if statement to check if the amount of $numrows left was <= 1 -Adam