Re: [Phpwebsite-developers] PEAR DB and auto_increment

[Matthew M. <ma...@tu...>]

> The way I'm reading this.  You plan to derive your user id by selecting
> the current max id and incrementing it one?  If this is the case,
> wouldn't  you have a problem if multiple users happend to submit new
> user requests  simultaneously?

Not a problem. In fact I'm sure the PEAR solution requires the same process:
you just lock the table.

$core->sqlLock("myTable");
$core->sqlInsert($sql_array, "myTable", 1, "id_column", 1);
$core->sqlUnlock();

Sorry, forgot mention it.

Matt