Im having a question regarding the possibility to update a row in mysql database WHERE the row to update = the row that holds a "projectname" in a label that i retrieve from another table .
What im trying here is to use the "projectname" as a sort of foreign key to all my other tables in the database. So that each update in another table is pointed to the row with the correct projectname.
Im familiar with the normal UPDATE WHERE command but i have no clue how to make is like "UPDATE WHERE Label1.text = projectname in the table"
Thx for your help.
What im trying here is to use the "projectname" as a sort of foreign key to all my other tables in the database. So that each update in another table is pointed to the row with the correct projectname.
Im familiar with the normal UPDATE WHERE command but i have no clue how to make is like "UPDATE WHERE Label1.text = projectname in the table"
Thx for your help.