You probably want something more like this (see modified code below).

Note that if you get a lot of records, your html table will keep 
expanding out to the right. You might want to break it up with rows ... 
or not, as you like.

There are quite a few places that have intros to php subjects. Check out 
the list at http://www.php.net/links.php

-Steve


<?php
...
$query = "SELECT id, name, image, quantity FROM 
{$config["prefix"]}_my_items
WHERE uid={$session["uid"]} ORDER BY id";
$ret = mysql_query($query);

// start your table here, outside the loop
echo "<table><tr>";

while($row = mysql_fetch_array($ret)){
     // note: indenting your code in loops makes it much easier to see 
what's going on :)
     $image = $row['image'];
     $name = $row['name'];
     $quantity = $row['quantity'];

     $display_block ="<img 
src=$image><CENTER><br>$name<BR>$quantity</CENTER>";

     // show each record in its own cell here
     echo "<td>$display_block</td>";
}

// finish up the table outside the loop
echo "</tr></table>";

?>

On Wednesday, April 10, 2002, at 01:17  PM, Jennifer Downey wrote:

> 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
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to