PHP - Nested Looping Trouble
- by Jeremy A
I have an HTML table that I need to populate with the values grabbed from a select statement.
The table cols are populated by an array (0,1,2,3).
Each of the results from the query will contain a row 'GATE' with a value of (0-3), but there will not be any predictability to those results. One query could pull 4 rows with 'GATE' values of 0,1,2,3, the next query could pull two rows with values of 1 & 2, or 1 & 3.
I need to be able to populate this HTML table with values that correspond. So HTML COL 0 would have the TTL_NET_SALES of the db row which also has the GATE value of 0.
<?php
$gate = array(0,1,2,3);
$gate_n = count($gate);
/*
Database =
my_table.ID
my_table.TT_NET_SALES
my_table.GATE
my_table.LOCKED
*/
$locked = "SELECT * FROM my_table WHERE locked = true";
$locked_n = count($locked);
/* EXAMPLE RETURN
Row 1:
my_table['ID'] = 1
my_table['TTL_NET_SALES'] = 1000
my_table['GATE'] = 1;
Row 2:
my_table['ID'] = 2
my_table['TTL_NET_SALES'] = 1500
my_table['GATE'] = 3;
*/
print "<table border='1'>";
print "<tr><td>0</td><td>1</td><td>2</td><td>3</td>";
print "<tr>";
for ($i=0; $i<$locked_n; $i++)
{
for ($g=0; $g<$gate_n; $g++)
{
if (!is_null($locked['TTL_NET_SALES'][$i]) && $locked['GATE'][$i] == $gate[$g]) {
print "<td>$".$locked['TTL_NET_SALES'][$i]."</td>";
} else {
print "<td>-</td>";
}
}
}
print "</tr>";
print "</table>";
/*
What I want to see:
<table border='1'>
<tr>
<td>0</td>
<td>1</td>
<td>2</td>
<td>3</td>
</tr>
<tr>
<td>-</td>
<td>1000</td>
<td>-</td>
<td>1500</td>
</tr>
</table>
*/
?>
