str_pad("12", 5, '0', STR_PAD_LEFT);
result 00012
Mega menu
like http://www.argos.co.uk/static/Home.htm or http://www.econker.com/?new=1
mega-menu
date search for day month year in a timestamp or datetime field
// for datetime field like 2001-12-03 select * from user where month(date_of_birth) = 2 // for datetime field like 978363171 select * from user WHERE MONTH(FROM_UNIXTIME(date_of_birth)) = MONTH(CURDATE()) AND DAY(FROM_UNIXTIME(date_of_birth)) = DAY(CURDATE()) AND date_of_birth !=0