MySQL - customer input form to data table specifics

[tom]

Hi folks. I'm new to MySQL. I would like to know
how to create a customer input form with the
fields 'dumping' into mMySQL data tables. I have
MySQL enabled, and have uploaded some crude
tables.

My customer input form (html?) will include;

name
address
CHOICE of picture frame
CHOICE of picture size
email address
etc.

Can someone assist?

tom

[Greg]

Here is a form that has all five fields in it. You will have to write up a code to send all these information into a database. Do you need help with that as well ?

-------------------------------------------- FORM-----------------------------

<form name="userform" method="post" action="your_filename.php">
<table width="450" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="120" valign="top">Name:</td>
<td width="322">
<input type="text" name="name" size="40">
</td>
</tr>
<tr>
<td width="120" valign="top">Address:</td>
<td width="322">
<textarea name="address" cols="40" rows="4"></textarea>
</td>
</tr>
<tr>
<td width="120" valign="top">Picture size:</td>
<td width="322">
<input type="text" name="pic_size" size="40">
</td>
</tr>
<tr>
<td width="120" valign="top">Picture frame</td>
<td width="322">
<input type="text" name="pic_frame" size="40">
</td>
</tr>
<tr>
<td width="120" valign="top">E-mail:</td>
<td width="322">
<input type="text" name="e_mail" size="40">
</td>
</tr>
<tr>
<td width="120">&nbsp;</td>
<td width="322">
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Reset">
</td>
</tr>
</table>
</form>
------------------------------------END OF FORM-----------------------------

Hope this was of some help.

Greg

[tom]

thanks for responding!

Actually I have been working with forms for a number of years, but am VERY new to database
interaction.

I meant to ask how to get data from and send data back to MySQL using an html form.

In another thread, one of our fellow PowWeb members suggested that I pick-up PHP Essentials, which I have ordered.

Although I have been 'doing' business on the net since 1996, I still find attacking 'new' (to me) web based interactive programming LOADS of fun.

I am NOT a code dude, but I have struggeled through over the years and gotten by.

Thanks AGAIN for your assistance - I'm certain I could use some more of your help once I have a stronger foundation.

The reason for my delayed response was that I have JUST moved and have been off-line for nearly a week.

regards,

tom