Help with tables...

[krvz]

I am trying to modify a Wordpress widget made by Instinct, part of the WP e-Commerce package (great plugin, btw). The widget will display the most recently listed products from the database (see example here on the left). Currently, it is set up to display all thumbs in one column. I am hoping to modify it to display two columns of images instead of just one, but can't seem to get the images into the table.

Here's where I'm at currently. I think the table is forming, but no cells are being populated. I would appreciate any help, thanks!

function nzshpcrt_latest_product($input = null) {
	global $wpdb;

$siteurl = get_option('siteurl');
$latest_product = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN ('1') ORDER BY `id` DESC LIMIT 10", ARRAY_A);
if($latest_product != null) {
	$output = "<div>";

echo "<table cellpadding='5' cellspacing='5' border='1'>";
$count = 0; 
if(($count % 2) == 0){

echo("</tr><tr>\n");
$count++; 
}
else{
$count++; 
		foreach($latest_product as $special) {			
			$output.="<div>";
			$output .= "	<div class='item_image'>";
 			$output.="			<a href='".wpsc_product_url($special['id'],$special['category'])."'>";
			if(($special['image'] > 0)) {

			if(get_option('wpsc_selected_theme') == 'marketplace') {
				$src = WPSC_IMAGE_URL.$special['image'];

				$output .= "				<img src='". "index.php?image_id={$special['image']}&amp;width=100&amp;height=75' title='".$special['name']."' alt='".$special['name']."' />";

			} else 	{
				$output .= "			<img src='". "index.php?image_id={$special['image']}&amp;width=45&amp;height=25' title='".$special['name']."' alt='".$special['name']."' />  ";


}
			} else {
				//$output .= "<img src='$siteurl/wp-content/plugins/wp-shopping-cart/no-image-uploaded.gif' title='".$special['name']."' alt='".$special['name']."' /><br />";
			}

		$output.="		</a>";
		$output .= "	</div>";

		$output.="	<a href='".wpsc_product_url($special['id'],$special['category'])."'>";
		$output .= "		<strong>".stripslashes($special['name'])."</strong><br />";

		$output .= "	</a>";
		$output .= "</div>";
	}
}

	$output .= "</div>";
} else {
	$output = '';
}
	echo("</table>"); 
echo $input.$output;

}

Kris

[johanafm]

First off, your "table" does not appear to be a table, but rather a collection of divs, which is at it should be. However, it does render your attempted use of <tr> and </tr> futile. You need <div> and </div>

You are mixing variable assignment (for later output) with actual output. Either one is acceptable, but not both, and I'd recommend assignment over input.

The only loop count check you perform comes before the loop!

The logic of the loop count check is flawed. It is missing a check for first time in the loop so you don't end up with an empty div. You want

if($count && $count % 2 == 0)

[krvz]

Thanks for your input. It worked, oddly, on a test blog that I set up (here), but not on the the original site that I showed you yesterday (here). It's the same Wordpress theme, but for some odd reason the CSS isn't being applied to real site. Wierd. Thanks for the php help, though!

[krvz]

Check it out

Thanks again!