Posted by Bob Stearns on 09/29/78 11:58

jerryyang_la1@yahoo.com wrote:
> Hi
>
> I'm using this query with PHP and an Access database. It works well and
> returns the results expected..
>
> [code]
> strSQL = _
> "SELECT * FROM tbl" &_
> "WHERE CDATE(Date) = #" & dtOnDay & "# OR Date2 = #" & dtOnDay & "#
> OR Date3 = #" & dtOnDay & "# OR Date4 = #" & dtOnDay & "# OR Date5 = #"
> & dtOnDay & "# OR Date6 = #" & dtOnDay & "# OR Date7 = #" & dtOnDay &
> "#"
> [/code]
>
> What I need to do is filter the results..
> Currenlty this returns all the results were the date is matched.
>
> But I need to do the above AND this:
>
> WHERE userID = SearchedUsername OR WHERE userID2 = SearchedUsername
>
> HELP !
>
> Thanks
>

I really don't know the syntax, dbms or system you are using, but the
following is consistent with your example and performs the required
logic. You didn't ask (or show DDL etc.) but from your example and
requirements your database table is far from 1NF and needs looking at.

"SELECT * FROM tbl" &_
"WHERE ( CDATE(Date) = #" & dtOnDay &
"# OR Date2 = #" & dtOnDay &
"# OR Date3 = #" & dtOnDay &
"# OR Date4 = #" & dtOnDay &
"# OR Date5 = #" & dtOnDay &
"# OR Date6 = #" & dtOnDay &
"# OR Date7 = #" & dtOnDay &
"# )" &
"AND ( userID = #" & SearchedUsername &
"# OR userID2 = #" SearchedUsername &
"# )

• Next in forum: Re: Looking for the right mysql syntax
• Prev in forum: Looking for the right mysql syntax
• Thread view: Re: Help with a query please !! It works but needs adjusting !

[Reply to this message]