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
> 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