Creating a custom ID

Dada78

Hello, In my DB the was feild in my tables is ID which is set to auto-increment. What I would like to do is instead of the DB just counting from 1 and adding from there on each entry is have my own custom id and have it count from there. For example TC001 then the next entry will be TC002 and so on. How would I go about getting doing this. Thanks in advance.

-Thanks

harmor

Just create a new field in the database called say, TCID

On the page that submits the data into the database do this

$getTCID= mysql_query("SELECT * FROM table_name WHERE TCID ORDER BY TCID DESC ")or die(mysql_error());
    $tc = mysql_fetch_array($getTCID);

$tc_result = $tc['TCID'] + 1;

$tc2= mysql_query("INSERT INTO table_name (TCID) VALUES ('$tc_result')");

What I am doing is getting the last TCID from the database and adding 1 to it.

If you are confused then post the contents of the page that inserts values into the database.

Dada78

Thanks for the reply, one quick question. How would the DB be set up, and also could it be like TC001 it would it just be TC1 and so on? Thanks in advance.

-Thanks

harmor

You have your ID field (the one that auto incremements and after that would be the "TCID" field

Run this in phpmyadmin

`TCID` int(30) NOT NULL default '0',

I'm don't think using TC001 will hurt, try it and see.

Dada78

Ok I inserted it into my test file but I don't think I have the DB set up correctly as it is still showing a number instead of the uniqe ID. Here is the php code.

<?
include("dbinfo.inc.php");

$first=$_POST['first'];
$last=$_POST['last'];
$phone=$_POST['phone'];
$mobile=$_POST['mobile'];
$fax=$_POST['fax'];
$email=$_POST['email'];
$web=$_POST['web'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')";
mysql_query($query);

$getTCID= mysql_query("SELECT * FROM contacts WHERE TCID ORDER BY TCID DESC ")or die(mysql_error());
    $tc = mysql_fetch_array($getTCID);

$tc_result = $tc['TCID'] + 1;

$tc2= mysql_query("INSERT INTO contacts (TCID) VALUES ('$tc_result')");  

{
echo "Thanks for your help while we continue to develop. Click the Home button in the up left corner to return back to the Home Page.";
} 
mysql_close();
?>

 `TCID` int(6) NOT NULL auto_increment,

Thanks for the help

Dada78

Ok I didn't see your last post before I posted my last one. I went and did what you said and redid the DB and it inserts a number in the TCID feild but not the TC and the beginning. Would it show it in the DB or just when you query it, like lets say in a search?

-Thanks

Dada78

This works but with a small problem. The TCID is enter on a new line by itself from the rest of the data entered. I think I just might use the regular ID and just html in TC in the page and have the number next to it. It would be nice to have just a feild in the DB that showed TC001, TC002, TC003, etc.