There was a small logical check missed in my automated blog(KuwaitFresh.com). And because of this there occured duplicate records which means duplicate posts! which will be not be accepted by any user :) Here is the query to delete duplicate records in your table...
List Duplicate Rows:
SELECT Field,Count(*)
FROM TABLE
GROUP BY FIELD
HAVING ( COUNT(*) > 1 )
DELETE duplicate Rows:
General Syntax:
DELETE FROM TABLENAME WHERE POSTID in
(SELECT T1.POSTID
from TABLENAME T1, TABLENAME T2
where T1.DUPLICATEFIELD = T2. DUPLICATEFIELD
and T1. UNIQUEFIELD > T2.UNIQUEFIELD)
Example:
DELETE FROM TABLENAME WHERE POSTID in
(SELECT T1.POSTID
from TABLENAME T1, TABLENAME T2
where T1.TITLE = T2.TITLE
and T1.POSTID > T2.POSTID)
Hope It is Helpful :-)
Regards
Fauzi ~ 4Z