[Simon Lloyd]

Originally Posted by KristerSwe

okey i tried this now and i this is my settings

SELECT * 
 , COUNT(postusername) as count  
FROM hdthread  
WHERE title LIKE "Article:%" 
 AND postuserid =1

and finded only 1 post of many i have made . sorry am not so familiar with all this

Assuming you ARE userid 1 your query should have been this

SELECT * 
 , COUNT(postusername) as count  
FROM hd_thread  
WHERE title LIKE "Article:%" 
 AND postuserid =1

run it and let me know the results , remember it will only show you a single row so it will only be one post but im interested in the column on the far right!