Display names horizontally from database!!

adrianuk29

I am trying to display two names horizontally from the database. After two names have been displayed I want to drop down, start the table again and display the next two names from the database so the output looks like this:

justin mick
paul darren
ian dean

and so on.....

It is displaying horizontally, however It is not stopping at two names. Your help would be greatly apreciated.

Thank you.

Here is my code below

<?PHP //display names horizontally ?>

<?PHP
if(!isset($start)) $start = 0;
include("db.php");
mysql_connect($servername,$username,$password);
$query = "SELECT * FROM names ORDER BY id DESC LIMIT " . $start . ", 50";
@mysql_select_db($database) or die( "Cannot select the database");
$result = mysql_query($query);
$num=mysql_numrows($result);
?>

<?
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
?>

<?
++$i;
}
?>

</td>
</tr>
</table><br>

laserlight

<?php
if (!isset($start))
	$start = 0;
include("db.php");

mysql_connect($servername, $username, $password);
@mysql_select_db($database)
	OR die( "Cannot select the database");

$query = "SELECT * FROM `names` ORDER BY `id` DESC LIMIT " . $start . ", 50";
$result = mysql_query($query);

echo "<table>\n"; //start the table

$counter = 0; //current row count
while ($row = mysql_fetch_assoc($result)) {
	$flag = $counter % 2 == 0; //true for new row

$id = $row['id'];
$name = $row['name'];
if ($counter % 2 == 0)
	echo "<tr>\n";
echo "<td>" . $name . "</td>\n";
if ($counter % 2 == 1)
	echo "</tr>\n";

$counter++;
}
//check for unclosed row
if ($counter % 2 == 1)
	echo "<td>&nbsp;</td>\n</tr>\n";
echo "</table>\n";
?>

Basically, the idea is that you start a new HTML table row on every even numbered DB table row.

There is a slight problem with this method, namely in how you handle having an odd number of entries.
Since you apparently didnt take this into account, I cant help you factor it in either.

adrianuk29

Thank you very much for your help. I will try this out later.