another gotcha with auto increment fields - you can`t combine contents of two tables, each with their own auto incrementing fields which dis-allow duplicates - oughta be a law against them.
do a query for the largest (max() function ) in an integer field, add one and then INSERT new value. store the short varchar "rur" in another field. Concat them when presenting to the user. Split them when the user posts a request. See also str_pad function ----- Original Message ----- From: "Ignatius Reilly" <[EMAIL PROTECTED]> To: "Win32 list PHP" <[EMAIL PROTECTED]>; "Pat Johnston" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 11:12 PM Subject: Re: [PHP-WIN] auto increment > You can not do it straightforwardly. The required data type does not exist > in MySQL. An auto_increment field is of type INTEGER. > > Ignatius > ____________________________________________ > ----- Original Message ----- > From: "Pat Johnston" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, December 05, 2002 12:35 PM > Subject: [PHP-WIN] auto increment > > > > Hi > > With php, just wondering if anyone knows if I can auto increment a number > > that has a part string? Is it possible to code this for an ID in MySQL > > database? > > > > ie > > rur01 > > rur02 > > rur03 > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
