Make CtrlNumber a numeric value instead of a string.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*

----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 7:21 AM
Subject: [PHP-DB] order by problem


> Hello All,
>
> I´m having a 'problem' that I dont know how to resolve. The problem is:
>
> I have a table that I want to get the last number to increment. To do this
I
> want to sort the filed 'ctrlnumber'. Using this query´s I get:
> mysql> SELECT ctrlnumber FROM table WHERE id=14;
> +------------+
> | ctrlnumber |
> +------------+
> | 7          |
> | 1          |
> | 2          |
> | 3          |
> | 4          |
> | 5          |
> | 6          |
> | 8          |
> | 9          |
> | 10         |
> | 11         |
> +------------+
> 11 rows in set (0.00 sec)
>
> mysql> SELECT ctrlnumber FROM table WHERE id=14 order by ctrlnumber;
> +------------+
> | ctrlnumber |
> +------------+
> | 1          |
> | 10         |
> | 11         |
> | 2          |
> | 3          |
> | 4          |
> | 5          |
> | 6          |
> | 7          |
> | 8          |
> | 9          |
> +------------+
> 11 rows in set (0.01 sec)
>
>
> When I try to sort, it doesn´t return to me in the order that I need (1 2
3
> 4 5 6 7 8 9 10 11). Is there a way to do this or I´ll have to include 01
02
> 03 04 05.... to all my recoreds ?
>
> Thank´s in advance,
> Gus
>
>
> --
> 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

Reply via email to