displaying db results in horizontal fashion

[nebb]

hi, im trying to display the results of a db query in a horizontal fashion that would display 3 records per row..ie..

field1 field1 field1
field2 field2 field2

field1 field1
field2 field1

this is what i have so far:

$query_cat_d = "SELECT c_name, c_image from category";
$result_cat_d = mysql_query($query_cat_d);

echo ("<TR>");

for ($j = 0; $j < mysql_num_rows($result_cat_d); $j++) { 



	$rowarray = mysql_fetch_row($result_cat_d);
	$field_num = mysql_num_fields($result_cat_d);

//for ($j = 0; $j < $field_num; $j++) {
	//$remainder = mysql_num_rows($result_cat_d) % 3 

	echo ("<TD>");
	echo ("<TABLE border=1>");
	echo ("<TR><TD>") . $rowarray[1] . ("</TD></TR>");
	echo ("<TR><TD>") . $rowarray[0] . ("</TD></TR>");
	echo ("</TABLE>");
	echo ("</TD>");
//}



}  	

echo ("</TR>");

any help would be appreciated

[nebb]

I forgot to mention..the code that i have now builds only one row and there are 6 to 7 records in one row. here is my link

www.financialshopper.com/category_display_test2.php

[sfullman]

You're referring to a "horizontal looper".

Here's a URL:
http://www.pacificbasinservices.com/

enter "candle" in the upper right and click on "Search Site"

That's the page, here's the link to the page CODE:

http://www.relatebase.com/development/misc/looper.txt

Hope this is a help to you.
Sam

[nebb]

thanks for the info..actually, i found a snippet of code that had the same horizontal looper which i was able to utilize. Ill post my code incase anyone else has the same issue:

$tmp_cnt = 0; // temporary variable
$per_row = 3;

for ($j = 0; $j < mysql_num_rows($result_cat_d); $j++) { 

//echo ("<TR>");


if ($tmp_cnt % $per_row == 0)
echo ('<tr>'); 

	$rowarray = mysql_fetch_row($result_cat_d);
	$field_num = mysql_num_fields($result_cat_d);

//for ($j = 0; $j < $field_num; $j++) {
	//$remainder = mysql_num_rows($result_cat_d) % 3 

	echo ("<TD>");
	echo ("<TABLE>");
	echo ("<TR><TD><img src=images/clear.gif height=8></TD></TR>");
	echo ("<TR><TD><img src=") . $rowarray[1] . ("></TD></TR>");
	echo ("<TR><TD>") . $rowarray[0] . ("</TD></TR>");
	echo ("<TR><TD><img src=images/clear.gif height=8></TD></TR>");

	echo ("</TABLE>");
	echo ("</TD>");
//}
 $tmp_cnt = $tmp_cnt + 1;
 if ($tmp_cnt % $per_row == 0)
echo ('</tr>'); 



}