my code is producing the correct number of expected rows, however there is no output.
In other words, it loops through creates the expected 3 table rows, however, no data is written.
When I run the same SQL statement in PHPmyAdmin it produces the expected results.
Any light shed on this issue is greatly appreciated.
<?
$result = mysql_query("SELECT
Route.RouteName,
Route.id,
ServiceProvider.SP
FROM
ServiceProvider
Inner Join Route ON ServiceProvider.id = Route.SP_id") or trigger_error(mysql_error());
while($row = mysql_fetch_array($result)){
foreach($row AS $key => $value) { $row[$key] = stripslashes($value); }
echo "<tr>";
echo "<td valign='top'>" . nl2br( $row['Route.id']) . "</td>";
echo "<td valign='top'>" . nl2br( $row['Route.RouteName']) . "</td>";
echo "<td valign='top'>" . nl2br( $row['ServiceProvider.SP']) . "</td>";
echo "<td valign='top'><a href=Route_edit.php?id={$row['id']}>Edit</a></td><td><a href=Route_delete.php?id={$row['id']}>Delete</a></td> ";
echo "</tr>";
}
echo "</table>";
echo "<a href=Route_new.php>New Row</a>";
?>
