Displaying a table

webAmeteur

Ok heres another problem of mine. I am trying to display a 5column 20 row table with values from a database.

The database values are as follows:
ID 1 has value 1
ID 2 has value 2
ID 3 has value 3 and so on to 100

I want the table to look like this:

| 1 | 2 | 3 | 4 | 5 |

| 6 | 7 | 8 | 9 | 10 |

etc to

| 96 | 97 | 98 | 99 | 100 |

The values in the table however must come from the database as there are other attributes attached to them.

Here is the code I have tried, but it gives me a table 100x100, and the values are as follows

| 1 | 1 | 1 | 1 | 1 | to 100

| 2 | 2 | 2 | 2 | 2 | etc etc

<?php
do {

?>

<table>
<?php
for ($j=0; $j<=20; $j++)
{

$html .= "<tr>";

for ($i=0; $i<=5; $i++)
{
?>
<td width='15'><img src="../Images/circle1.gif" name="<?php echo $row_rstAvailSeats['seat_number'];?>"></td>
<td width='15'><div align="right"><?php echo $row_rstAvailSeats['seat_number']?></div></td>
<td width='20'><?php echo $row_rstAvailSeats['row_num']; ?></td>
<td width='20'><?php echo $row_rstAvailSeats['block_id']; ?></td>
<?php
}

$html .= "</tr>";
}
?>
</table>

<?php
} while ($row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats));
$rows = mysql_num_rows($rstAvailSeats);
if($rows > 0) {
mysql_data_seek($rstAvailSeats, 0);
$row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats);
}
?>

Any ideas what I could do??

Regards

devinemke

spool the query results into an array and then use [man]array_chunk[/man]. here is a simple example:

<?php
$array = range(1, 100);
$array = array_chunk($array, 5);

echo '<table border="1">';
foreach ($array as $value)
{
	echo '<tr>';
	foreach ($value as $sub_value)
	{
		echo '<td>' . $sub_value . '</td>';
	}
	echo '</tr>';
}
echo '</table>';
?>

webAmeteur

Thanks for that. Being new to this, and probably a bit stupid, when I use this code it display a 2x100 table with the values:

<?php
do {

?>
<?php
$array = array(1, 100);
$array = array_chunk($array, 5);

		$array[$rows] = $row_rstAvailSeats['seat_number'];
		echo '<table border="1">'; 
		foreach ($array as $value) 
		{ 
		echo '<tr>'; 
		foreach ($value as $sub_value) 
		{ 
    	echo '<td>' . $sub_value . '</td>'; 
		} 
		echo '</tr>'; 
		} 
		echo '</table>';

?>
<?php
} while ($row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats));
$rows = mysql_num_rows($rstAvailSeats);
if($rows > 0) {
mysql_data_seek($rstAvailSeats, 0);
$row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats);
}
?>

| 1 | 100 |

etc etc

Why does it not display the values

| 1 | 1 |

| 2 | 2 |

etc

Many thanks

devinemke

<?php
// connect to db first

// just guessing here at your table name
$rstAvailSeats = mysql_query('SELECT * FROM table LIMIT 100');

while ($row = mysql_fetch_assoc($rstAvailSeats))
{
	$array[] = $row;
}

$array = array_chunk($array, 5);

echo '<table border="1">';
foreach ($array as $value)
{
	echo '<tr>';
	foreach ($value as $sub_value)
	{
		echo '<td>';
		echo $sub_value['seat_number'] . '<br>';
		echo $sub_value['row_num'] . '<br>';
		echo $sub_value['block_id'] . '<br>';
		echo '</td>';
	}
	echo '</tr>';
}
echo '</table>';
?>

bpat1434

I have used a similar type of thing to display photographs in a table format of 5 columns.

Perhaps you should try:

<?php
// Connect to DB

$query = 'SELECT * FROM `table` ORDER BY id ASC LIMIT 100';
$result = mysql_query($query);
$x = 1;

echo '<table border="1"><tr>';

while($disp = mysql_fetch_array($result)){
    echo '<td>'.
          $disp['Seats_available'].
          '</td>';
    if($x%5==0){
        echo '</tr>'."\n".
              '<tr>'."\n";
    }
    $x = $x+1;
}
echo '</tr>'."\n".
     '</table>';
?>

That is something like what I use for my photograph display. Perhaps it will help you out.

~Brett

webAmeteur

That code is brilliant. Thank you so much. For some reason though it repeats the table 100 times. How would I limit it so it just displays the 5x20 table once?

Regards

bpat1434

which code?

webAmeteur

This code

<?php
// Connect to DB

$query = 'SELECT * FROM table ORDER BY id ASC LIMIT 100';
$result = mysql_query($query);
$x = 1;

echo '<table border="1"><tr>';

while($disp = mysql_fetch_array($result)){
echo '<td>'.
$disp['Seats_available'].
'</td>';
if($x%5==0){
echo '</tr>'."\n".
'<tr>'."\n";
}
$x = $x+1;
}
echo '</tr>'."\n".
'</table>';
?>

It displays a 5x20 table, 100 times. I only need this table once though. Any ideas??

Regards

webAmeteur

Sorry, the code should read:

mysql_select_db($database_conn1, $conn1);
$query_rstAvailSeats = sprintf("SELECT seat_number FROM screens WHERE screen_number = %s LIMIT 100", $urlscreennum_rstAvailSeats);
$rstAvailSeats = mysql_query($query_rstAvailSeats, $conn1) or die(mysql_error());
$row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats);
$totalRows_rstAvailSeats = mysql_num_rows($rstAvailSeats);

<?php
do {

?>
<?php

$result = mysql_query($query_rstAvailSeats);
$x = 1;

echo '<table border="1"><tr>';

while($disp = mysql_fetch_array($result)){
echo '<td>' . $disp['seat_number'];
if($x%5==0){
echo '</tr>'."\n".
'<tr>'."\n";
}
$x = $x+1;
}
echo '</tr>'."\n".
'</table>';
?>

And from that code, it produces 100 copies of the table.

Regards

bpat1434

Well,

I setup a scenario with a table called availSeats and input data from 1 - 100. Here's the code I used:

Viewable Here
Just click on Populate Table from DB.
Code will be printed below output.

That doesn't copy the table 100 times. I might think to say that you have both of our scripts working at the same time which may cause it, and what is the sprintf() in yoru query for?

~Brett