BuddyRevell
New Member
I have a mysql database which I support using phpMyAdmin.The website this is for is a classifieds website.The issue here is that whenever a new classified is posted (and inserted into mysql database), I need to first review it manually.My question is, is there anyway to tell mysql that "this record is inactive, so don't return it"?I know of one way offcourse, to add a column named "state" and change it to "active" for all classifieds which I want active. But is there any other method built into mysql which does the same?In other words, I dont want the record returned when users search the website if the record isn't "reviewed" first by me.EDIT: I know of the WHERE clause, that is not my Q here. Is there any other method built into phpMyAdmin?Thanks