what is wrong with this query?

[lukeurtnowski]

I cant figure out what is wrong whith this query
select *, DATE_FORMAT(a_date, '%m/%d/%Y') as a_date_formatted from company, activity where c_id=a_c_id and medivas ='$poc' and priority ='$prioritya' and priority ='$priorityc'
any ideas???
thanks😕

[bradgrafelman]

Yeah. You can't combine "SELECT *" with other columns.

Plus, do you really need to select every single column in that table? You need to be optimizing your SQL queries. Pick out which columns you need and are going to use in your code and SELECT those, i.e.

select `column1`, `column2`, DATE_FORMAT(a_date, '%m/%d/%Y') as a_date_formatted from company, activity where c_id=a_c_id and medivas ='$poc' and priority ='$prioritya' and priority ='$priorityc'