Re: [PHP] help with sql statement

2010-07-13 Thread Richard Quadling
On 12 July 2010 18:34, Tommy Pham 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 SMS_R_System

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 w

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

[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 SM

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

[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

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

[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.