DISTINCT not working right....
Posted: Sun Mar 20, 2011 11:08 am
I am only trying to get one of each article_id. It seems to be getting the whole database instead.
$sql = "
SELECT DISTINCT article_id, pqdb_articles.*, category_id, category_name, SUBSTRING_INDEX(article_text,' '," . CENTER_COLUMN_PREVIEW . ") AS text
FROM pqdb_articles, pqdb_categories
WHERE article_title LIKE '%$search%' OR article_text LIKE '%$search%'
AND category_id = article_cat ";