Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Need products to show in grid instead of a row on php page

Codes here !

Moderators: macek, egami, gesf

Need products to show in grid instead of a row on php page

Postby BoroDracula » Sat Jun 23, 2012 12:28 pm

OK so I have been following some external tutorials for creating a website based around php which is great for what I am trying to accomplish. But i have hit a sticking point with some code. So far I have all my tables built, entries in the tables and such but on my main php page I can only get the results to render out in rows only instead of a grid (would like if I can 3x4).

My current coding for the php scripting is below, this is called on in the HTML code by <?php echo $dynamicList; ?>

Code: Select all
<?php
// run a select query to get the latest 6 items
include "storescripts/connect_to_mysql.php";
$dynamicList="";
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 6");
$productCount = mysql_num_rows ($sql); // count the output amount
if ($productCount > 0){
   while($row = mysql_fetch_array($sql)){
      $id = $row["id"];
      $sku = $row["sku"];
      $product_name = $row["product_name"];
      $price = $row["price"];
      $dynamicList .=
      '<table width="100" border="0" cellpadding="3">
           <tr>
              <td align="left" valign="top"><a href="product.php?id=' .$id. '"><img src="inventory_images/' .$id. '.jpg" alt="$product_name" width="125" border="0"/></a>
           </td>
           </tr>
           <tr>
              <td align="left" valign="top">' .$product_name. '</td>
           </tr>
           <tr>
              <td align="left" valign="top">£' .$price. '</td>
           </tr>
      </table>&nbsp';
   }
} else {
   $dynamicList = "You have no products listed in our store yet"   ;
}
mysql_close();
?>


Basically what I would really like is for the coding to render the next table to the right of the last until they reach 3 tables, then go down to the next row. The overall outcome I want this coding to complete is to show multiple products in a grid format which name and price shown beneath each photo

Thanks in advance
BoroDracula
New php-forum User
New php-forum User
 
Posts: 5
Joined: Sat Jun 23, 2012 12:22 pm

Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.