[todayscoffee]

Okay i'm fairly new to php/mysql so here's what i'm trying to do:
I have data i'm trying to pull from a mysql db and i'd like to display it 4 across and then however many needed down. Like so:

item 1 id...........|..item 2 id...........|..item 3 id...........|..item 4 id...........|
item 1 title........|..item 2 title........|..item 3 title........|..item 4 title........|
item 1 descrip....|..item 2 descrip....|..item 3 descrip....|..item 4 descrip....|
--------------------------------------------------------------------------
item 5 id...........|..item 6 id...........|..no more data.....|..no more data.....|
item 5 title........|..item 6 title........|..so make cell.......|..so make cell......|
item 5 descrip....|..item 6 descrip....|..empty..............|..empty......... ......|

from the little info/examples i've gathered i think it's somethign to do with counting and looping, but i have no idea how the code would look, so if anyone can provide some examples i'd really appreciate it.

Slainte

[phprogramming]

heres an example that i used in my gallery script to display thumbnails in rows of 5, u just have to change $array[] to suit ur needs:

PHP Code:

$max=5;

                $query="SELECT cid,category,images FROM m2_category";

                $result=@mysql_query($query);

                $num=mysql_num_rows($result);

                

                if(empty($num)){

                    $final="\t<tr><td><center>No Categories to display, click <a href=\"create.php\">here</a> to create one.</center></td></tr>\n";

                }else{

                    while($row=mysql_fetch_array($result,MYSQL_NUM)){

                        $array[]="<a href=\"gallery.php?c=".$row[0]."\">".$row[1]."(".$row[2].")</a>";

                    }

                    

                mysql_free_result($result);

                

                    $final="<tr>\n";

                    

                    foreach($array as $thumbnail){

                    if($counter==$max){

                        $counter=1;

                        $final.="\n<tr>\n";

                    }else $counter++;

                        $final.="\t<td width=\"100\" height=\"75\"><center>".$thumbnail."</center></td>\n";

            

                    }

                    

                        if($counter){

                            if($max-$counter){

                                $final .= "\t<td width=\"100\" height=\"75\">&nbsp;</td>\n"; 

                            }

                            

                            $final.="</tr>";

                            }

                        } 

then somewhere in your script echo out $final, i chose to do it in a table, just play around till u find something that works

if this script doesnt work just add or remove some } at the bottom, i just copy and pasted it out of my script, but besides that there shouldnt be errors.

[todayscoffee]

That is AWESOME! thank you very very much! That is a great code! Grazie.

Slainte, to you and yours.

[phprogramming]

lol np man, glad i could help, and im glad u could understand it

[franck]

Hi, phprogramming ... I've seen your code and tried to put it all into a function so it can be a little better maintainable, but I can't seem to figure out where the error is. I only get 1 result printed.

Here is the code:

PHP Code:

/*

 * $object can be an array or object

 * $text is the format of the text you want to print (in this case mixed with php variables)

 * $columns is the number of columns

*/

function printInColumns($object=null, $text=null, $columns=4){

    //opening the tags

    $final.="\n<table><ul><tr>\n";



    //building the table

    for ($i=0; $i<count($object); $i++){

        if($counter==$columns){

            $counter=1;

            $final.="\n</tr><tr>\n";

        }else $counter++;

        eval("\$text = \"$text\";");

        $final.="\t<td>

                $text

                </td>\n";

    }

    

    //closing the tags 

    if($counter){

        if($columns-$counter)

            $final .= "\t<td>&nbsp;</td>\n"; 

        $final.="</tr>";

    }$final.="\n</ul></table>\n";

    

    //returning the html code

    return "$final";

}



/*

 * And here we call the function

*/

echo printInColumns($bookList, '<li><input type=\'checkbox\' name=\'book\' value=\'".$object[$i]->idbook."\'/>".$object[$i]->bookname."</li>',4); 

In the object $bookList I have 10 elements. But the script just prints the first element, 10 times! so I think there is a problem with the $i variable but I can't seem to find the solution.

Hope you can help me get this done

Greetings.