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:
<table>
<tr>
// loop through result
// display stuff
if ( $num % 4 == 0 ) echo '</tr><tr>';
}
</tr>
</table>
Here is the code:
require_once('connect/mysql_connect.php');
$query="SELECT item_id, modelnum, name, upload, size, description,
price, gender FROM clothing ORDER BY item_id ASC";
[EMAIL PROTECTED]($query);
[EMAIL PROTECTED]($result);
$col = 0;
echo '<table border="0" width="90%" cellspacing="3" cellpadding="3"
align="center">';
if($num>0) {
while($row=mysql_fetch_array($result)) {
if($col == 0)
echo '<tr>';
echo '<td align="center" width="20%"><font
color="teal">cAclOm'.$row['modelnum'].'</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>
</td>';
if($col == 0)
echo '</tr>';
$col++;
$col = ($col == 4) ? 0 : $col;
}
}
echo '</table>';
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
Michael Southwell, Vice President for Education
New York PHP
http://www.nyphp.com/training - In-depth PHP Training Courses
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
