Mysql Query Not Giving Output

Question

Iam newbie to Php and mysql.I have a datetime field in database and upon that datetime field iam generating a report.Here is my query

$date = $year."-".$month;
SELECT *FROM table WHERE request_date LIKE '$date%';

The month and year variables iam taking from input fields in a form.Here iam concatinating those two variables and passing them in the query.But it retruns nothing. The stored value in request_date is of formate 2011-02-28.

Kindly help how to do this.

regards;

Try to echoing SELECT *FROM table WHERE request_date LIKE '$date%'; what is it echoing? — Bindiya Patoliya
– Bindiya Patoliya, Commented Sep 5, 2013 at 4:22
First write properly your query, create space between * and FROM SELECT * FROM — user1502952
– user1502952, Commented Sep 5, 2013 at 4:25

chinna_82 · Accepted Answer · 2013-09-05 04:28:53Z

1

put space between * and FROM like this.

$date = $year."-".$month;
SELECT * FROM table WHERE request_date LIKE '$date%';

answered Sep 5, 2013 at 4:28

chinna_82

6,40318 gold badges84 silver badges137 bronze badges

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

Comments

Sudhir Bastakoti · Accepted Answer · 2013-09-05 04:25:38Z

1

If you need to query for Year and month field then you could do:

SELECT * FROM projects 
WHERE YEAR(request_date) = $year AND MONTH(request_date) = $month

answered Sep 5, 2013 at 4:25

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Collectives™ on Stack Overflow

Mysql Query Not Giving Output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related