Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

websitedatabases · 11-03-2005, 08:12 PM

Give this a try:

Code:

SELECT * FROM writer_articles a
INNER JOIN writer_comments
c ON c.id = a.id
WHERE a.id = $id
ORDER BY date_time DESC

11-03-2005, 08:12 PM	#2 (permalink)
websitedatabases Junior Member Join Date: Jul 2005 Posts: 12	Give this a try: Code: SELECT * FROM writer_articles a INNER JOIN writer_comments c ON c.id = a.id WHERE a.id = $id ORDER BY date_time DESC __________________ Build your own PHP MySQL web databases