Simple DateTime sql query with php object

Question

This is my Query . It does not give result.If i place a quote the query runs. How to place that quote.

Select sum(r.views) as sum_views ,r.revenue_date ,
l.lot_id ,l.lot_name,r.type_name 
FROM tbl_revenue_upload r , tbl_lot_details as l
WHERE  AND l.lot_id ='.$search['lot'].' 
And revenue_date >= '.$search['from_date'].'
And revenue_date <= '.$search['to_date'].'
group by r.type_id ,month(revenue_date)

Your query seems to be Incorrect with syntax Errors. There is no condition for checking under WHERE condition :) — Naresh Kumar P, Aug 30 '16 at 04:45
Worth having a look at this [\[ this \]](http://stackoverflow.com/a/24989031/1620779) answer. — sjsam, Aug 30 '16 at 05:16
For goodness sake, please consider using prepared statements. — Jens Mühlenhoff, Sep 02 '16 at 14:12

score 0 · Accepted Answer · edited Aug 30 '16 at 05:41

0

'Select sum(r.revenue) as sum_revenue ,sum(r.views) as sum_views ,r.revenue_date ,l.lot_id ,l.lot_name,r.type_name 
                     FROM tbl_revenue_upload r , tbl_lot_details as l
                     WHERE r.video_id = l.video_id AND l.lot_id ='.$search['lot'].' 
                     And revenue_date >= "'.$search['from_date'].'"
                     And revenue_date <= "'.$search['to_date'].'"
                     group by r.type_id ,month(revenue_date)

edited Aug 30 '16 at 05:41

Amitesh Kumar

3,051
1
26
42

answered Aug 30 '16 at 04:46

priyanka sawant

59
9

There is no problem with answering your own question, but please include the details regarding the changes and why you think those changes are relevant. – sjsam Aug 30 '16 at 05:50
And if something starts with an inverted comma, perhaps it should end with one too – Strawberry Aug 30 '16 at 06:36
1

@sjsam .The error was just too add comma " " and it worked fined – priyanka sawant Aug 31 '16 at 11:47
1

@priyankasawant Glad that this works. As I have mentioned in my comment to q, you may use prepared statements which makes your life easier. – sjsam Aug 31 '16 at 11:50

Simple DateTime sql query with php object

1 Answers1