Need Urgent help!!!

cruthik

hi guys,
i'm busy making an order form for my site (canvas prints). the form like this:

<html>
<body>
<form action="" method="post" enctype="multipart/form-data" name="form1">

        <table>
        	<tr>
            	<td valign="top" colspan="4"><input onclick="disableupload();" name="cdrom" type="radio" value="2"/>Send your picture through post</td>
      		</tr>
      		<tr>
      			<td><textarea name="cddetails" rows="5" cols="25"></textarea> *</td>
        	</tr>
  		</table>
        <table>
            	<tr>
      				<td height="30" colspan="5" valign="top">
	  					<input name="cdrom" type="radio" onclick="disablecd();" value="1"/>Your picture online</td>

   			   </tr>
   				 <tr>
                 	<td width="35%" height="30" valign="middle">Size:
      				  <select name="size1">
						 <option value="10" >20x30 cm  &euro; 15,00</option>
           				 <option value="1" >40x40 cm  &euro; 30,00</option>
           				 <option value="2" >40x60 cm  &euro; 33,00</option>
						<option value="12" >40x80 cm  &euro; 49,00</option>
						<option value="7" >50x50 cm  &euro; 38,00</option>
						<option value="8" >50x70 cm  &euro; 45,00</option>
						<option value="13" >50x150 cm  &euro; 76,00</option>
            			<option value="3" >60x60 cm  &euro; 45,00</option>
            			<option value="4" >60x80 cm  &euro; 53,00</option>
           			    <option value="5" >80x80 cm  &euro; 64,00</option>
						<option value="9" >80x120 cm  &euro; 76,00</option>
						<option value="6" >100x150 cm  &euro; 129,00</option>
						<option value="11" >100x200 cm  &euro; 190,00</option>
        				</select></td>
      				<td width="35%" height="30" valign="middle">Effects:
       				 <select name="effects1">
            			<option value="1" >no effects</option>
           				 <option value="2" >black and white</option>
            			<option value="3" >sepia</option></select></td>
     				 <td width="17%" height="30" valign="middle">Quantity:
        			<input name="quantity" type="text" size="3" maxlength="5">
							  </td>
    				</tr>

    				<tr>
     					 <td width="3%" height="30" valign="middle">&nbsp;</td>
      						<td width="10%" height="30" valign="middle">&nbsp;</td>
     						 <td height="30" colspan="2" valign="middle">Your picture:
        						<input name="upload1" type="file">
							  </td>
                    </tr>
                    <tr>
                 	<td width="35%" height="30" valign="middle">Size:
      				  <select name="size2">
						 <option value="10" >20x30 cm  &euro; 15,00</option>
           				 <option value="1" >40x40 cm  &euro; 30,00</option>
           				 <option value="2" >40x60 cm  &euro; 33,00</option>
						<option value="12" >40x80 cm  &euro; 49,00</option>
						<option value="7" >50x50 cm  &euro; 38,00</option>
						<option value="8" >50x70 cm  &euro; 45,00</option>
						<option value="13" >50x150 cm  &euro; 76,00</option>
            			<option value="3" >60x60 cm  &euro; 45,00</option>
            			<option value="4" >60x80 cm  &euro; 53,00</option>
           			    <option value="5" >80x80 cm  &euro; 64,00</option>
						<option value="9" >80x120 cm  &euro; 76,00</option>
						<option value="6" >100x150 cm  &euro; 129,00</option>
						<option value="11" >100x200 cm  &euro; 190,00</option>
        				</select></td>
      				<td width="35%" height="30" valign="middle">Effects:
       				 <select name="effects2">
            			<option value="1" >no effects</option>
           				 <option value="2" >black and white</option>
            			<option value="3" >sepia</option></select></td>
     				 <td width="17%" height="30" valign="middle">Quantity:
        			<input name="quantity2" type="text" size="3" maxlength="5">
					</td>
    				</tr>
    				<tr>
     					 <td width="3%" height="30" valign="middle">&nbsp;</td>
      						<td width="10%" height="30" valign="middle">&nbsp;</td>
     						 <td height="30" colspan="2" valign="middle">Your picture:
        						<input name="upload2" type="file">
							  </td>
      						<td width="17%" height="30" valign="middle">&nbsp;</td>
    				</tr>
            </table>
        	<table>
            	<tbody>
                	<tr>
                    	<td colspan="2">
                        	<p class="style1"><strong>Billing adress</strong></p> 
                        </td>
                  </tr>
                    <tr>
                    	<td><label for="name">Name</label></td>
                        <td><input id="name" type="text" name="name" tabindex="2" value="" /> *</td>
                    </tr>
                    <tr>
                    	<td><label for="adres">Adress</label></td>
                        <td><input id="adres" type="text" name="adress" tabindex="3" value=""/> *</td>
                    </tr>
                    <tr>
                    	<td><label for="postal code">Postal code</label></td>
                        <td><input id="post_code" type="text" name="post_code" tabindex="4" value=""/> *</td>
                    </tr>
                    <tr>
                    	<td><label for="place">City</label></td>
                        <td><input id="place" type="text" name="place" tabindex="5" value="" /> *</td>
                    </tr>
                    <tr>
                    	<td><label for="country">Country</label></td>
                        <td><select id="country" name="country" size="1" tabindex="6">
                        <option value="Nederland">The Netherlands</option>
                        <option value="Duitsland">Germany</option>
                        <option value="Belgie">Belgium</option>
                        </select> *</td>
                    </tr>
                    <tr>
                    	<td><label for="telefon">Telefon</label></td>
                        <td><input id="telefon" type="text" name="telefon" tabindex="7" value=""/> *</td>
                    </tr>
                    <tr>
                    	<td><label for="mailadress">E-mail<br/>adress</label></td>
                        <td><input id="emailadress" type="text" name="email" tabindex="8" value=""/> *</td>
                    </tr>
                    <tr>
                    	<td><label for="description">Description</label></td>
                        <td><textarea id="desc" name="description" tabindex="10" rows="5"></textarea></textarea>
                    </tr>
                </tbody>
            </table>
        	<table>
            	<tbody>
                	<tr>
                   	  <td colspan="2">
                       	  <p><strong>Delivery adress</strong></p>
                      </td>
                    </tr>
                	<tr>
                    	<td colspan="2"><input type="checkbox" name="leveradres" onclick="disableleveradres();" value="3"/>Same as billing adress</td>
                    </tr>
                    <tr>
                    	<td><label for="d_name">Name</label></td>
                        <td><input type="text" id="d_naam" name="dnaam" tabindex="13" value=""/></td>
                    </tr>
                    <tr>
                    	<td><label for="d_adres">Adress</label></td>
                        <td><input id="d_adres" type="text" name="dadres" tabindex="14" value=""/></td>
                    </tr>
                    <tr>
                    	<td><label for="dpostcode">Postal code and Place</label></td>
                        <td><input type="text" id="d_postcode" name="dpostcode" tabindex="15" value="" size="4" maxlength="7"/>
                        <input type="text" id="d_place" name="dplace" tabindex="16" size="16" maxlength="50" value=""/></td>
                    </tr>
                    <tr>
                    	<td><label for="d_country">Country</label></td>
                        <td><select id="d_country" name="dcountry" size="1" tabindex="17">
                        <option value="Nederland">The Netherlands</option>
                        <option value="Duitsland">Germany</option>
                        <option value="Belgie">Belgium</option>
                        </select></td>    
                    </tr>
                    <tr>
                    	<td colspan="2" align="center">
                        	<p>
                            	<input type="submit" name="submit" value="Next"/>
                                <input type="reset" name="reset" value="Reset"/>
                            </p>
                        </td>
                    </tr>
                    <tr>
                    	<td colspan="2" align="center">
                        	<p><i>Field marked with * are required</i></p>
                        </td>
                    </tr>     
                </tbody>
            </table>
</form>     	  

</body>
</html>

the problem is that i'm new in coding php and mysql. i would like to store the form data in a database and i would like the form to be sent to my email adress.
can someone help me out please.

Piranha

That is quite a lot that you want us to do - and want us to do at once as well.

I suggest that you start by reading a few tutorials, about html, php, mysql, php and mysql, database normalization, sql injection in php. And test, test, test while you read those tutorials.

When you know the basics of all the above start by doing one of the above things, I suggest start by storing it in a database. When you have done that continue with the email sender (I don't understand why you want it, you have it in the database already, but that is up to you).

While you are learning and building it please don't hesitate to ask. But ask specific questions about code you have already coded, not "can someone do this for me" kind of questions. Show what you have, what result you want and what result you get and ask why it doesn't work the way you want. When you ask never ever say that it is urgent because it is considered trying to cut in line and won't be appreciated. Coming to think about it, you should read the stickies in the forums, especially in newbies forum.

cruthik

thnx for ur quick reaction. i do actually know something 'bout normalization, my sql and php but because this is the first time i'm tryin' to make such a form i tought i could get some help in here.

Piranha

No, you don't want to get help with this post. If you ment to get help you would say "I have this piece of code, and I expect it to work this way. But instead it works that way, I get this error message." As it is now you want us to do your job for you, and that is not help. That is just being lazy.