802 Posted Topics
 | If your code is supposed to be PHP, it should read [CODE]...where Emp_Id like ('%$empid%') and... [/CODE]assuming it is quoted with double quotes. If it is supposed to by JavaScript, drop the '$' before the variable names. If it is supposed to be plain MySQL, it might rather read: [CODE]...where … |
| | Since you are mixing prices, pageViews and dates in mysql and european format it is not quite clear what you are aiming at. Maybe you could try something along the lines: select * from prices where date in select max(date) as date1 from prices group by year(date),week(date) Test: [CODE]drop table … |
The End.