Multiple Variable in one SQL Like

Question

I searched a lot and cannot find my answer. I'm trying to include 2 variable in my like statement to match a date that wasn't formatted correctly in a database I'm working on.

I need to:

Select count(*) as ABC 
    from database 
    where active like '1' 
        and agent = '$Employeestringid' 
        AND time LIKE '%$FilterMonth_%_$queryyear'"

The part that is currently not working is: '%$FilterMonth_%_$queryyear'

I need it to work and match a date formatted like: '9:10:31 PM Fri, May 20th 2016' by only capturing MONTH and YEAR.

Why not just part out the time to the two values being passed in and do an equality check? Consider and year(time) = $Queryyear and month(time) = $FilterMonth Doc Date Functions — xQbert
– xQbert, Commented Jun 1, 2016 at 19:03

gen_Eric · Accepted Answer · 2016-06-01 18:57:49Z

1

When interpolating your variables in the string, PHP reads the _ as part of the variable name.

You need to use {} to prevent this behavior:

$query = "Select count(*) as ABC 
    from database 
    where active like '1' 
        and agent = '$Employeestringid' 
        AND time LIKE '%{$FilterMonth}_%_{$queryyear}'";

answered Jun 1, 2016 at 18:57

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SiREKT Over a year ago

Awesome! This worked - thank you very much for your quick help Rocket :)

Mojtaba · Accepted Answer · 2016-06-01 18:56:15Z

0

Remove the underscores

'%$FilterMonth%$queryyear'

answered Jun 1, 2016 at 18:56

Mojtaba

5,0275 gold badges24 silver badges40 bronze badges

2 Comments

SiREKT Over a year ago

Thanks Mojtaba - The recommendation that I received from Rocket worked in my code :) Problem solved.

Mojtaba Over a year ago

@SiREKT. Glad to hear that. So, please mark it as solved

Collectives™ on Stack Overflow

Multiple Variable in one SQL Like

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related