i need a script that:
1) put/edit/delete fields into database, the fieldnames are:
tablename: person
fields : name,surname,phone,fax,email,group,zip_code,client_firstletter,subject
possible values:
name,surname,phone,fax,email is up to you.... varchar makes sense...
the rest:
------------
group (int 1-10),
zip-code (int 6 digits),
client first letter (A-Z),
subject (int 1-10)
this is SPECIAL, i have to setup 3 ranges of zip-code, e.g. 10001-11000, 12000-13000, 98000-99999
maybe you can realize this with a seperate table? this is up to you!
so every person will have up to 3 ranges to setup.
then i need a frontend to search for these persons, i have to put in:
group selection
a zip code
my first letter of name
subject
so maybe i type in:
Group: 2
Zip: 25445
Letter: B
Subject: 8
and the script will give me the result of persons that match my request.
shouldn't be to much work for someone who knows php and mysql.
i need this ASAP... it must NOT win a design challenege, i need it without layout, pure plain html is ok without css or something, i'll do this by myself.
the php should be nice coded, QUESTIONS? ask, please.
thank you
Andreas
P.s.: Remember, the backend and frontend needs no layout, put it into html tables etc. what you want but it should work! i'll pay the money if it's working (you can show it online to me).
Hello,
10+ years exp freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.