displaying query results horizontally

[steveginer]

hi,
does anyone have any hints on how to display query results horizontally as such:
result1|result2|result3|result4
result5|result6|result7|result8
can't figure it out for the life of me.
thanks in advance.

[Psycho]

[code]<?php

$recordsPerRow = 4;
$currentRecord = 0;
echo "<table>";

while ($record = mysql_fetch_array($results)) {

    if ($currentRecord == 0) {
        echo "<tr>";
    }

    echo "<td>" . $record[field] . "</td>";
    $currenttRecord++;

    if ($currentRecord == $recordsPerRow) {
        echo "</tr>";
        $currentRecord = 0;
    }
}

if ($currentRecord!=0) {
    for ($i = $currentRecord; $i<$recordsPerRow; $i++) {
        echo "<td></td>";
    }
    echo "</tr>";
}

echo "</table>";
?>[code][/code][/code]

[steveginer]

thanks so much. just for anyone else who might reuse this code "$currenttRecord" should be $currentRecord in the code reference here.

    echo "<td>" . $record[field] . "</td>";
    $currenttRecord++;

hate to be nag but how would you go about limiting the number of rows displayed per page and then paginate the results. i know this is asking a lot but...

[Psycho]

Go to the home page of this site and select the tutorials section. There is a pagination tutorial there.