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