keeping a 0 in front of a random integer

WeberForums.com Forum Index -> MySQL General

View previous topic :: View next topic   Author Message remyx187 Joined: 22 Apr 2008 Posts: 1 Posted: Tue Apr 22, 2008 3:39 pm    Post subject: keeping a 0 in front of a random integer Hi, I have a minor problem with keeping the 0 in front of an integer whenever i insert it into a field. i.e. inserting a number such 0123 would be stored as 123 in INT datatype field. how would i get around to keeping the 0 because its crucial in the work i'm doing. thanks in advance Back to top lostboy Joined: 02 May 2004 Posts: 4966 Location: toronto, canada Posted: Tue Apr 22, 2008 7:24 pm    Post subject: 1. make the field a character field (char or varchar) and understand that its a string now 2. handle it in the php code before displaying _________________ Lostboy Cat, the other other white meat Please read Posting Etiquette before posting You can always try Google Back to top mwasif Joined: 22 Mar 2008 Posts: 22 Posted: Sun Apr 27, 2008 11:09 am    Post subject: you need to make the column ZEROFILL. Code: ALTER TABLE table_name CHANGE column_name column_name INT( 11 ) UNSIGNED ZEROFILL NOT NULL _________________ PHP, MySQL, Apache Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

WeberTrivia Questions   Think you are smart? Prove it!. Try your skills with these questions :   Recursive arrays and multi-dimensional arrays are one and the same. (PHP and MySQL)   The \"cache_dir\" tag of the squid configuration has a default of /var/spool/squid. (Linux) PHP Code Examples   Stream diffrent sizes of images from a single image to save disk space.   JavaScript dropdown list menu to switch any page.   Dump the contents of a PHP variable in html format with a recursive list of subfolders and files from a given root directory.   PHP Dump in html format the contents of one array variable with a recursive list of the nested array variables inside.   Link Extractor - This function is used to extract links from a given URL. This will convert relative path into absolute path and also remove PHPSESSID stuff.   Building a Dynamic Form using Javascript and innerHTML. Add form elements in realtime without refreshing the page.   A PHP Calendar function with CSS : add a cool calendar to any php page by just adding a calendar class based function.

	WeberForums.com Forum Index -> MySQL General	All times are GMT + 2 Hours
Page 1 of 1

Jump to: Select a forum PHP Forums----------------PHP GeneralPHP MySQL Jobs and ProjectsPHP Articles Tutorials and ScriptsWhy Use PHPPEARPHP Books MySQL Forums----------------MySQL General Apache Forums----------------Apache General Web Development Forums----------------Java Script / AJAXSearch Engine Optimization (SEO)Cascading Style SheetsHTMLXML & XSL Graphics & Design----------------Theory related web designWeb Design Security Forums----------------Security Linux Forums----------------Linux General Web Development Misc----------------Hosting Related Miscellaneous----------------Feedback & TestimonialsMisc  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum