hey,I am a newbie learner,this might sound a stupid question but yes,what datatype to choose for data format.
I googled it,but disappointed to get no answer,usually the date datatype ranges from 0001-01-01 through 9999-12-31,and it is in numeric form,
in my contact form,I have a jquery datepicker,when user selects the date,the value displayed on the textbox is like this "March 13th, 2013" ,I am wondering what datatype to use.
and for time,in the format "14:20" what datatype to use?
<div class="field submit">
<input type="submit" value="Submit"/>
For better view,I posted it on pastebin:
These form script was taken from some site,I just modified it,it usually emails the contents,but I want all these form details to save on a database.
please help me with this.
I want the whole database query code which is to be run to make tables and fields for the name,address etc.
and the php code ,the database.php code which will make it possible to save data on the db.
Thanks a ton,please help me.
If there is a website offering some GUI service or any other way to generate the MySQL code easily,please do post,and suggest any good website or free eBook by which I could learn MySQL.