PHP table question.
Posted: Wed Sep 16, 2009 7:41 am
Ok well I have my script set up so that it will echo out 10 of the values found in a specific database table. These values are echoed into a HTML table, however at the moment they all just go in one like strait down. Im wanting to know if its possible to make it so that I could get like 4 values to appear per line then goes down to the next bit for another 4 and so on, to make 12 in total.
Like this:
{} {} {}
{} {} {}
{} {} {}
Instead of this:
{}
{}
{}
{}
Heres the script at the moment:
Thanks, in advance. Im sure im just missing something silly, but my table knowledge has always been a bit pants.
Like this:
{} {} {}
{} {} {}
{} {} {}
Instead of this:
{}
{}
{}
{}
Heres the script at the moment:
Code: Select all
<?php
require("../includes/config.php");
echo "$open";
if(isset($loggedout))
{
die("$loggedout");
}
//Makes the username's first letter uppercase.
$ucusername = ucfirst($username);
echo "<h1>$ucusername's House Storage</h1>";
//Checks in the 'inventory' whether there are any items belonging to the user with the ID set to their account.
$query = mysql_query("SELECT * FROM storage WHERE userid='$id' LIMIT 10");
while($rows = mysql_fetch_array($query))
{
$itemid = $rows['itemid'];
$itemsquery = mysql_query("SELECT * FROM items WHERE id='$itemid'");
//
while($rows2 = mysql_fetch_array($itemsquery))
{
$itemimage = $rows2['image'];
$itemname = $rows2['name'];
$itemdescription = $rows2['description'];
}
if(mysql_num_rows($query) =< 3)
{
echo<<<echo
<center><table><tr ><td width='80'><img src='http://kurukolands.co.uk/images/items/$itemimage'><br /></td><tr><font color='green'><b>$itemname</b></font></tr></tr></table></center>
echo;
}
if(mysql_num_rows($query) =< 3)
{
echo<<<echo
<center><table><tr ><td width='80'><img src='http://kurukolands.co.uk/images/items/$itemimage'><br /></td><tr><font color='green'><b>$itemname</b></font></tr></tr></table></center>
echo;
}
}
echo "$close";
?>