Posted by jerryyang_la1 on 10/08/24 11:58

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

• Next in forum: Creating FUNCTIONS/PROCEEDURES
• Prev in forum: Re: Can anyone help a newbie figure out MySQL?
• Thread view: Help with a query please !! It works but needs adjusting !

[Reply to this message]