Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jun 2012
    Thanked 0 Times in 0 Posts

    [Help]Dynamic Grid in three column

    Good day, just new in php and really confuse. i have a dynamic Grid below in my screenshot,that is only straight. the codes are working well but i want to put it in 3 columns. so i research about dynamic grid output, My problem is after trying to insert this in my codes,,, it gives me different error.. sa mga mabubuti po ang loob dyan ,, pls guide me to make my images in 3 columns.

    current image:

    my desired output:

    Here the codes in my index.php
    // Run a select query to get my letest 6 items
    // Connect to the MySQL database  
    include "includes/connect_to_mysql.php"; 
    $dynamicList = "";
    $sql = mysql_query("SELECT * FROM tbl_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"];
    			 $product_name = $row["product_name"];
    			 $price = $row["price"];
    			 $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
    			 $dynamicList .= '<table width="418" border="2" cellpadding="6">
                            <td width="124" valign="top"><a href="product.php?id=' . $id . '"><img src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="120" height="121" /></a></td>
                            <td width="256" valign="top">' . $product_name . '<br />
                              $' . $price . '<br />
                              <a href="product.php?id=' . $id . '">View Product Details</a></td>
    } else {
    	$dynamicList = "We have no products listed in our store yet";
    code that i want to insert:
    // Include database connection
    include_once 'connect_to_mysql.php';
    // SQL query to interact with info from our database
    $sql = mysql_query("SELECT id, member_name FROM member_table ORDER BY id DESC LIMIT 15"); 
    $i = 0;
    // Establish the output variable
    $dyn_table = '<table border="1" cellpadding="10">';
    while($row = mysql_fetch_array($sql)){ 
        $id = $row["id"];
        $member_name = $row["member_name"];
        if ($i % 3 == 0) { // if $i is divisible by our target number (in this case "3")
            $dyn_table .= '<tr><td>' . $member_name . '</td>';
        } else {
            $dyn_table .= '<td>' . $member_name . '</td>';
    $dyn_table .= '</tr></table>';
    <h3>Dynamic PHP Grid Layout From a MySQL Result Set</h3>
    <?php echo $dyn_table; ?>

  2. #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Saskatoon, Saskatchewan
    Thanked 2,668 Times in 2,637 Posts
    Upload those images here, my barracuda blocks the site as spyware.
    You'll need to translate that error into english as well. I haven't a clue if its a PHP error, but since there is no additional reliance here on external scripts, that would indicate it is a PHP error.
    Adding a column is simple, that's a simple <td> added in. Until you upload those images here I can't tell you what you are looking to do; these two scripts are independent on the data they show, so I cannot logically determine what relationship they have to create a third column.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts