Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: NameAlerts
- Order by date
-
DATE_SUB PROBLEM
Hi, The root cause of your problem might be that you shouldn't call a column "Date" as it's the name of a MySQL function. Try changing the name to something else and see if that alleviates the problem. Best wishes, Simon. http://www.NameAlerts.com Domain Name Back Ordering &...- NameAlerts
- Post #2
- Forum: MySQL
-
SELECT problem..
If I've understood what you want correctly, it could be as simple as: SELECT DISTINCT(id_thread) FROM table WHERE id_topic='1' AND type='msg' ORDER_BY date DESC That may need a little tweaking, but it should be pretty close. Best wishes, Simon. http://www.NameAlerts.com Domain Name Back...- NameAlerts
- Post #2
- Forum: MySQL
