Get ID number problem

[angor]

The problem is that while inserting the sting i need to know 3 more free (not in use yet ID)

exaple

  name       ID1 ID2 ID3
1 Bil         2   3   1  
2 Bob         0   0   0
3 Michael     0   0   0
5 John        0   0   0
6 Lili        7   9   11
..........................

I'm sending 3 rows simultaneously
Bil 2 3 1
Bob 0 0 0
Michael 0 0 0

How could I know the IDs beforesending to database

Thank you in advance

 

[hneal98]

You would have to search the database first. So, you would have to do one query to search the database and then another to create the id based on what you found.

This is a simplified explanation.