Database and PHP

[phpblues7]

I have two tables one with minfo and other is user both have u_id .

i want to access that id in minfo so that it updates with information by that id of user in that data.

somehow  u_id becomes primary of second table and primary of 1st table.

how should i update the value of u_id in second table any help will be appreacited.

 

[gizmola]

Please execute a "show create table user" and "show create table minfo" and post the results here so we can see what you are talking about.

1 hour ago, phpblues7 said:

somehow  u_id becomes primary of second table and primary of 1st table.

how should i update the value of u_id in second table any help will be appreacited.

You want to update user or minfo?  What column(s) do you want to update?

You can update a table utilizing a join to another table for the purposes of update.  For example: 

 

UPDATE user
JOIN minfo ON minfo.u_uid = user.u_id
SET user.some_thing = minfo.some_thing