PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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.
I didn't read any further than this, so excuse me if this doesn't answer your question. If you are using a loop to output, put your table rows on the outer loop and the table data on the inner loop.
Well, if you are sure that it will always be twelve, and you know that you want 3 rows and 4 columns, then you would replace $foo with 3 and $bar with 4. $data would be your data from the database.
<?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>";
//This does...
//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");
$x = 0;
while($rows = mysql_fetch_array($query))
{
$itemsquery = mysql_query("SELECT * FROM items WHERE id=$rows[itemid]");
$rows2 = mysql_fetch_array($itemsquery);
$y = $x % 5;
if ($y == 0)
{
echo "<tr>";
}
echo "<td><p align=center><img src='http://kurukolands.co.uk/images/items/$rows2[image]'><br /><font color='green'><b>$rows2[name]</b></font></p></td>";
if ($y == 4)
{
echo "</tr>";
}
$x++;
}
echo "</table>";
echo "$close";
?>
It still just lines the whole lot up. Rather than the 4 by 3 rectangle I want them to be.