It seems that I did forget to update the recordset to display only the records with the published value :o
Thanks for all your help Jason. I've now got a really good admin system working and have gone on to customise it further. A few small issues but I'll see if I can fix them. May need a few pointers along the way but thanks for now.
One thing I would really like to do is to be able to customise how the data is displayed in the table. The binding for Published status gives a value of 1 or 0 using <?php echo $row_rsAllOffers['PublishedStatus']; ?>. How would I be able to display this as Published (ie. value 1)or Draft (ie. value 0) rather than the numeric values???