One last question. I changed all the DB values where numbers are used - (varchar - int)
But for the well locations, there are dashes in them, I.E. 10-15-065-22 With setting the field to int, it only displays the first part. 10-15-065-22 shows as 10 There are also several other fields that use dashes. If I set it back to varchar, will it sort it right because the numbers are separated by an alfa character, or will I have the same problem as before? "Jeff" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thank you EVERYONE.. AGIAN! *grin* > > > > "John W. Holmes" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Jeff wrote: > > > > > Yes duh... > > > > > > I didn't realize numbers weren't considered characters. > > > What's the sql entry for numeric characters? > > > > > > I'm new at this, and figure I'm not doing to bad so far. . > > > > Make them an INT column. It'll hold numbers up to 2 billion+. Or you can > > use TINYINT which will hold numbers up to 255. Read the MySQL docs for > > more column types... > > > > kwo INT NOT NULL, > > lsd INT NOT NULL, > > > > -- > > ---John Holmes... > > > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > > > PHP|Architect: A magazine for PHP Professionals - www.phparch.com > > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
