Re: Sorting issue

["Jeff" <jroth1@telus.net>]

The MySQL script I made,

CREATE TABLE cnrl_db (
gradient MEDIUMINT(10) NOT NULL AUTO_INCREMENT,
kwo VARCHAR(10) NOT NULL,
lsd VARCHAR(20) NOT NULL,
date DATE DEFAULT '0000-00-00' NOT NULL,
well VARCHAR(50) NOT NULL,
field VARCHAR(25) NOT NULL,
uni VARCHAR(30) NOT NULL,
license VARCHAR(10) BINARY NOT NULL,
formation VARCHAR(20) NOT NULL,
perfs VARCHAR(20) NOT NULL,
event VARCHAR(1) NOT NULL,
fluid VARCHAR(2) NOT NULL,
mode VARCHAR(2) NOT NULL,
type VARCHAR(2) NOT NULL,
vhd VARCHAR(10) NOT NULL,
file VARCHAR(15) NOT NULL,
kb VARCHAR(6) NOT NULL,
grd VARCHAR(10) NOT NULL,
open VARCHAR(1) NOT NULL,
sour  VARCHAR(1) NOT NULL,
tube VARCHAR(10) NOT NULL,
landed VARCHAR(6) NOT NULL,
casing  VARCHAR(6) NOT NULL,
landed2 VARCHAR(6) NOT NULL,
shut_date VARCHAR(10) NOT NULL,
shut_time VARCHAR(10) NOT NULL NOT NULL,
pres VARCHAR(15) NOT NULL,
tag VARCHAR(15) NOT NULL,
PRIMARY KEY (gradient)
);
  "Fernando Soto" <fsoto@ocaso.com.mx> wrote in message 3F33CE1E.000001.01768@fsoto1">news:3F33CE1E.000001.01768@fsoto1...
        This would happens if you have defined the data type of the columns as char or varchar.


        -------Original Message-------

        From: Aaron Wolski
        Date: Viernes, 08 de Agosto de 2003 08:51:04 a.m.
        To: 'Jeff'; php-db@lists.php.net
        Subject: RE:  Sorting issue

        Seeing code might help us.

        Aaron

        > -----Original Message-----
        > From: Jeff [mailto:jroth1@telus.net]
        > Sent: August 8, 2003 10:44 AM
        > To: php-db@lists.php.net
        > Subject:  Sorting issue
        >
        > Why would a mysql db think that 55 was greater than 14000.
        >
        > I have several headings that display sql data under them, when you
        click
        > on
        > the heading, it sorts that section (descending/ascending), but it only
        > seems
        > to be looking at the first two numbers in the one heading. Is there
        a
        > command that forces it to look at the entire record before sorting it?
        >
        > Thanks
        > Jeff
        >
        >
        >
        > --
        > PHP Database Mailing List (http://www.php.net/)
        > To unsubscribe, visit: http://www.php.net/unsub.php




        --
        PHP Database Mailing List (http://www.php.net/)
        To unsubscribe, visit: http://www.php.net/unsub.php


        . 
               
       
  ____________________________________________________
    IncrediMail - Email has finally evolved - Click Here