"; echo "Asset Details"; //run the query $result = mysql_query("SELECT * FROM AssetDetails"); echo ""; echo " "; } echo "

"; echo "Asset No"; echo "	"; echo "Asset Name"; echo "	"; echo "Location"; echo "	"; echo "Creation Time"; echo "	"; //access each row via an array while($row = mysql_fetch_array($result,MYSQL_BOTH)) { echo "
"; echo $row[0]."	".$row[1]."	".$row[2]."	".$row[3]; echo " "; echo "

"; echo "
"; echo "Asset Modification"; //run the query $result = mysql_query("SELECT * FROM AssetModification"); echo ""; echo " "; } echo "

"; echo "Date & Time of Modification"; echo "	"; echo "Asset No"; echo "	"; echo "Modification Made"; echo "	"; echo "Reason for Change"; echo "	"; //access each row via an array while($row = mysql_fetch_array($result,MYSQL_BOTH)) { echo "
"; echo $row[0]."	".$row[1]."	".$row[2]."	".$row[3]; echo " "; echo "

"; mysql_close($con); ?>