showing multiple mysql records per row

[irandoct]

Dear Friends,
I'm working on a gallery module for my cms. i wanna list multi photo per a row ... can anyone help me write the code ? my gallery class code (line 51):

1.//gallery class
2.class gallery{
3.var $galleylimit = GALLERY_LIST; // number of photo in a page
4.var $galleycol = GALLERY_COL;    // number of photo in a row
5.//list all photos
6.function list_gallery(){
7.     $db = new Database;
8.     $ImageHeight = "0";
9.     $ImageWidth = "75";
10.     $theme = new theme();
11.     $default_theme = $theme->default_theme();
12.     $sitelang = new language();
13.     $sitelang = $sitelang -> site_lang();
14.     $imagespath = "themes/$default_theme/images";
15.     include "header.php";
16.     $block = new blocks;
17.     $block = $block->block(EW_PAGE_ID, EW_TABLE_NAME, 3);
18.     echo $block;
19.     $Security = new cAdvancedSecurity();
20.     if (CurrentUserLevel() <> ""){
21.     if (!$Security->IsAdmin()){
22.     if(@$_GET["category"] <> ""){
23.     $galleryfilter = "WHERE approved = 'Y' AND category = '".@$_GET["category"]."' AND (user_group = " . CurrentUserLevel() . " OR user_group is null) AND (language = '$sitelang' OR isnull(language))";
24.     }else{
25.     $galleryfilter = "WHERE approved = 'Y' AND (user_group = " . CurrentUserLevel() . " OR user_group is null) AND (language = '$sitelang' OR isnull(language))";
26.     }
27.     } else {
28.     if(@$_GET["category"] <> ""){
29.     $galleryfilter = "WHERE category = '".@$_GET["category"]."' AND (language = '$sitelang' OR isnull(language))";
30.     } else {
31.     $galleryfilter = "WHERE language = '$sitelang' OR isnull(language)";
32.     }
33.     }
34.     } else {
35.     if(@$_GET["category"] <> ""){
36.     $galleryfilter = "WHERE category = '".@$_GET["category"]."' AND approved = 'Y' AND (user_group is null) AND (language = '$sitelang' OR isnull(language))";
37.     } else {
38.     $galleryfilter = "WHERE approved = 'Y' AND (user_group is null) AND (language = '$sitelang' OR isnull(language))";
39.     }
40.     }
41.            if(!isset($_GET['page'])){
42.        $page = 1;
43.        } else {
44.        $page = ew_AdjustSql($_GET['page']);
45.        }
46.        $from = (($page * $this->galleylimit) - $this->galleylimit);
47.        $total_results = mysql_num_rows(mysql_query("SELECT * FROM gallery $galleryfilter"));
48.        $query = mysql_query("SELECT * FROM gallery $galleryfilter ORDER by id DESC LIMIT $from, $this->galleylimit");
49.        $galleryscount = mysql_num_rows($query);
50.        if ($galleryscount > 0){
51.// showing photos
52.       $total_pages = ceil($total_results / $this->galleylimit);
53.       if ($total_pages > 1){
54.         echo "<form method=\"post\" action=\"gallery.php\" name=\"pageform\" title=\"pageselection form\">";
55.         echo "<label>".PAGE.": <select id=\"pageselect\" size=\"1\">";
56.            for($i = 1; $i <= $total_pages; $i++){
57.            if($page == $i){
58.            $sel = "selected=\"selected\"";
59.            } else {
60.            $sel = "";
61.            }
62.            echo "<option value=\"gallery.php?category=".$_GET["category"]."&amp;page=$i\" $sel>$i</option>\n";
63.            }
64.           echo "</select></label>";
65.           echo "<input onclick=\"gotourl(document.getElementById('pageselect'))\" value=\"".GOTOPAGE."\" type=\"button\" />";
66.           echo "</form>";
67.            }
68.      echo "<script language=\"javascript\" type=\"text/javascript\">
69.      function gotourl( mySelect ) {
70.      myIndex = mySelect.selectedIndex;
71.      myValue = mySelect.options[myIndex].value;
72.      window.location.href = myValue;
73.      }
74.       </script>";
75.}else{
76.echo "<br/><br/><font color=\"red\">".NOPHOTO."</font>";
77.echo "<br/><br/><a href=\"javascript:history.go(-1)\" title=\"".GOBACK."\"><img src=\"images/back.jpg\" width=\"49\" height=\"17\" border=\"0\" alt=\"".GOBACK."\" /></a>";
78.}
79.     $block = new blocks;
80.     $block = $block->block(EW_PAGE_ID, EW_TABLE_NAME, 4);
81.     echo $block;
82.include "footer.php";
83.}
84.}

your help highly appreciated!
Regards
Mansour

[mblack0508]

throwing thoughts out, I would use a table to format the way your row will look, then you can use a for/while/foreach loop to add a column.

You can be creative and do this

$i = 0;
while($row = mysql_fetch_array()) {

if ($i == 0) {
    echo "<tr>";
}
echo "<td>"  /* . image display code */ . "</td>";
$i++;

if ($i == 4) {
    echo "</tr>";
    $i = 0;
}
}

This should give you an idea of how to do it. The counter would control how you do columns and rows.

I'm a little tired, I hope this answers your question or gives a bit of guidance for you to complete your script.