- 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
* 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
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