isadmin()) die('Access Denied'); $exists = mysql_query("SELECT * FROM ".CLIENT_TABLE); if(!$exists) { if(mysql_query("CREATE TABLE ".CLIENT_TABLE." (client_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(client_id), firstname VARCHAR(32), lastname VARCHAR(32), email VARCHAR(128), phone VARCHAR(24), phone_ext VARCHAR(6), mobile VARCHAR(24), company VARCHAR(128), is_active TINYINT(4))")=="true") echo "Client table created successfully."; else echo "Client table not created."; } $sortOptions=array('firstname'=>'firstname','lastname'=> 'lastname','email'=>'email','phone'=>'phone', 'phone_ext'=>'phone_ext', 'mobile' => 'mobile', 'company' => 'company', 'is_active' => 'is_active'); $orderWays=array('DESC'=>'DESC','ASC'=>'ASC'); if($_REQUEST['sort']) { $order_by =$sortOptions[$_REQUEST['sort']]; } if($_REQUEST['order']) { $order=$orderWays[$_REQUEST['order']]; } $order_by =$order_by?$order_by:'lastname'; $order=$order?$order:'ASC'; $negorder=$order=='DESC'?'ASC':'DESC'; $query = "SELECT * FROM ".CLIENT_TABLE." ORDER BY $order_by $order"; $results = mysql_query($query); $rows = mysql_num_rows($results); ?>

Clients ()

0) { while($row = mysql_fetch_assoc($results)) { ?> 0): //Show options.. ?>

	First	Last	Email	Phone	Ext.	Mobile	Office	Status
onClick="highLight(this.value,this.checked);">
Select: All Toggle None

Add New Client