how can i set up 2 or 3 column display? 2

deecee · Apr 11, 2003

I have a site where users click on a brand and it brings up products associated with said brand. I am having trouble tweaking a script to have it show on multiple colums and repeat region. It works fine as one column with a repeating table but i need it expanded.

here is the page and its code......All the php is part of extensions for Dreamweaver

The part in bold is the repeated protion....

<?php require_once('Connections/connCorelist.php'); ?>
<?php
// *** Restrict Access To Page: Grant or deny access to this page
$FF_authorizedUsers=" ";
$FF_authFailedURL="enter.php";
$FF_grantAccess=0;
session_start();
if (isset($HTTP_SESSION_VARS["MM_Username"])) {
if (true || !(isset($HTTP_SESSION_VARS["MM_UserAuthorization"])) || $HTTP_SESSION_VARS["MM_UserAuthorization"]=="" || strpos($FF_authorizedUsers, $HTTP_SESSION_VARS["MM_UserAuthorization"])) {
$FF_grantAccess = 1;
}
}
if (!$FF_grantAccess) {
$FF_qsChar = "?";
if (strpos($FF_authFailedURL, "?&quot

) $FF_qsChar = "&";
$FF_referrer = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING']) && strlen($HTTP_SERVER_VARS['QUERY_STRING']) > 0) $FF_referrer .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
$FF_authFailedURL = $FF_authFailedURL . $FF_qsChar . "accessdenied=" . urlencode($FF_referrer);
header("Location: $FF_authFailedURL&quot

;
exit;
}

$maxRows_corelist = 10;
$pageNum_corelist = 0;
if (isset($HTTP_GET_VARS['pageNum_corelist'])) {
$pageNum_corelist = $HTTP_GET_VARS['pageNum_corelist'];
}
$startRow_corelist = $pageNum_corelist * $maxRows_corelist;

$colname_corelist = "1";
if (isset($HTTP_GET_VARS['brandid'])) {
$colname_corelist = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['brandid'] : addslashes($HTTP_GET_VARS['brandid']);
}
mysql_select_db($database_connCorelist, $connCorelist);
$query_corelist = sprintf("SELECT * FROM products WHERE brandid = %s ORDER BY productid ASC", $colname_corelist);
$query_limit_corelist = sprintf("%s LIMIT %d, %d", $query_corelist, $startRow_corelist, $maxRows_corelist);
$corelist = mysql_query($query_limit_corelist, $connCorelist) or die(mysql_error());
$row_corelist = mysql_fetch_assoc($corelist);

if (isset($HTTP_GET_VARS['totalRows_corelist'])) {
$totalRows_corelist = $HTTP_GET_VARS['totalRows_corelist'];
} else {
$all_corelist = mysql_query($query_corelist);
$totalRows_corelist = mysql_num_rows($all_corelist);
}
$totalPages_corelist = ceil($totalRows_corelist/$maxRows_corelist)-1;
?>
<html>
<head>
<title>Casino Marketing Solutions that Get Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="main.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">

</script>
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td width="280" height="20" align="left" valign="bottom" bgcolor="3C117C"><img src="images/logo_top.jpg" width="280" height="26"></td>
<td height="20" align="RIGHT" valign="TOP" bgcolor="3C117C">
<table height="20" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="202" align="right" valign="top"><? include ("topright.php" ?></td>
</tr>
</table>
</td>
</tr>
<tr align="CENTER" valign="BOTTOM">
<td bgcolor="#EEEEEE" height="50" colspan="2" class="topbar"><table width="100%" border="0" cellspacing="0" cellpadding="0" height="50">
<tr>
<td width="280" align="left" valign="top" background="images/logo_bottom.jpg"> </td>
<td align="CENTER" valign="BOTTOM"> </td>
<td width="100" align="CENTER" valign="BOTTOM" class="date">Today's
Date is:
<?php
setlocale("LC_TIME","fr_BE"
print strftime("%e %B %Y"
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td class="leftcell" width="200" bgcolor="eeeeee" align="LEFT" valign="TOP" height="378">
<? include ("leftbar.php" ?>
</td>
<td valign="TOP"><div align="center">
<table width="95%" border="0" cellspacing="1">
<tr align="center" valign="top">
<td>
<?php do { ?>
<table width="80%" border="0" cellspacing="1">
<tr>
<td><div align="center"><img src="<?php echo $row_corelist['thumb']; ?>"></div>
</td>
</tr>
<tr>
<td><div align="center"><?php echo $row_corelist['itemnumber']; ?></div>
</td>
</tr>
<tr>
<td><div align="center"><?php echo $row_corelist['title']; ?></div>
</td>
</tr>
<tr>
<td><a href="prod_detail.php?productid=<?php echo $row_corelist['productid']; ?>">details</a></td>
</tr>
</table>
<?php } while ($row_corelist = mysql_fetch_assoc($corelist)); ?></td>
<td> </td>
</tr>
</table>
</div></td>
<td width="100" bgcolor="#eeeeee" align="LEFT" valign="TOP" class="rightcell"><table width="100" border="0" cellspacing="2" cellpadding="0" height="100%">
<tr>
<td align="CENTER" valign="TOP"><p><a href="javascript:;"><img src="images/rep_awards.jpg" width="100" height="100" border="0"></a></p>
<p><a href="javascript:;"><img src="images/aim_reward.jpg" width="100" height="55" border="0"></a></p>
<p> <a href="javascript:;"><img src="images/incentive_award.jpg" width="100" height="19" border="0"></a></p>
<p><a href="javascript:;"><img src="images/imra_award.jpg" width="100" height="39" border="0"></a>
</p></td>
</tr>
</table></td>
</tr>

</table></td>
</tr>
<tr bgcolor="779ED5" align="CENTER" valign="TOP">
<td height="20" colspan="2" class="bottombar">
<? include ("footer.php" ?>
</td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($corelist);
?>
[Hammer]
Nike Failed Slogans -- "Just Don't Do It!"

ingernet · Apr 11, 2003

deecee,

are you saying that you want to have the results returned in a two-column format? that is to say, if there are 47 results returned, you want the first 24 in one column, and the second 23 in the second column?

(have to admit i was a little overwhelmed by all that code you posted, so i thought i would just ask the question.)

inger

sleipnir214 · Apr 11, 2003

deecee:

It would also help, when posting code, if you used the

Code:

...[/code ] TGML tags around the code.  That way, when you are using i and b as array element keys, they don't confuse the TGML parser.

[i]Want the best answers?  Ask the best questions:[/i] [URL unfurl="true"]http://www.catb.org/~esr/faqs/smart-questions.html[/URL]
TANSTAAFL!

deecee · Apr 11, 2003

ingernet -- yes that is what i want, or maybe even 3 columns but i would rather it go like

1 2 3
4 5 6
etc...

my bad bout the shotty code

[Hammer]
Nike Failed Slogans -- "Just Don't Do It!"

deecee · Apr 14, 2003

hallo?

[Hammer]
Nike Failed Slogans -- "Just Don't Do It!"

sleipnir214 · Apr 14, 2003

It's a matter of keeping a counter for every time you write a table data element:

Code:

<?php

$theinfo = array ('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm');

print '<html><body><table border=1>';

$table_width = 4;
$table_counter = 0;
foreach ($theinfo as $theelement)
{
	if ($table_counter == 0)
	{
		print '<tr>';
	}
	
	print '<td>' . $theelement . '</td>';
	
	$table_counter++;
	
	if ($table_counter == $table_width)
	{
		print '</tr>';
		$table_counter = 0;
	}
}

for ($counter = 0; $counter < $table_width - $table_counter; $counter++)
{
	print '<td> </td>';
}

print '</table></body></html>';
?>

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

deecee · Apr 14, 2003

much thanks ...

[Hammer]
Nike Failed Slogans -- "Just Don't Do It!"

sleipnir214 · Apr 14, 2003

I noticed the code I posted does not produce well-formed HTML code. Here's the corrected version:

Code:

<?php

$theinfo = array ('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm');

print '<html><body>';

$table_counter = 0;
$table_width = 4;

print '<table border=1>';
foreach ($theinfo as $theelement)
{
	if ($table_counter == 0)
	{
		print '<tr>';
	}
	
	print '<td>' . $theelement . '</td>';
	
	$table_counter++;
	
	if ($table_counter == $table_width)
	{
		print '</tr>';
		$table_counter = 0;
	}
}

if ($table_counter != 0)
{
	for ($counter = 0; $counter < $table_width - $table_counter; $counter++)
	{
		print '<td> </td>';
	}
	
	print '</tr>';
}
print '</table>';
	
print '</body></html>';
?>

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

how can i set up 2 or 3 column display? 2

deecee

Technical User

ingernet

Programmer

sleipnir214

Programmer

deecee

Technical User

deecee

Technical User

sleipnir214

Programmer

deecee

Technical User

sleipnir214

Programmer

Similar threads

Part and Inventory Search

Sponsor