Thank you all for the Tip ! It work´s fine now !! :)
Gus
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:32 AM
Subject: Re: [PHP-DB] order by problem
> On Wed, 20 Mar 2002 [E
On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote:
You have your ctrlnumber field defined as varchar. If you define
ctrlnumber as number, you could also use
SELECT max(ctrlnumber) FROM table WHERE id=14;
Cheers
Urosh
> Hello All,
>
> I´m having a 'problem' that I dont know how to resolve. The proble
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,
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;
++
| ctrlnum
Hi,
I use PHP 4.0.6 with iODBC and Apache 1.3.20 on a Linux System to connect a
MS SQL-Server Database on a Windows NT 4 System.
For example, the query "SELECT * FROM test" works successfully. But when I
try to add a ORDER BY clause in this statement like "SELECT * FROM test
ORDER BY name" the re