I have the following php, which runs through my database table and pulls out all of the fields and displays themm within an alternate coloured table.
Code: Select all
echo "<TABLE BORDER=\"0\" table width=\"100%\">\n";
echo "<TR bgcolor=\"#cccccc\"><TD font colour=\"red\"><b>Asset</b></TD><TD><b>Title</b></TD><TD><b>Customer</b></TD><TD><b>Type</b></TD><TD><b>IP address</b></TD><TD>Reconciled</TD>/TR>\n";
for($i = 0; $i < $numofrows; $i++) {
$reconciled = include("reconciled.php");
$row = mysql_fetch_array($result); //get a row from our result set
$stopped = $row['stopped'];
$void = $row['title'];
if($stopped =='yes'){
echo "<TR bgcolor=\"#C1FFD1\">\n";
}
else if($void =='VOID'){
echo "<tr bgcolor=\"#FFCCCC\">\n";
}
else if($i % 2) {
echo "<TR bgcolor=\"#ffff99\">\n";
}
else {
echo "<TR bgcolor=\"#ffffcc\">\n";
}
echo "<TD><font color=\"red\"><b><a href='viewall.php?varl=".$row['asset']."'>".$row['asset']."</a></b></font></TD><TD><font size=\"2\">".$row['title']."</TD><TD><font size=\"2\">".$row['customer']."</TD><TD><font size=\"2\">".$row['type']."</TD><TD><font size=\"2\">".$row['IP']."</TD><TD>".$row['$reconciled']."</TD>\n";
echo "</TR>\n";
}
echo "</TABLE>\n";
?>As you can see I have put
Code: Select all
$reconciled = include("reconciled.php");<TD>".$row['$reconciled']."</TD>
However this is not working.. How do I call the reconciled.php script to run and then display the output (an image) within the last table coloumn?