[nycphp-talk] image display

Michael Southwell michael.southwell at
Sun Aug 26 20:15:27 EDT 2007

At 06:15 PM 8/26/2007, you wrote:
>could someone please look at this code and please tell me what is wrong.
>it is suppose to display a 4 column table with an indiffenate number of rows.
>Instead it displays one image in row , then 3 images in row 2.  Then 
>one image in row 3 and e images in row 4, and so on.  thanks.

If I understand correctly what you are trying to do, the simple way 
to do this is to end a row and start a new row in your table every 
time you have finished displaying four rows from the database, like 
this, using your $num variable:
// loop through result
// display stuff
if ( $num % 4 == 0 ) echo '</tr><tr>';

>Here is the code:
>$query="SELECT item_id, modelnum, name, upload, size, description, 
>price, gender FROM clothing ORDER BY item_id ASC";
>   $result=@mysql_query($query);
>     $num=@mysql_num_rows($result);
>$col = 0;
>echo '<table border="0" width="90%" cellspacing="3" cellpadding="3" 
>if($num>0) {
>while($row=mysql_fetch_array($result)) {
>if($col == 0)
>echo '<tr>';
>echo '<td align="center" width="20%"><font 
><span style="padding-left:5%">'.$row['name'].'</span><br /><br />
><img src="/coles/admin/new_images/'.$row['upload'].'" width="120" 
>height="140" /><br />
>'.$row['description'].'<span style="padding-left:5%">'.$row['price'].'</span>
>if($col == 0)
>echo '</tr>';
>$col = ($col == 4) ? 0 : $col;
>echo '</table>';
>New York PHP Community Talk Mailing List
>NYPHPCon 2006 Presentations Online
>Show Your Participation in New York PHP

Michael Southwell, Vice President for Education
New York PHP - In-depth PHP Training Courses

More information about the talk mailing list