[RESOLVED] making a 3-column table

[jennyp]

Thanks to some great help I got on this forum, I have a "foreach" statement burrowing through an array which produces a nice series of images on a popup page, according to a user's selection on the parent page. It looks like this:

<?php
$DatabaseArray = file("ProdDatabase.txt");
foreach($DatabaseArray as $row) {
$DBline = explode(',', $row);
if ($DBline[0] == $ColChoiceProdTag) {
$ColourInfo = explode("*", $DBline[4]);
$ColourInfoLength = count($ColourInfo);
for($i=1; $i<$ColourInfoLength-1; $i++) {
$part = explode(':', $ColourInfo[$i]);
$ID = $part[0];
$ColourName = $part[1];
echo '<br><center><img src="images/swatch'.$ID.'.jpg" alt="'.$ID.': '.$ColourName.'" onclick="SetImage(this.alt,this.src)"><BR><br></center>';
}
}
}
?>

But the images are just churned out one after the other, vertically on the page in a single column. So I'm wondering how to coax the output into a three-column table. (I've only just bought my php manual, so don't laugh if this is a really simple question!)

[dalar]

I have a way we could do this, but i need some sample data that is in your txt file or better yet to get a copy of your db file so i can run the script initally and help out with the coding of the tables... also i need to know what $ColChoiceProdTag is set to - since your comparing it with the first row.

pm or post here some of the sample data so that I can construct my own copy of the db.

thanks

[dalar]

Hi jenny,

I realised that this is the script I helped you on, for your previous problem, so the db is not needed now, here is a new script which will do tables for you, note I have added a variable at the top so that the script would run on my machine, so remove it when you need to.

<?php

//remove
$ColChoiceProdTag = "rv001";  // this has been added here by dalar - remove it if needed

$DatabaseArray = file("ProdDatabase.txt"); 

//create table tag here

echo "<table>";
$counter = 1; // for use with creating the tables... controls how many cells are made

foreach($DatabaseArray as $row) { 
$DBline = explode(',', $row); 
if ($DBline[0] == $ColChoiceProdTag) { 
$ColourInfo = explode("*", $DBline[4]); 
$ColourInfoLength = count($ColourInfo); 
for($i=1; $i<$ColourInfoLength-1; $i++) { 
$part = explode(':', $ColourInfo[$i]); 
$ID = $part[0]; 
$ColourName = $part[1];



if($counter == 1)
	{echo "<tr>";}


echo '<td><center><img src="images/swatch'.$ID.'.jpg" alt="'.$ID.': '.$ColourName.'" onclick="SetImage(this.alt,this.src)"></center></td>';

if($counter == 3) // change this number for the amount of cells you want per line.
	{ echo "</tr>";
		$counter = 1;
	} else 
		{ $counter++;}
} 
} 
}

// finish table
echo "</table>";
?> 

[Weedpacket]

There is also a post on this subject mentioned in one of the FAQs at the top of this forum:
http://www.phpbuilder.com/board/showthread.php?t=10262518

[jennyp]

Fantastic - thanks dalar (again!) - that works perfectly, and I think I understand it! Thank you Weedpacket for the link - very useful!