php & concat problem please help!!!

hoax_monkey

Hi I have a form which submits the year, month and day. What I am trying to do is make year, month, and day a single string instead of 3 seperate ones and call it $yearmonthday. This is because I want to use that variable when selecting data from my database using a LIKE query. Can anyone help??
Thanks

$yearmonthday == $year.$month.$day;
echo '$yearmonthday';
$query = "SELECT * FROM orders WHERE order_date LIKE '$yearmonthday%' ORDER BY order_id ASC";

MattDurnan

That should work.

You should use a timestamp really. Look here: gmmktime

$yearmonthday == "$year$month$day";

mrhappiness

$yearmonthday == "$year$month$day"; also compares since you wrte == and not =

it is even slower i believe since you enveloped the 3 variables by " and " so php has to search the string for variables to parse

$yearmonthday = $year.$month.$day; should work i guess

laserlight

If you dont intend to use the variable again, then simpler still would be:

$query = "SELECT * FROM orders WHERE order_date LIKE '" . $year . $month . $day . "%' ORDER BY order_id ASC";

btw, shouldnt the % be outside the single quotes?

MattDurnan

Sorry i didnt mean to place two ==.