[Cialug] SQL Query

[Bailey, Jonathan C]

Opps.... Figured it out. $sql =3D and $sql .=3D are VERY different =
beasts...


Jon

-----Original Message-----
From: cialug-admin@cialug.org [mailto:cialug-admin@cialug.org]On Behalf
Of Bailey, Jonathan C
Sent: Friday, December 10, 2004 7:30 PM
To: cialug@cialug.org
Subject: [Cialug] SQL Query


Is there something I'm missing here?

select * from workorders where (Customer=3D1 or Customer=3D2 or =
Customer=3D3 or Customer=3D7 or Customer=3D9) and (Priority=3D'E' or =
Priority=3D'A') and (Status=3D'O' or Status=3D'C') and =
(Assignment=3D'0001' or Assignment=3D'0002') and select * from =
workorders where (Customer=3D1 or Customer=3D2 or Customer=3D3 or =
Customer=3D7 or Customer=3D9) and (Priority=3D'E' or Priority=3D'A') and =
(Status=3D'O' or Status=3D'C') and (Assignment=3D'0001' or =
Assignment=3D'0002');=20


#1064 - You have an error in your SQL syntax.  Check the manual that =
corresponds to your MySQL server version for the right syntax to use =
near 'select * from workorders where (Customer=3D1 or Customer=3D2 or =
Cus=20






--------------------
Jonathan Bailey
POS Analyst
bailj0@bp.com
(515) 226-5005

_______________________________________________
Cialug mailing list
Cialug@cialug.org
http://cialug.org/mailman/listinfo/cialug