Displaying Results in Columns

[klausd]

Hi,

The following script works fine. However, it lists the results, which are about 80 items in one column. I would like to display the result in say 4 columns of 20 items each making it possible to have all items displayed on the screen without scrolling down.

How do I code this to obtain the desired result. Your help is much appreciated.

<?
commonHeader("$Company","Select an item");
generalHeader("$Company");

fontFace("Arial","Select a Hotel:<br><br>");
echo "<ul>";
$result=mysql("$DBName","SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName");
while ($row = mysql_fetch_row($result)) {
$IN=$row[0];
fontSize("-1","blue","Arial","<li><a href='$Relative/description.php?II=$UID'>$IN</a></li>");
}
echo "</ul>";
?>

[nnichols]

It depends on how you want to display the data -

1   2   3
4   5   6
7   8   9

or

1   4   7
2   5   8
3   6   9

??

[klausd]

Hi,
Thank you for such a speedy reply. Being a newbie and apparently still a bit dumb - please advise where the code is to be put and in what format using the above script sample. The display should be in this format below as the query result is in alphabetical order.

1 4 7
2 5 8
3 6 9

Thanks for helping a beginner.
Cheers - Klaus 😕

[nnichols]

$sql = "SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName";
$result = mysql_query($sql, $db) or die('MySQL error: ' . mysql_error() . '<br>Query: ' . $sql);

echo "<table>\n";

$num_rows = mysql_num_rows($result);
$num_cols = 6;  //number of columns to display
$disp_rows = ceil($num_rows/$num_cols);
while ($row = mysql_fetch_array($result)) {
	$data_array[] = $row;
	}
for ($i=0; $i<$disp_rows; $i++) {
	echo '<tr>';
	for ($j=0; $j<$num_cols; $j++) {
		echo '<td>'. $data_array[(($disp_rows*$j)+$i)][0] .'</td>';
		}
	echo "</tr>\n";
	}
echo "</table>\n";

You'll need to play with the code a bit to get it to work with your fontSize function.

Hope this helps 😉

[klausd]

Hi,
Thank you for posting the solution. Unfortunately I have problems making it work. The script below is part of a complete hotel reservation script which is working well. I just need to have the row $Cat=$row[0]; in "Please Select A Region"displayed in 3 or 4 columns. (see near the end of the script)

How and where do I include your coding. I tried a few different approachhes but all failed.

I really would be grateful for your help.

Best regards - Klaus

<?
require("Cart.php");
DBinfo();
Brand();
Root();
mysql_connect("$DBHost","$DBUser","$DBPass");
$old=date("z")-1;
mysql("$DBName","DELETE FROM Users WHERE Date < $old");

$result=mysql("$DBName","SELECT CartItemsID,Date FROM CartItems");
while ($row=mysql_fetch_row($result)) {
$CII=$row[0];
$CDa=$row[1];
$pieces=explode(":",$CDa);
$DCHK=$pieces[1];
if ($DCHK < $old) {
mysql("$DBName","DELETE FROM CartItems WHERE CartItemsID = '$CII'");
}
}

if ($UID != "") {
$result=mysql("$DBName","SELECT * FROM Users WHERE User='$UID'");
$num=mysql_num_rows($result);
if ($num == "0") {
$dt=date("YmdHis");
$UID="$dt$REMOTE_ADDR";
$date=date("z");
mysql("$DBName","INSERT INTO Users VALUES ('$UID','$date')");
Header("Location: $PHP_SELF?UID=$UID");
}
}

if ($UID == "") {
$dt=date("YmdHis");
$UID="$dt$REMOTE_ADDR";
$date=date("z");
mysql("$DBName","INSERT INTO Users VALUES ('$UID','$date')");
Header("Location: $PHP_SELF?UID=$UID");
}
commonHeader("$Company","Select a Region");
;fontSize("-1","silver","Arial","<b>A Hotel Reservation System powered by Reservations Africa
for TRAVEL AGENTS</b><br>");

fontSize("-2","blue","Verdana","<a href='http://resafrica.net/members/admin.php?pageId=logout'><b>LOGOUT</b></a>");

fontFace("Arial","Please Select a Region:<br><br>");
echo "<ul>";
$result=mysql("$DBName","SELECT * FROM Category ORDER BY Category");
while ($row = mysql_fetch_row($result)) {
$Cat=$row[0]; //SHOULD BE DISPLAYED IN 3 COLUMNS
$CatID=$row[1]; //IS NOT DISPLAYED
fontFace("Arial","<li><a href='$Relative/items.php?CA=$CatID&UID=$UID'>$Cat</a></li>");
}
echo "</ul>";

?>

😕

[nnichols]

Try this -

<? 
require("Cart.php"); 
DBinfo(); 
Brand(); 
Root(); 
mysql_connect("$DBHost","$DBUser","$DBPass"); 
$old=date("z")-1; 
mysql("$DBName","DELETE FROM Users WHERE Date < $old"); 

$result=mysql("$DBName","SELECT CartItemsID,Date FROM CartItems"); 
while ($row=mysql_fetch_row($result)) { 
$CII=$row[0]; 
$CDa=$row[1]; 
$pieces=explode(":",$CDa); 
$DCHK=$pieces[1]; 
if ($DCHK < $old) { 
mysql("$DBName","DELETE FROM CartItems WHERE CartItemsID = '$CII'"); 
} 
} 


if ($UID != "") { 
$result=mysql("$DBName","SELECT * FROM Users WHERE User='$UID'"); 
$num=mysql_num_rows($result); 
if ($num == "0") { 
$dt=date("YmdHis"); 
$UID="$dt$REMOTE_ADDR"; 
$date=date("z"); 
mysql("$DBName","INSERT INTO Users VALUES ('$UID','$date')"); 
Header("Location: $PHP_SELF?UID=$UID"); 
} 
} 

if ($UID == "") { 
$dt=date("YmdHis"); 
$UID="$dt$REMOTE_ADDR"; 
$date=date("z"); 
mysql("$DBName","INSERT INTO Users VALUES ('$UID','$date')"); 
Header("Location: $PHP_SELF?UID=$UID"); 
} 
commonHeader("$Company","Select a Region"); 
;fontSize("-1","silver","Arial","<b>A Hotel Reservation System powered by Reservations Africa 
for TRAVEL AGENTS</b><br>"); 

fontSize("-2","blue","Verdana","<a href='http://resafrica.net/members/admin.php?pageId=logout'><b>LOGOUT</b></a>"); 

fontFace("Arial","Please Select a Region:<br><br>"); 
echo "<ul>"; 
$result=mysql("$DBName","SELECT * FROM Category ORDER BY Category"); 

echo "<table>\n";

$num_rows = mysql_num_rows($result);
$num_cols = 6;  //number of columns to display
$disp_rows = ceil($num_rows/$num_cols);
while ($row = mysql_fetch_array($result)) {
	$data_array[] = $row;
	}
for ($i=0; $i<$disp_rows; $i++) {
	echo '<tr>';
	for ($j=0; $j<$num_cols; $j++) {
		$Cat = $data_array[(($disp_rows*$j)+$i)][0];
		$CatID = $data_array[(($disp_rows*$j)+$i)][1];
		echo "<td><a href='$Relative/items.php?CA=$CatID&UID=$UID'>$Cat</a></td>";
		}
	echo "</tr>\n";
	}
echo "</table>\n";


?>

Hope this helps 😉

[klausd]

Thanks, it works perfectly well.

Cheers - Klaus 🙂