Re: Query question (php)

2003-11-11 Thread Obantec Support1
- Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Obantec Support1" <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 8:46 PM Subject: Re: Query question (php) > * Obantec Support1 > > mysql 3.2

Re: Query question (php)

2003-11-11 Thread Roger Baklund
* Obantec Support1 > mysql 3.23.56 RH 8.0 > > I have got the sql query to work but is there a better way of writing the > syntax? > > $sql = "SELECT * FROM Contacts WHERE Categories=\"$calltype\" and > BusinessCodes !=\"R\" and BusinessCodes !=\"I\" and BusinessCodes !=\"L\" > ORDER BY Company A

Query question (php)

2003-11-11 Thread Obantec Support1
Hi mysql 3.23.56 RH 8.0 I have got the sql query to work but is there a better way of writing the syntax? $sql = "SELECT * FROM Contacts WHERE Categories=\"$calltype\" and BusinessCodes !=\"R\" and BusinessCodes !=\"I\" and BusinessCodes !=\"L\" ORDER BY Company ASC"; basically i Categories (a