PHP Code that reads left to right

Question

I've used a version of this code before and it would spit out my content left to right like it should. I can't get it to read this way for a new project and was looking for some help. It reads as:

A A A
B B B
C C C

Instead of

A B C
D E F

Here is a link to what it looks like and the code, any help would be greatly appreciated, thanks.

http://www.amphenol-industrial.com/test

<table style="width: 100%;" sizcache="14" sizset="0" border="0" cellpadding="0" cellspacing="0">
<tbody sizcache='14' sizset='0'>
<?


// Make a MySQL Connection
mysql_connect("localhost", "amphenol_web", "ampheweb") or die(mysql_error());
mysql_select_db("amphenol_conn") or die(mysql_error());

// Retrieve all the data from the "distributors" table
$query = "SELECT * FROM products WHERE page = '1' ORDER BY name";


$result = mysql_query($query) or die(mysql_error());




$cols = 6;     // Here we define the number of columns




echo "<table>"; // The container table with $cols columns
    do{
        echo "<tr>";
        for($i=1;$i<=$cols;$i++){   // All the rows will have $cols columns even if
                                    // the records are less than $cols
            $row=mysql_fetch_array($result);


?>
<?

$image = $row['image'];
$name = $row['name'];
$description = $row['description'];
$link = $row['link'];
$page = $row['page'];

if ($image == ""){echo "<td>&nbsp;</td>";}
    else {echo

        "<tr valign='top'>
<td><a href='$link'"?> onclick="_gaq.push(['_trackEvent', 'Clicks', 'Connectors', '<?php echo "$name"?>']);"><? echo "<img style='border: #015d90 1px solid;' alt='$name' src='/$image' height='74' width='120' /></a></td>             
<td width='2'>&nbsp;</td>
<td><span style='font-family: andale mono,times; font-size: 8pt;'><b>$name:</b> $description</span></td>
<td><span style='font-family: andale mono,times; font-size: 8pt;'><b>&nbsp;</b></span></td>

<td><span style='font-size: 8pt;'><a href='$link'"?> onclick="_gaq.push(['_trackEvent', 'Clicks', 'Connectors', '<?php echo "$name"?>']);"><? echo "<img style='border: #015d90 1px solid;' alt='AC Threaded' src='$image' height='74' width='120' /></a></span></td>
<td width='2'>&nbsp;</td>
<td><span style='font-family: andale mono,times; font-size: 8pt;'><b>$name:</b> $description</span></td>
<td><span style='font-family: andale mono,times; font-size: 8pt;'><b>&nbsp;</b></span></td>

<td><a href='$link'"?> onclick="_gaq.push(['_trackEvent', 'Clicks', 'Connectors', '<?php echo "$name"?>']);"><? echo "<img style='border: #015d90 1px solid;' alt='$name' src='$image' height='74' width='120' /></a></td>
<td width='2'>&nbsp;</td>
<td><span style='font-family: andale mono,times; font-size: 8pt;'><b>$name:</b> $description</span></td>
</tr>
<tr>
<td height='25'>&nbsp;</td>
<td height='25'>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>";
}
            }
//          else{
//              echo "<td>&nbsp;</td>"; //If there are no more records at the end, add a blank column
            }
//      }
//  } 

while($row);
    echo "</table>";

?>
</tr>
</tbody>
</table>

If you can, you should [stop using `mysql_*` functions](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php). They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). Learn about [prepared](http://en.wikipedia.org/wiki/Prepared_statement) [statements](http://php.net/manual/en/pdo.prepared-statements.php) instead, and consider using PDO, [it's really not hard](http://jayblanchard.net/demystifying_php_pdo.html). — Jay Blanchard, Sep 02 '15 at 20:04
I don't understand the question. What DO `A`, `B`, `C`, etc. represent in your script? — Barmar, Sep 02 '15 at 20:10
Can I ask you why you use a `do-while` loop instead of a simple `while($row = mysql_fetch_array($result))`? — Charlotte Dunois, Sep 02 '15 at 20:40

packapaul · Answer 1 · 2015-09-02T20:38:34.780

The reason your products are printing

AAA

BBB

CCC

...

Is because your running a for loop on the same SQL data and the SQL data isn't changing until the while loop executes again, hence the while($row) that you are using.

You will have to do something like the following:

$counter = 0; 
echo "<table>";
while($row = mysql_fetch_assoc($result))
{
if($counter == 0){echo "<tr>"; }
echo "<tr>";
echo "<td>";
echo $row[yourProductData]//call your product data here
....
echo "</td>";
echo "</tr>";
$counter++;
if($counter == 4){echo "</tr>"; $counter= 0;}
}
echo"</table>";

Somthing simple like that should be a better and less confusing format to get

ABC

DFG

...

score 0 · Answer 2 · answered Sep 04 '15 at 14:51

I finally figured this out and just wanted to share in case it could help someone else. The code I needed to get around jumi is as follows:

<?php $document = &JFactory::getDocument();
$renderer   = $document->loadRenderer('modules');
$position   = 'connmenu';
$options   = array('style' => 'raw');
echo $renderer->render($position, $options, null);?>

PHP Code that reads left to right

2 Answers2