ARGHHH...what's wrong here????
| From: | Shane McBride | Date: | Thu, 14 Sep 2000 19:34:37 +0000 |
| Subject: | ARGHHH...what's wrong here???? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-16823@lists.php.net to get a copy of this message | ||
I am trying to get a table to print with two colums like this:
option1 option2
option3 option4
option5 option6
etc...
currently it's doing this:
option1 option1
option2 option2
etc...
<?
echo "<tr>";
while($row1 = mysql_fetch_array($sql_result1)) {
$item_type = $row1["html_value"];
$sql_count = "SELECT COUNT(item_type) ourcount FROM products WHERE item_type =
\"$item_type\"";
$sql_count_result = mysql_query($sql_count, $connection);
$row1 = mysql_fetch_array($sql_count_result);
$item_count = $row1["ourcount"];
for ($i=0; $i<2; $i++) {
echo "<td><font face=\"Arial, Helvetica, sans-serif\"
size=\"1\"><A HREF='shop_showcat.php?item_type=". urlencode($item_type)
.."'>$item_type ($item_count)</a></font></td>";
}
echo "</tr>";
}
mysql_free_result($sql_result1);
?>
Here's the link to see this in action:
http://www.thebackcarecenter.com/RDI_Shop/index.php