im using an mySQL query on one of our web pages and im getting an error.
the query is pulling in records and converting the date.
SELECT date_format(pressDate,'%d/%m/%Y') AS f_date,rssDesc,pressSubject,pressStory
WHERE pressID = colname
ORDER BY pressDate desc
the error we're getting is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 18446744073709551615' at line 1
does anyone know what the problem could be?
thanks in advance