Farhad
|
Posted: 01/04/2005, 12:35 PM |
|
Hi,
I have a form which adds clients' details to a table. How can I identify
the record which has been inserted.
I do not want to have a Login form in order to identify the Clients.
However, the Client_ID is an Autoincrement field.
I would appreciate any suggestions.
Farhad
|
|
|
peterr
Posts: 5971
|
Posted: 01/04/2005, 12:54 PM |
|
Your database may have a function to retrieve the last inserted key.
Also see http://forums.codecharge.com/search.php?s_keyword=last+...[]=25&s_period=
And the "Multi-Step User Registration" example shows how to do this using generic method.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Farhad
|
Posted: 01/04/2005, 1:15 PM |
|
Thanks Peter.
I am using MySql and php.
The function is mysql_insert_id()
However, since I have purchased php License, CCS does not allow me to see the projects in ASP, etc.
I really need the php coding of all these examples. Examples have been extremely useful for me.
Thanks again.
|
|
|
peterr
Posts: 5971
|
Posted: 01/04/2005, 1:41 PM |
|
With MySQL you should be able to use that function directly in PHP, take a look at http://forums.codecharge.com/posts.php?post_id=46012
As for the examples, they are provided in all programming languages. So you just need to select the programming language when creating new project(s) based on examples.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Farhad
|
Posted: 01/04/2005, 1:54 PM |
|
Thanks Peter.
You have been very helpful. You have saved me a lot of time.
Thanks Again.
|
|
|