 |  |  |  |  |  |  |  |
find primary key of post
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: May 2005
Posts: 232
Reputation: 
Solved Threads: 0
Posting Whiz in Training
Hey everyone, I wasn't sure if this should go in the php section or this one, so hopefully this is right, if not, move it for me.
I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information they submitted to the screen, so they can verify it is correct.
I would like to provide a link underneath the information for them to change some of it in case they provided bad info. But I don't know how to get the primary key value yet, because it was just submitted, and I don't have anything to reference it with yet.
The field that is the primary key is called "ID". So how do I get the ID number right after the post, when I don't have anything to reference it to?
I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information they submitted to the screen, so they can verify it is correct.
I would like to provide a link underneath the information for them to change some of it in case they provided bad info. But I don't know how to get the primary key value yet, because it was just submitted, and I don't have anything to reference it with yet.
The field that is the primary key is called "ID". So how do I get the ID number right after the post, when I don't have anything to reference it to?
•
•
Join Date: May 2005
Posts: 232
Reputation:
Solved Threads: 0
Posting Whiz in Training
Thanks, i'll give that a try.
|
Similar Threads
- Need Help Accessing a Primary key MS Access in SQL to print out informatio. (MS Access and FileMaker Pro)
- HELP! Need someone that Knows SQL to tell Me How to Access a Primary Key (C)
- Need to make program access a data base primary key number entered by user (C)
- Primary Key Issue (Visual Basic 4 / 5 / 6)
Other Threads in the MySQL Forum
- Previous Thread: Using Databases
- Next Thread: online tutorial
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
