Set autoincrement value for each value in row -- php

[eluser]obiron2[/eluser]
I think his database table has a compound primary key of Row1/Row2 (bad field labelling!)
Think of them as OrderNumber/LineNumber

When you add a record to the database for a particular order number the line number should be one higher that the highest line number on that order.

To do this you will have to poll the database

$query = "SELECT max(lineno) as 'LineNo' from myTable where orderref = $orderRef"

$qUpdate "INSERT INTO myTable (OrderRef,LineNo) VALUES ($orderRef,($query->row()->lineno+1))"

You run the risk of concurrency issues if more than one browser window could update the order at the same time so you would need to look at some sort of record locking or pre-creating the row and then updating it.