[SOLVED] How do you read the autonumber before the insert

[adi5402]

I have a table with a primary field called IDX

 

its set on auto_increment.

 

My form takes a client Code For example CL1 and generates an invoice number in this table.

 

The table will have the 3 fileds

 

1.IDX

2.InvoiceNo

3.Client

 

 

Now how do i insert something so that i can generate an automatic IDX Say Number 50 and then insert the same number in the InvoiceNo with the heading as the client ID in the same Squ script.

 

So my values will be like this

 

1 IDX = 50

2 InvoiceNo = CL50

3. client = CL

 

i hope this makes sense its a very hard question to explain.

 

 

 

[adi5402]

I worked a way around this

 

i picked up the last id using  a simple sql like the example below

 

$sql = 'SELECT * FROM `products` ORDER BY `products`.`book_Id` DESC LIMIT 1';

 

then just added 1 to it to create the next one.

[PFMaBiSmAd]

When you have concurrent visitors inserting rows, a query like that can return the wrong value.

 

You need to use the mysql_insert_id() function to insure you get the value for the current client connection - http://www.php.net/manual/en/function.mysql-insert-id.php