Displaying Query Results

[bbarby]

Major Mind Lock! Help!

I'm trying to display the results of a query in the following format:

item1 item2 item3
item4 item5 item6
item7 item8 item9
etc...

I can only get it to display:

item1 item2 item3

I can't for the life of me figure out the code to get the offset to repeat on the next row down...

Any ideas?

TIA

Benjamin

[bbarby]

Here's the code I'm using:

$limit=3; // number of rows to return
$numresults=mysql("$DBName","SELECT * FROM class_names ");
$numrows=mysql_num_rows($numresults);

// if an offset has not been passed, use 0
if (empty($offset)) {
$offset=0;
}

// get the results
$result=mysql("$DBName","SELECT * FROM class_names limit $offset,$limit");

// display the results
while ($row = mysql_fetch_row($result)) {
$Name=$row[1];
$class_nameID=$row[0];
echo $Name."$nbsp";
}

That get's me my

item1 item2 item3

Now I need to make it repeat starting with the next three returns.

Thanks in advance for the help,

Benjamin