double check function before being published to web
Posted: Sat Dec 26, 2009 10:28 am
Hello everyone,
I'm designing a website for a porcelain tile wholesaler. I would like the information on the site to be easily updated (through forms by non-web designer employees) and then double checked by a manager before being published to the eyes of the public.
My first thought was to have a field for all series/items/pictures/etc for a numeric code of 1 for unapproved and 2 for approved. Then have the recordsets run a querry for results with a #2. It would be the easiest to make but I'm thinking it may use up too much resources.
My second thought was 2 sets of tables, one for public eyes, and one a duplicate system of tables that is for non-approved series/items/pictures/etc. However, wouldn't i then have to combine 2 tables into a single report querry? Is that possible?
My monthly traffic isn't very high at the moment but I'm wanting to obviously increase the traffic dramatically. I'm doing my bulk of my programing with Dreamweaver CS3. I've read a PHP and MySQL book by Larry Ullman which laid out what knowledge I have of the programing language. Well... that book and w3schools.
What method would you use?
Any opinions of 110mb for a hosting server?
Can you tell I'm still wet behind the ears?
Thanks
TileGuy
I'm designing a website for a porcelain tile wholesaler. I would like the information on the site to be easily updated (through forms by non-web designer employees) and then double checked by a manager before being published to the eyes of the public.
My first thought was to have a field for all series/items/pictures/etc for a numeric code of 1 for unapproved and 2 for approved. Then have the recordsets run a querry for results with a #2. It would be the easiest to make but I'm thinking it may use up too much resources.
My second thought was 2 sets of tables, one for public eyes, and one a duplicate system of tables that is for non-approved series/items/pictures/etc. However, wouldn't i then have to combine 2 tables into a single report querry? Is that possible?
My monthly traffic isn't very high at the moment but I'm wanting to obviously increase the traffic dramatically. I'm doing my bulk of my programing with Dreamweaver CS3. I've read a PHP and MySQL book by Larry Ullman which laid out what knowledge I have of the programing language. Well... that book and w3schools.
What method would you use?
Any opinions of 110mb for a hosting server?
Can you tell I'm still wet behind the ears?
Thanks
TileGuy