Help with PHP / MySQL

table
php foreach result
write tr td php if total result mod 3 equals zero, write in html an ending /tr , else write me another td and continue
end foreach write a /tr just to be safe
close table

table
tr 1, 2, 3, tr!
tr 4, 5, 6, tr!
tr 7... so on so forth... tr
...
tr 100, 101, 102 tr!
tr 103, 104 tr!
close table

EDIT: You should be able to do this REALLY FAST with Dreamweaver that's what she said.

Shoot you an email later, sir. I love doing this MOD and PHP and MATH overall.

 

Check your email.

 

Usually you'd build a table using two for loops, one for rows, one for columns. Something like (for a 5 row, 3 column table):

HTML:

<?php 

  $rows = 5;
  $cols = 3;
  echo "<table>";
  for ($r = 0; $r < $rows; $r += 1)
  {
    echo "<tr>";
    for ($c = 0; $c < $cols; $c += 1)
    {
      echo "<td>";
      echo "other stuff you want in table";
      echo "</td>";
    }
    echo "</tr>";
  }
  echo "</table>";

?>

I suppose the tricky part would be to only make it the size of your results from the database. Say you want a 3-column table and your query result is a size of 5. Then, $rows = ceil($result_size/3) (in this case, 2). You may have to do a little handling in the inner loop for that 6th cell (3rd cell of the second row).

There are probably fancier solutions, but this is generally how I've seen tables built in PHP. Then again, I haven't used PHP in years.

 

use (div) for layouts instead. it's a lot easier and more wc3 compliant. here's a simple code: replace parens with angle brackets

(html)
(head)
...
(style type="text/css")
.rowBlock{float:left}
(/style)

(/head)

(?php


$res=mysql_query("SELECT img_url FROM some_table WHERE some_condition='condition' ORDER BY ASC");

$i=1;

while($arrInfo=mysql_fetch_array($res)){
echo "(div class=\"rowBlock\")(img src=\"$arrInfo[img_url]\"/)(/div)";

if(($i%3)==0)
echo "(br style=\"clear:both\"/)";

++$i;
}
?)
(/body)
(/html)

 

You and your fancy css.

 

You can also use jQuery to place items into columns.

Here's one example I found, I'm sure there's more out there as well.

http://www.sohtanaka.com/web-design/smart-columns-w-css-jquery/

 

Did you read my email?

If you have Dreamweaver, which I assume you do since you're a web design guru, it's easy with recordsets and repeating regions. What you do is that first you create your recordset (it will be named rs_PhotoGallery based on a hard-coded galleryID or from a query string for when peeps want different galleries and you want to use the same script for all galleries).

After you have it defined, you create a table with headers and one row. From the recordset, you drag each record's data (ex: photo_id, photo_name, photo_description) onto each cell. Make sure this runs with your data first by testing it.

Once you have a return for one record in Dreamweaver, select the entire row, right-click it, and select Insert->Data Objects->Repeat Region. DW will then ask you which recordset (hopefully you only have one on the page) and it will ask you how many records you want.

The entire above procedure is here. But that's only for when you have one record per row. If you want MANY records in one row and then skip to the next row, then just figure out the recordID and insert a < TR > if the ID of the record divided by three (or however many records you want) returns a reminder 0 (check if total mod 3 = 0 is true).

Otherwise if you don't have DW, you will have to know how to get totals for your records, figure out on what record item your cursor or counter is, and then you have to do a "mod" to determine where to stop the record row. You have a total of records. Whether you want to do this with DIVs or TABLEs, you will have to figure out a few things before you let PHP know where to go next as far as record or break the line.

Good stuff!