RE: [PHP] MSSQL/PHP Query Help

2002-06-12 Thread Leotta, Natalie (NCI/IMS)
have you tried Nics.MAC in ("xxx","xxx","xxx","xxx")? There's a lot less room for error in that, because it's so much tidier. -Natalie -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:56

[PHP] MSSQL/PHP Query Help

2002-06-12 Thread Michael
Hey guys... I'm currently using PHP, FreeTDS, and Sybase libraries to access a database on an MS SQL 2000 server. Things are going fine, except for my more complex queries. Here is an example: SELECT Servers.Name, Nics.MAC FROM Servers INNER JOIN Nics ON Servers.ServerId = Nics.Server WHERE ((