[PHP] multiple outputs to mysql_query()

[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 = mysql_query("SELECT * from table WHERE type='default'");

do {

    echo '<tr><td>
    ' . $myresult[column] .
    '</td></tr>';

    } while ($myresult == mysql_fetch_array($result));

echo '</table>';

?>
--------------------

//outputs:

<table>
    <tr>
        <td>data for row 1</td>
    </tr>
    <tr>
        <td>data for row 2</td>
    </tr>
...etc...
</table>

-------------------------------------------

i want it to output like this:

<table>
    <tr>
        <td>data for row 1</td>
        <td>data for row 2</td>
    </tr>
    <tr>
        <td>data for row 3</td>
        <td>data for row 4</td>
    </tr>
...etc...
</table>

------------------------------------------

if anyone can help me with alternating like this or knows where i can find a
resource tutorial on it please tell me..

thanks

-Adam



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]