i need a small mysl /php project done quickly. Bonus if done within 48 hours. payment through GAF escrow.
a mysql database of 5 fields: id (number), text1, text2, number3, number4.
id to increase sequentially as entries are added.
text: both long text fields.
number1: number between 1 AND 20
number2: as 1 or 0
two functions on this page:
take a random value from db ID AND number2 = 1 AND number1= 1 or 2 or 3 or 4 or 5... or 10 (must be done as a list like this). and return value of text1 and text2 to page to be displayed on page on if num
form box to allow adding text1 and text2 to DB
Error checking, must have length checking between 5 and 150 characters and keyword filter (do five words as example). Change all text to lower casese and remove non alpha or numerical numbers (a-z, 1-9 ok).
Check button box text values 1-10 (so that if text1 is selected 1 is placed in DB for value number1, if text5 is selected 5 is placed in number1
php page 2:
Allow me simpe access to see entries in DB and ability to edit any value and to set the value of number2 quickly to 1 or 0
any questions please ask in project questions/clarification.