I was looking through the forums and did not see anything that will get me started, so here I am.
3 jobs each client
100 html files containing image mapping (map name, href, shape, & coords)
What I would like to do is have php parse the data from the image mapped pages into a database.
I have a database structure like so:
JID --Auto increment
name -- client name
JOB_ID -- auto increment
JID -- identify client
name -- name of job
MID -- Auto increment
JID -- to identify client
JOB_ID -- identify job name
map_name -- pulled from each map.html | there can be more than
shape -- pulled from each map.html |-- one entry for each html
coords -- pulled from each map.html | and some may have none
Am I on the correct path? This is the first big project I have had to do and I know that more than anything your database needs to be setup properly from the beginning.
If any further information is needed, please let me know.