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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
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'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Sorting issue
Seeing code might help us.
Aaron
> -----Original Message-----
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: August 8, 2003 10:44 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] 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
