Re: Reference Numbers! Count Upwords !!!
| From: | Andrey Hristov | Date: | Tue, 09 Oct 2001 14:05:45 +0000 |
| Subject: | Re: Reference Numbers! Count Upwords !!! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70480@lists.php.net to get a copy of this message | ||
Using Postgresql write a trigger. Triggers are not supported by mysql.
--
Andrey Hristov
Web Developer
IcyGEN Corporation
BALANCED SOLUTIONS
http://www.icygen.com
On Tuesday 09 October 2001 16:52, you wrote:
> Hi
> I need some help on creating a ref number!
> Lets say my first reference record in the database is 00001!
>
> Now i've got to create a function which everytime the user clicks on add
> 00001 must count to 00002 and 00003 and so on
> and when it gets to 00009 it must switch to 0000A then 0000B !!!
> Now the same with when it gets to 0000Z it must swith to 00010 then 00011
> and when it gets to 00019 it must go to 0001A and so on !
> Can anyone help me here i need to do this !
> Thanks ALOT
> Coenraad Steenkamp