dynamic tables

[HotDog]

I am retrieving data from my DB and constructing it into a dynamic table. This I know how to do. What I'm having trouble figuring out is how to code the table so it will be only so many columns wide before it starts a new row. This is my logic so far:

WHILE loop through my query
COUNT the total number of records being retrieved
DIVIDE the COUNT by the number of columns I want in the table
FOR loop through the DIVIDED count
PRINT out the data in a row while in the FOR loop
GOTO the next FOR LOOP for the next table row

How am I doing so far?? Could someone help piece this together? My main problem is I don't know how to go from one FOR loop (first row) to the next one. I figure I need to capture it into an array and loop certain portions of the array at different times, right????

[freddydoesphp]

Joe, this is a common and easily fixable probelm see my code below. Please adjust it to make it work for your situation:

<table border=1><tr>
<?php
$count = 1;
$numcols = 3;
for($i=0;$i<33;$i++) {
    print "<td>$i</td>";
    print (is_int($count/$numcols)) ? "</tr><tr>" : "";
    $count++;
    }


?>
</tr></table>

Just put your while loop instead of the for() loop I have

[HotDog]

It works great!!! Here is my actual code:

<?php
	$sql = ("SELECT groupNmbr, name FROM gaclients");
	$query = mysql_query($sql);
	
	echo "<table border=1><tr>";
	$count = 1;
	$numcols = 4;
	while ($client = mysql_fetch_array($query)) {
		$cid = $client["groupNmbr"];
		$cname = $client["name"];
	    print "<td>$cname</td>";
	    print (is_int($count/$numcols)) ? "</tr><tr>" : "";
	    $count++;
	    }


?

BTW... from my other post question. I was able to find a way to auto fill my form once a client name or group number was entered. Take a look at it if you'd like and tell me what you think. But I'm still wondering if it is possible to pass a javascript string value to a php variable.

[freddydoesphp]

Where can I see it?

[HotDog]

http://www.sitepointforums.com/showt...threadid=17479