The way I do this is a very simple bit of code:
Outside the "while" statement, add the line:
$column = 1;
Then, inside the "while" statement, take the <tr></tr> statements out and
instead do something like this:
$column++;
if ($column > 3)
{
echo "</tr><tr>";
$column = 1;
}
This will render a new table row every time the counter reaches 3. You can
change that number to make as many cells as you want before rendering a new
table row.
You will probably want to take the <table></table> out of the "while"
statement too, unless you really do want to make a new table for every record
returned.
Hope that helps.
Good luck,
Dan
> Hi everyone!
>
> Is there a good tutorial on how to write html tables in PHP?
>
> In my last post "Not displaying all records" I have the items
> displayig all the contents of the table but they are in descending order.
> like this
> item 1
> item 2
>
> Here is the code I am using
>
> $query = "SELECT id, name, image, quantity FROM {$config["prefix"]}_my_items
> WHERE uid={$session["uid"]} ORDER BY id";
> $ret = mysql_query($query);
> while($row = mysql_fetch_array($ret)){
> $image = $row['image'];
> $name = $row['name'];
> $quantity = $row['quantity'];
>
> $display_block ="<img src=$image><CENTER><br>$name<BR>$quantity</CENTER>";
> echo "<table><tr><td>$display_block</td></tr></table>";
> echo"";
> }
>
> I have already tried this
>
> $display_block ="<img src=$image><CENTER><br>$name<BR>$quantity</CENTER>";
> echo
> "<table><tr><td>$display_block</td><td>$display_block</td></tr></table>";
> echo"";
>
> But it displays 2 sets of all items still in descending order beside
> each other:
>
> item 1 item 1
> item 2 item 2
>
> What I wnat is to display them
>
> item 1 item 2 item 3
>
> Is there a way to do this?
>
> Thanks
> Jennifer
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
------- End of Forwarded Message -------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
