";
$query="SELECT c.*, a.name AS account_name FROM contacts c LEFT JOIN accounts a ON c.account_id=a.id WHERE $search ORDER BY $order_by";
}
else {
$query="SELECT c.*, a.name AS account_name FROM contacts c LEFT JOIN accounts a ON c.account_id=a.id ORDER BY $order_by";
}
}
else {
$query="SELECT c.*, a.name AS account_name FROM contacts c LEFT JOIN accounts a ON c.account_id=a.id ORDER BY $order_by";
}
// prints start of table
echo "
|
| Name |
Account Name |
E-Mail |
Office # |
";
// form the query for selecting all contacts
include("inc/db_connect.php");
$result=mysql_query($query) or die(mysql_error());
mysql_close();
// set up loop variables and do
$i=0;
while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$account_id = $row['account_id'];
$account_name = $row['account_name'];
$email1 = $row['email1'];
$phone_work = $row['phone_work'];
$full_name = $first_name.' '.$last_name;
$row_color = ($i % 2) ? $color1 : $color2;
echo "
| $full_name |
$account_name |
$email1 |
$phone_work |
";
$i++;
}
// ends table
echo "
";
?>