Hey, Could anyone help me with a problem? i need a system there by, a customer may fill in a form on my website,( text and multiple images), which when submitted will be stored in a database WITH my approval, which then can be searched by presset search terms and displayed on my website with a layout of my choice, the search fields will be in the form which the customer fills in, so the info will be in the database. Also they must be able to edit this info once submitted. when a visitor searches on my site the results that come up will have to be randomised, ie there will be lots of the same info being submitted. there are other small points that will need to be included, please get in touch if you can help. Thanks in advance for any help.
It shouldn't be so bad... sounds similar to a real estate site that I'm working on... Create the form upload to store the information with a setting say '0', unapproved, compared to '1', approved. Create a search page that will allow you to see all settings regardless of approval or just approvals of '0', that will allow you to 'approve' and update your database with the new approval rating. Create the public search to only return results with an approval of '1'. I'm not sure how to randomize the search return, but that should be possible, otherwise return by newest first or some order that you choose. To allow the user to edit, create a membership area in which they have to log into their record, cookies can be quicker. Populate the edit form with their currently uploaded data and allow them to change accordingly. At this point you can choose to reapprove the edits by setting approve back to '0', or let the edits fly. Another way around creating more work for yourself here is to create a trust system if possible. This way when trusted contributors add information, it can be immediately approved with out your having to overlook each entry. Hope that this helps, Starke