loop sequence

Anon

Trying to get results from database and loop out a table with four columns by however many rows, with a result in each cell. So far all I have been able to do is have it loop out same result four times, then next row, next result four times, etc... here's the code I have thus far:

$sql = "Select field1, field2 from database.table where value=$value";
$mysql_result = mysql_query($sql);
print("<table border=0 cellpadding=0 cellspacing=1 width=100%>");
while ($row = mysql_fetch_array($mysql_result)){
$Id=$row["field1"];
print("<tr>");
for($i=0; $i<=4; $i++){
print ("<td bgcolor=CC9966><a href=\"test.php\">" . $row["field2"] . "</a></td>");
}
print("</tr>");
}
print("</table>");

any help is appreciated.

toma42

Dude, use templates and your life will be much easier. There are good articles on this site to give you background on how they can help, but I advoate using the PEAR HTML/IT.php class instead of phplib or fast templates.

Anon

er, ok... but first perhaps you could enlighten me as to what a template is, and more specifically what PEAR HTML/IT.php class is/does.

I thought my question dealt with a fairly routine loop grouping problem?

mrjam

for($i=0; $i<=4; $i++){
print ("<td bgcolor=CC9966><a href=\"test.php\">" . $row["field2"] . "</a></td>");
}

is bad. like "while $i is less than 4, print stuff between {}". You started out right with the while()...

while ($row = mysql_fetch_array($mysql_result)) {
echo '<tr>';
echo '<td>'.$row["field1"].'</td>';
echo '<td>'.$row["field2"].'</td>';
echo '<td>'.$row["field3"].'</td>';
echo '<td>'.$row["field4"].'</td>';
echo '</tr>';
}

You might do it another way, but it's an example...

toma42

PEAR are php base classes which are installed when you install php. More info here: http://www.php.net/manual/en/pear.php Make sure to check out the tutorials linked in the user comments.

A template allows you to seperate the html from the php. http://www.phpbuilder.com/columns/david20000512.php3 has more info on templates although the HTML/IT.php class used in pear is a little different thatn the phplib one.

Tom