Concatenate UserName with RecordID using mysql_insert_id() during Insert
I really need some help with this, please. I am new to php and have been trying on my own for six weeks and just can’t seem to get this working. It is very important for me to get this feature working.
In my member_Registration.php page I need to insert in to the MySQL tbl_members a concat value of kidSID.mysql_insert_id() into the kidNickname field. The kidSID is the unique incremented record field.
Someone suggested putting an update command right after the insert. I have rem’d the test code out in attached. It did not work. And from another post in the forum, I read that it would be important to perform the update before the redirect. That makes since as the user session with the table would still be connected. I have tried setting up both an insert and an update with DataAssist for the same page but have not found that successful.
The closest I have come is to edit line 75 which inserts into the kidNickname field:
GetSQLValueString($_POST['kidFirstName'].mysql_insert_id(), "text"),
The result in the table for example is: Tom0. The value for the record kidSID is not being identified and is simply appended as a zero. This also disabled the Server Behaviors “Check New Username.