Thank you all for the Tip ! It works 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 [EMAIL PROTECTED] wrote:
You have
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;
++
|
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
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,
Im having a 'problem' that I dont know how to resolve. The problem
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