showing results, big help!!

itworks

i've asked this before but no answer solved my problem but i really need this done and i can't figure out how to do it.

i have a while loop for showing all the results in a MySQL table (there aren't many, 20 max) but i need them to show 4 results in each row, so for 20 i need 5 rows with 4 columns each with a result.

how can i make this table format in a loop?

thanks in advance.

cgraz

The 5 rows will be created dynamically. All you need to worry about is the columns.

echo "<table width=\"400\">";

while($row = mysql_fetch_assoc($query)) {
   echo "<tr>\n";
   echo "<td width=\"100\">" . $row["field1"] . "</td>\n";
   echo "<td width=\"100\">" . $row["field2"] . "</td>\n";
   echo "<td width=\"100\">" . $row["field3"] . "</td>\n";
   echo "<td width=\"100\">" . $row["field4"] . "</td>\n";
   echo "</tr>\n";

}

Cgraz

Frederick

You can type in less code if you leave out the double quotes in your HTML.

echo "<td width=100>" . $row["field1"] . "</td>";

cgraz

yes, that's true, but i'm a perfectionist. I want people to see the quotes if they were too look at the html after php processes it. Just personal preference.

Cgraz

itworks

thanks, but it didn't work!!!!

maybe i didn't explain well, see i want to make a products menu and the categories are dynamicly created from the database and for each categoria i have an image, a name and a link.

i want the categories to show side by side creating that menu with 4 columns.

all i get with your script is a category in each row repeated in the 4 columns of that row, creating as many rows as results in the database.

i need for example....

etc...

and i get...

etc...

what am i doing wrong?

jclout

Try something like this:

<?
mysql_connect(localhost, *, );
$result = mysql(DB NAME GOES HERE, "select from TABLENAME");
$num = mysql_numrows($result);
$i = 0;
$j = 0;
$rownum = 0;

	while($i < $num) {

		if($j == $rownum) {
		echo "<TR>";
		$rownum += 10;
		}

	echo "<TD>";
	echo mysql_result($result,$i,"subtype");
	echo mysql_result($result,$i,"name");
	echo mysql_result($result,$i,"image");
	echo mysql_result($result,$i,"name");
	echo "</TD>";
	++$j;	
		if($j == $rownum) {
		echo "</TR>";
		}
	$i++;}	
	?>

Make sure you change connection
$rownum+= 10; This is number of records per row
I'm new to PHP but this was the first thing I was able to figure out. Good Luck

itworks

thanks a million!!!😃

i have to say that i didn't thought to much of your code when i first saw it :rolleyes: but i gave it a shot and after doing some modifications i got exactly what i was hoping for.:eek:

thanks again.😉