McShen wrote:
> > hi
> > i have a mysql table with approx. 30 entries.
> >
> > I wanna get them(i know how to do that) and list them in a 2-column
table.
> I
> > have been trying to use a loop to do it. But it will only produce a
> 1-column
> > table. it's like
> >
> > entry 1
> > entey 2
> > entry 3
> > entry 4
> > etc
> >
> > Please help me so that i can get this :
> >
> > entry1 entry2
> > entry3 entry4
The code is easier to understand than the explanation! :)
$query = "SELECT * FROM table";
$result = mysql_query ($query)
or die ("Query <b>$query</b> failed. The error message was " .
mysql_error ());
// Initialize a value to stored the table rows
$table = '';
// Initialize a counter for the column number
$column = 0;
// Loop through the query results
while ($rows = mysql_fetch_row ($result)) {
// Put the contents of the field into a cell
$cell = "<td>$rows[0]</td>";
// If we are in column 0
if (0 == $column) {
// Start the row
$table .= "<tr>$cell";
} else {
// End the row
$table .= "$cell</tr>\n";
}
// Make the column number equal to
// The whole number remainder left over
// from dividing the value of $column
// plus one by two
$column = ($column + 1) % 2;
}
// Handle dangling rows
if (1 == $column) {
$table .= "<td></td></tr>\n";
}
echo "<table>$table</table>";
Good Luck!
--zak
--
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]
