troubleshooting Question

PHP Query result into two columns

Avatar of Jon C
Jon C asked on
Web Languages and StandardsHTMLPHP
9 Comments2 Solutions287 ViewsLast Modified:
Hi All

I am having a few issues trying to get the following to work, I am querying a DB and want the results to display into two equal columns, I can get all the results to display correctly in the first column, but i need half of them to display in the second column, the query displays a picture and a product title from the DB:


<div class="grid_6 alpha" id="left-column">				
	
		<div class="left-column">					
				<h1>Man<span style="color: #FF0">Products</span></h1>
				<p>Our Man Products..</p> <br />
<?php

	//session_start();
	include "admin/sql_comm_helper.php";
	include "admin/sql_data.php";  // File that contains the SQL connection information.
	login_mysql();
	select_db(FALSE);
	$fid = $_POST['fid'];
$data = mysql_query("SELECT * FROM upload WHERE manufacturer='Man'") 
or die(mysql_error()); 

Print "<table border cellpadding=3>";  
while($info = mysql_fetch_array( $data ))  
{  
print "<tr>";  
print '<td><p><img src="download.php?fid='.$info['fid'] . '" width="125" height="125"></td>'; 
print "<td><a href='product.php?fid=".$info['fid'] . "'><span style='font-size: 18px;'>".$info['productname'] ."</span></a></P></td> "; 
}  
print "</table>";
?> 



		</div>	<!--END SERVICES--> 
		
	</div>	<!--END LEFT COLUMN  id="left-column"-->

	
<!--========================================RIGHT COLUMN================================================-->
		<div class="grid_6" id="right-column">
		  <div class="left-column">
		    <h1>&nbsp;</h1>
		    <p>&nbsp;</p>
<br />
		    




	      </div>
		</div>
  <p>
		  <!--END RIGHT COLUMN-->


Many thanks

Jon
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros