Auto_increment

MBK

Help me!

I need to create a script that will auto_increment a field in a mysql database. I know I can do it by using the auto_increment function in mysql, but I need to prefix the number with characters.

i.e, instead of just 0123 I need mbk0123.

I think I will be able to do it using a loop that increments, but can't remember from my c++ days how to do it, or if the syntax will be the same,

Anyone got any ideas pls? 🙂

yelvington

Bad idea. Why do you think you need to do it that way? If you need to prefix an object id with a constant string, do it EXTERNAL to the database. Use the auto_increment data type the way it was designed; it has safeguards built into it.

Bunkermaster

looks like you want to add a string and pad the number to a known length string...
can the sequence have holes in numbers or is it a problem?

MBK

Can have holes in numbers,
There are going to be three maybe four types of users gaining access to my site, I want to base their access rights on this number/code.

I was going to do it using a prefix, MBK, MBKA etc with each gaining different access rights.

How can I do this using simple increments?

MBK

Can anyone help me on this one, or offer an alternative pls?

Bunkermaster

why don't you store user priviledges groups in a database and assign a group to your users? or maybe I didn't understand what you wanna do...

MBK

Yeah that is what I mean, how would I go about doing what u suggested.

Basically there will be three maybe four levels of users accessing my site, each one will have different access rights to certain pages.

How best to implement this?

Bunkermaster

store features list in DB with minimum user level. then when a user connects, check his rights and display the relevent features

MBK

I understand what u are saying in principal, but how would I translate this into code?

What code would I need, I am picking bits of this up, understand what u mean, but could u please help with the code?

Bunkermaster

¬_¬

not right now... busy building templates...

bastien

in table users

userid
username
userpassword
useraccesslevel
etc

when the uesr logs in, store the useraccesslevel in a session...

then on each page where the user has access

i($useraccess==1){
//code to allow access to these functions/pages
//or redirect to other page
}elseif($useraccess==2){
//code to allow other functions/pages
//or redirect to other page
}elseif($useraccess==3){
//code to allow other functions/pages
//or redirect to other page
}elseif($useraccess==4){
//code to allow other functions/pages
//or redirect to other page
}

or simple redirect the user to one specific page where all the functions that access level has are located...there are many different ways to make this happen...all use the same basics as decribed in these posts

hth

MytchE

If you're desperate..just create a varchar(20) field and create a PHP function to generate the next auto number for you and insert it, like this:

INSERT INTO myTable(theId, myName) VALUES(GetNextValue(), 'Mitchell')