[paulj000]

I want to make rows in HTML of the entries in the database. I need them to format like this based on different amount of entries based of ID's:

(if 9 entries in database):
<tr><td> 1 </td><td> 2 </td><td> 3 </td><td> 4 </td></tr>
<tr><td> 5 </td><td> 6 </td><td> 7 </td><td> 8 </td></tr>
<tr><td> 9 </td><td> </td><td> </td><td> </td></tr>

(if 4 entries in database):
<tr><td> 1 </td><td> 2 </td><td> 3 </td><td> 4 </td></tr>

(if 7 entries in database):
<tr><td> 1 </td><td> 2 </td><td> 3 </td><td> 4 </td></tr>
<tr><td> 5 </td><td> 6 </td><td> 7 </td><td> </td></tr>

Thanks as I have been going nuts trying to get this to work properly!

[the_mole001]

Hello paulj000,

you would need some code like this:

for($i=0;$i <= mysql_num_rows($query);$i++){
echo "<td>$i<td>";
}

Or well at least I hope that could should work for ya, give it a try and if it don't work out perhaps you could experiment until you get it right?

Peter

[paulj000]

howdy, I have it going that far my real problem is I can't get it to stop at 4 columns (ID 1 - ID 4) and then start a NEW row with ID 5 - ID 9. etc etc

make sense? I need a new row drawn out for every 4 entries...

[the_mole001]

Hey again,

yeah sorry, i noticed that upon posting, oops! anyhow I went back through some of my code I have written and I came accross this that might help ya:

$columns = 4;
$rows = mysql_num_rows($items);
echo "<table width='90%' cellspacing=0 cellpadding=4 align='center'>";
for($i = 0; $i < $rows; $i++) {
$row = mysql_fetch_array($items);
if($i % $columns == 0) {
echo "<tr>";
}
//WHAT YOU WANT TO ECHO HERE eg "<td>1</td>";
if(($i % $columns) == ($columns - 1) || ($i + 1) == $rows) {
echo "</tr>";
}
}
echo "</table>";

sorry if it's a bit all over the place, but it's pretty easy to follow when you realli think about it. Hope it helps

Peter

[paulj000]

Thanks Peter!

that actually works!!!
<?php
$items = mysql_query("SELECT * FROM table;");

$columns = 4;

$rows = mysql_num_rows($items);
echo "<table width='90%' cellspacing=0 cellpadding=4 align='center'>";

for($i = 0; $i < $rows; $i++) {
$row = mysql_fetch_array($items, MYSQL_ASSOC);

if($i % $columns == 0) {
echo "\n<tr>";
}

echo "<td>$row[ID]</td>";

if(($i % $columns) == ($columns - 1) || ($i + 1) == $rows) {
echo "</tr>";
}
}
echo "</table>";


?>


There is one part I do not understand: $i % $columns
So I can learn, what does that mean/do??

Thanks again
- paul

[the_mole001]

Hey again,

Basically it gets the current number going through and checkes it against the chosen amount eg 0 / 4 is 0 so it prints the start of a new row. Sometimes I don't really get the script either but it does what I wanted it to do lol.

Peter

EDIT: I decided to do my h/w and stop cutting off short and no, its not what i came up with above. What the % actually does is calculate the remandier.

0 % 4 = 0
4 % 4 = 0
8 % 4 = 0

and then the closeing tags look like

3 % 4 = 3
7 % 4 = 3
11 & 4 = 3

and so on, so its just devision but instead of giving the devised number gives you the remainder. Hope that helps.

Peter

[dcooldude_1]

Just an added thought to Moles post, put can come in REAL handy in a lot of situations. For example, I'm working on a stupid Black Jack game in J# for school. Well, since computers think mainly in numbers, you almost HAVE to use the % operator.

What I'm saying is you have 52 cards, 1-52, right? Well, you randomly pick a card, and if it's 25, you need to know what suit it's in and what it's value is. So after setting the rules, it's easy with that operator.