PHP Forum

**MoForce** · 12-24-2008, 11:35 PM

PHP Code:


			
<?
$query = mysql_query("SELECT * FROM inventory WHERE username='".$_SESSION['u_name']."' AND user_id='".$id."'");
$number = mysql_num_rows($query); 
?>
<? if ($number > 0){ ?>
<? while ($inv=mysql_fetch_array($query)) { ?>
<td style="border:#CCCCCC solid 1px;"><div align="center"><img src="<?=$inv['imgpath']?>" width="100px" height="100px" /><br /><?=$inv['item']?></div></td>
<? } ?>
<? } ?>

That's what I have so far, and it does work. The only problem is I don't know how to change it in such a way that I can get rows made after X number of items

so this is what it gives to far (each "X" is an item)
XXXXXXXXXXXXXXXXXXXX
and it goes on forever in one row until all items are listed

what I would like to have happen
XXXXX
XXXXX
XXXXX
XXXXX
creates a new row after, in this case, 5 items are listed in a row

Thank For Helping

**mgraphic** · 12-25-2008, 12:25 AM

What you can do is create a counter (example: $col) that everytime it is a perfect divisable of 5, it will create a new row.

PHP Code:


			
<?php
$query = mysql_query("SELECT * FROM inventory WHERE username='".$_SESSION['u_name']."' AND user_id='".$id."'");
$number = mysql_num_rows($query); 
if ($number > 0)
{
  for ($col = 1; $inv = mysql_fetch_array($query); $col++)
  {
    if ($col % 5 === 0) echo '<tr>';
    
?>
<td style="border:#CCCCCC solid 1px;"><div align="center"><img src="<?php echo $inv['imgpath']; ?>" width="100px" height="100px" /><br /><?php echo $inv['item']; ?></div></td>
<?php
    
    if ($col % 5 === 0) echo '</tr>';
  }
}

**MoForce** · 12-25-2008, 01:00 AM

Thanks! It didn't solve it exactly but I get the idea. I get an out put that looked like this:

XXXX
X
XXXX
X

Which would mean every 5th had a new row

**MoForce** · 01:07 AM

I got it! Thinking about it mathematically I figured the </tr> should go after double the max # in a row which would be 12 since the new row had to have started on the 6th instead of the 5th $col

PHP Code:


			
<?php
$query = mysql_query("SELECT * FROM inventory WHERE username='".$_SESSION['u_name']."' AND user_id='".$id."'");
$number = mysql_num_rows($query); 
if ($number > 0)
{
  for ($col = 1; $inv = mysql_fetch_array($query); $col++)
  {
    if ($col % 6 === 0) echo '<tr>';
    
?>
<td style="border:#CCCCCC solid 1px;"><div align="center"><img src="<?php echo $inv['imgpath']; ?>" width="100px" height="100px" /><br /><?php echo $inv['item']; ?></div></td>
<?php
    
    if ($col % 12 === 0) echo '</tr>';
  }
}

Thanks again!

**mgraphic** · 12-25-2008, 01:11 AM

Oh yeah - Sorry 'bout the mistake, its late. But you understood it, thats all that matters!

**maxxximus** · 12:23 PM

More a Css issue this but you should think about semantic markup and steer clear of tables for anything but tabular data.

Its a list of items which you want presented like a table so use <ul> tag and use Css for presentation.

PHP Code:


			
<?php
$query = mysql_query("SELECT * FROM inventory WHERE username='".$_SESSION['u_name']."' AND user_id='".$id."'");
$number = mysql_num_rows($query); ?>
<head>
<style type="text/css">
.item { width:200px; list-style:none; height:200px; border:1px solid #ccc; float:left; text-align:center;}
.user { width: 1010px; }
li.item img {width:100px; height:100px; }
</style>
</head>
<ul class="user">
<?php
while ($inv = mysql_fetch_assoc($query)){
?>
<li class="item">

<img src="<?php echo $inv['imgpath']; ?>"  /><p><?php echo $inv['item'] ?></p> 
</li>
<?php }
?>
</ul>