Jeff wrote:
kwo isn't sorting properly... actually, I need to retest the lsd column too.
Can you answer the question we ask please? It's already been pointed out
to you several times that a CHARACTER column is going to sort in the
manner you found while an INTEGER column will not. So, you MUST b
gosto 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,
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 mig
Jeff wrote:
kwo VARCHAR(10) NOT NULL,
lsd VARCHAR(20) NOT NULL,
duh
--
---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:
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 t
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. .
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jeff wrote:
>
> > kwo VARCHAR(10) NOT NULL,
>
Jeff --
...and then Jeff said...
%
% One last question.
%
% I changed all the DB values where numbers are used - (varchar - int)
Well, you should only change for those where the numbers are numbers...
%
% But for the well locations, there are dashes in them, I.E. 10-15-065-22
Exactly.
%
You have to change
kwo VARCHAR(10) NOT NULL,
for
kwo int(10) NOT NULL,
Hope this helps
Fernando Soto
From: Jeff
Date: Viernes, 08 de Agosto de 2003 10:36:33 a.m.
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Sorting issue
Yes duh...
I didn't realize numbers we
Seems like changing the mixed fields back to VARCHAR worked!
Thanks again guys!
"David T-G" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
kwo isn't sorting properly... actually, I need to retest the lsd column too.
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jeff wrote:
>
> >$query = "SELECT kwo, lsd, date, event FROM $gradient_tablename
> > $order_by_str $sor
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
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 da
Jeff --
...and then Jeff said...
%
% Yes duh...
*grin*
%
% I didn't realize numbers weren't considered characters.
% What's the sql entry for numeric characters?
Integer looks like it will do the trick for you.
%
% I'm new at this, and figure I'm not doing to bad so far. .
I know what yo
Jeff wrote:
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
Jeff wrote:
$query = "SELECT kwo, lsd, date, event FROM $gradient_tablename
$order_by_str $sort_order_str $limit_str";
So what column is not sorting correctly? Is the column a INTEGER-type
column or a CHARACTER-type column...
Again:
"55" > "14000"
55 < 14000
=P Sure!
Heres the List Records section...
function list_records() {
global $default_dbname, $gradient_tablename;
global $default_sort_order, $default_order_by, $records_per_page;
global $sort_order, $order_by, $cur_page;
global $PHP_SELF;
$link_id = db_connect($default_dbname);
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
17 matches
Mail list logo