How to create forms - Mysql n PHP

mrzuna · #1 (**permalink**) 11-16-07, 08:57 AM

Hello there,

First im a newbie

I have a question how to made forms that will contain 44 diferent pages with the same form fo 44 diferent shops:
form needs to look like this

date,
calls visits
11:00 13:00 15:00 17:00 19:00 SUM 11:00 13:00 15:00 17:00 19:00 SUM

that would be a form that will have every shop
after that i need to create report from 44 shops that have entered all data,

looks simple but complicated for me

, but im learning mysql and PHP and this is my first work

Im working 4 days, and after i finished base, it all crashed

HELP PLEASE

Regardssssssss........

fahadp · #2 (**permalink**) 11-19-07, 12:17 AM

Design a table that holds an addiotion field to store shop name or domain etc.
If 44 shops are running on 44 different URLS then following can be a solution

Design a single form and keep a hidden field in the form that will hold identification of shop. i.e. shop1, shop2 etc

Quote:

<html>
<form>
.........
<input type="hidden" name="FIELDNMAE" value"shop1" />
.........
</html

You can store the data from different shops into single table and then can easily generate reports based on that.