datasheet type web form
| From: | Lez Lytollis | Date: | Fri, 21 Jul 2000 15:05:33 +0000 |
| Subject: | datasheet type web form | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1401@lists.php.net to get a copy of this message | ||
Hi All,
I am trying to design a web-based data-entry form that resembles the
datasheet/grid entry of Access et al., for clothing sizes
e.g
8 10 12 14
Bust 32 34 36 38
Waist 24 26 28 30
Hip 34 36 38 40
If the table is normalised in the form:
sizechart{id, measurement_desc, size, measurement_value}, how do I enter the
data? Do I need a loop or can I use one INSERT statement to insert mutiple
records?
i.e I would want the form to save records:
1,Bust, 8, 32
2,Bust, 10,34
3,Bust, 12, 36
4,Bust, 14, 38
5,Waist, 8, 24
etc.,
TIA,
Lez