Re: [PHP] help with sql statement

2010-07-13 Thread Richard Quadling
On 12 July 2010 18:34, Tommy Pham tommy...@gmail.com wrote: SELECT srs.Name FROM SMS_R_System srs WHERE srs.SystemOUName IN (example.com/COMPUTERS/MAIN CAMPUS/ABC, example.com/COMPUTERS/MAIN CAMPUS/XYZ) As this is a single table query, there is no need for the table alias. SELECT Name FROM

[PHP] help with sql statement

2010-07-12 Thread Adam
I was google searching, and the only SQL mailing list I found is currently giving a 503 error, so I hope you don't mind me asking my SQL question here, since there are a lot of SQL gurus here. I am having a syntax problem: Instead of doing a query like this:: select SMS_R_SYSTEM.Name from

Re: [PHP] help with sql statement

2010-07-12 Thread Ashley Sheridan
On Mon, 2010-07-12 at 10:24 -0500, Adam wrote: I was google searching, and the only SQL mailing list I found is currently giving a 503 error, so I hope you don't mind me asking my SQL question here, since there are a lot of SQL gurus here. I am having a syntax problem: Instead of doing

RE: [PHP] help with sql statement

2010-07-12 Thread Tommy Pham
-Original Message- From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: Monday, July 12, 2010 8:26 AM To: Adam Cc: PHP General Subject: Re: [PHP] help with sql statement On Mon, 2010-07-12 at 10:24 -0500, Adam wrote: I was google searching, and the only SQL mailing

Re: [PHP] Help with SQL statement

2005-02-18 Thread Bret Hughes
On Thu, 2005-02-17 at 23:21, Jacques wrote: How can I determine which users have signed in and are still on-line during the first minute after they have signed in? My sql statement currently reads: SELECT * FROM tblusers WHERE usignedin = yes AND utimesignedin = (time() - 60) Hoe does

[PHP] Help with SQL statement

2005-02-17 Thread Jacques
How can I determine which users have signed in and are still on-line during the first minute after they have signed in? My sql statement currently reads: SELECT * FROM tblusers WHERE usignedin = yes AND utimesignedin = (time() - 60) Hoe does one indicate seconds in a SQL statement? Can I use

[PHP] Help with SQL statement

2003-03-03 Thread Sarah Heffron
I have a database that holds a start date and an end date and I have a form with a start date and an end date. The report would be to get everything in the database's date ranges that overlap the form's date range. I am having trouble figuring out how to get this to work, any help is appreciated.

Re: [PHP] Help with SQL statement

2003-03-03 Thread David Otton
On Mon, 03 Mar 2003 12:04:37 -0800, you wrote: I have a database that holds a start date and an end date and I have a form with a start date and an end date. The report would be to get everything in the database's date ranges that overlap the form's date range. I am having trouble figuring out