include("inc_sessionstart.php"); include("inc_masthead.php"); include("inc_config.php"); include("inc_accesscontrol.php"); include("inc_dbconnect.php"); ?>
$sql="SELECT tblcustomer.customerid, tblcustomer.username, tblcustomer.password, tblcustomer.firstname, tblcustomer.lastname, tblcustomer.company FROM tblcustomer ORDER BY tblcustomer.company, tblcustomer.lastname, tblcustomer.firstname ASC"; $sql_result = mysql_query($sql,$connection) or die("Couldn't execute Customer List query."); if (!$sql_result) { echo "
Couldn't Find Any Customers!"; }else{ $num = mysql_num_rows($sql_result); if ($num == 0) { echo "Sorry, There were no matching results. Please try again."; exit; } echo "
| "; echo "$company"; echo " | "; echo ""; echo "$lastname, $firstname"; echo " | "; echo ""; echo "Delete "; echo " | "; echo "