loop counting & html display

[Anon]

I have an array that PHP creates from my database that diplays as a link. I then loop through all the entries in the db and they return the correct links and all work OK.

My frustration is that I end up with a one coumn list of 50+ 1 or 2 word links that I would like to display in a table of 4 or 5 columns (10 to 15 items in each).

I'm sure it cann't be that difficult, I have read all I can regarding the functions around this topic but seem to be drawing a bllank.

Any help would be really aprechiated

[Anon]

$cols = 4;
print '<tr>';
for($i=0;$i < count($yourarray);$i++) {
if (is_int($counter / $cols)) {
print '<td>somethingsomething</td></tr><tr>';
}
else {
print '<td>somethingsomething</td>';
}
$counter++;
}
print '</tr>';

[Anon]

Thanks for the previous advice. I think this small piece of code will be the death of me.

This works OK.

//---------
if($myColumn = mysql_fetch_array($result)) {
echo "Please select from one of the following States or Provinces.<p>";

//---------------------------------------------------------------

do {
echo "<table border=0><tr>";

printf("<td><a href=\"%s?id=%s\">%s</a></td></tr><tr>\n", $PHP_SELF, $myColumn["stateProvID"], $myColumn["stateProv"]);

echo "</tr></table>";

} while ($myColumn = myql_fetch_array($result));

//---------------------------------------------------------------
} else {
etc etc
//---------

I tried to integrate the for loop but am still missing the point as I cannot achieve the desired result.

This doesn't work

//---------
if($myColumn = mysql_fetch_array($result)) {
echo "Please select from one of the following States or Provinces.<p>";
//---------------------------------------------------------------
do {
echo "<table border=0><tr>";

$cols = 4;
for($i=0;$i < count($myColumn);$i++) {
	if (is_int($counter / $cols)) {

	printf("<td><a href=\"%s?id=%s\">%s</a></td></tr><tr>\n", $PHP_SELF, $myColumn["stateProvID"], $myColumn["stateProv"]);

	}
	else {
		echo "somethingsomething";

	}

	$counter++;
}


echo "</tr></table>";

} while ($myColumn = myql_fetch_array($result));

//---------------------------------------------------------------
} else {
etc etc
//---------

Cheers

jw

[Anon]

echo "<table border=0><tr>";

                   $cols = 4;
                   $counter = 1;
             while ($myColumn = myql_fetch_array($result)) {
                   if (is_int($counter / $cols)) { 

printf("<td><a href=\"%s?id=%s\">%s</a></td></tr><tr>\n", $PHP_SELF,
$myColumn["stateProvID"], $myColumn["stateProv"]);
}
else {
printf("<td><a href=\"%s?id=%s\">%s</a></td>\n", $PHP_SELF,
$myColumn["stateProvID"], $myColumn["stateProv"]);

                   } 

                   $counter++; 
                   } 

                   echo "</tr></table>"; 

[Anon]

Thanks Louie

[Anon]

Hi, this is Mandy.

I try to get a free counter, in our web site. The counter only for internal use. The public won't able to view it.

Thank you!