I been asked to design a database and Im not sure what datatype to use for a price field and a date field.
Should the price by a int, float or a currency. (If currency how *** u process it with PHP?)
For a date should I be using a unix timestamp and storing it as int(10) or should I be using the DATETIME MySQL datatype? (Again how would I process it via PHP?)
Also a user can sign up to the site, whats the best datatype to use for an md5 encryption? char(32)?
Thx
JD
Should the price by a int, float or a currency. (If currency how *** u process it with PHP?)
For a date should I be using a unix timestamp and storing it as int(10) or should I be using the DATETIME MySQL datatype? (Again how would I process it via PHP?)
Also a user can sign up to the site, whats the best datatype to use for an md5 encryption? char(32)?
Thx
JD