create table for unknown number of vars

SeenGee

I need to create a table that will display results from a mysql_fetch_array result set when the number of returned results is not known, i want to dislpay the results in rows of 3 with a td for each one but i'm not sure how to go about this considering if there are for example 7 results, there would be two full rows but one row with only one piece of data to display, how can i make sure that the tds are still created even though there will be no data contained in the last 2 as otherwise the formatting will be all wrong.

Thanks.

DRuCuLa

u can do this using modula or the function fmod.
http://us2.php.net/manual/en/function.fmod.php
example:

$count = 0;
while($row = mysql_fetch_array($query))
{
  if($count % 3 == 0)
    $output .= "<tr>";
  $output .= "<td>".$row['data1']."</td>\n<td>".$row['data2']."</td>";
  if(fmod($count,3) == 0)
    $output .= "</tr>";
  $count++;
}

something like that.

SeenGee

can you explain what is actually happening there please, thanks.

SeenGee

yeah, i cant get that code to do anything at the moment.

DRuCuLa

didnt u learn this in school?
5 / 4 = 1 (1)
10 / 3 = 3 (1)
15 / 5 = 3 (0)
10 / 4 = 2 (2)
modula returns the number in the brackets.
so
7 % 3 = 1
1113 % 3 = 0
5644 % 10 = 4

Algorithm(i hope it's spelled corretly... 😃):
(1) reseting the count
(2) begining the loop:
(2.1) if counted row modula 3 equels 0
(2.1.1) begin a new table(<table>) row(<tr>)
(2.2) add fields(<td>) to the table
(2.3) if counted row modula 3 equels 0
(2.3.1) end the current row(</tr>)
(2.4) update the count

is it clear now?

SeenGee

nope, never done anything like that in school, that i can remember anyways. lol. I still get no output from your code though when i apply a query to it. like this:

$sql = "SELECT * FROM `menswear";
$query = mysql_query($sql) or die(mysql_error());

$count = 0;
while($row = mysql_fetch_array($query))
{
  if($count % 3 == 0)
    $output .= "<tr>";
  $output .= "<td>".$row['data1']."</td>\n<td>".$row['data2']."</td>";
  if(fmod($count,3) == 0)
    $output .= "</tr>";
  $count++;
}

would really appreciate a few pointers, thanks.

SeenGee

nb: i know that $row['data1'] for example will be empty but surely the tr and td should still be printed but when i view source nothing has been created.

DRuCuLa

i didnt make them print, just add them to the var $output.
if u want to print it, then write at the end:
print $output;

i'm glad i can help.