Any one Help me Please

#native_company# #native_desc#

#native_cta#

This site is best viewed in a modern browser with JavaScript enabled.

ckant

I'm new to PHP,

How to insert data into a table using foreign key!

ginerjm

If this is truly a foreign key then that is a pointer to somewhere else, so you are not accessing the record in the current table properly.

Perhaps you could explain better.

ckant

emp_table is table1, emp_settings is table2... table 1 having primary key...

by using that primary key i want to insert data in table 2

ginerjm

The only safe way to have that work is to have a one-to-one relationship between those two tables. AND if that is true, then why are they separate tables? It appears to me that your database is not fully normalized.

OTOH - you s/b using table 2's primary key to do updates to table 2. Period.

If, in the case that it is ok to do this, then it's simply a matter of reading t1, getting the fk from it and then updating t2. No? It's not a php problem, it's an logic problem.

ckant

that prob is belongs to not only these two tables....

in my database having 17 tables....!(attendance, vacation, shifts, schedules..etc...)
emp_id is foreign key for all tables...

by using emp_id only retrieve the data...

priyankagound

Try out with the below example:

insert into emp_settings (order no,fid)
values(1,(select id from emp_table where name='abc' LIMIT 1));

Hope this helps.

webdevs

You use MySQL INSERT and select syntax?

ckant

this code will work in only selected record only naaaa!

Milina

I think you need to go http://www.w3schools.com/php/

There is alots of tutorials and hope it will helpful to you.

Milina

priyankagound

yes, i have used both select and insert. I have used select query inside insert query for your selected records.This is because you have to use primary key to insert data in table 2 as you mentioned it before.

ckant

mysql_query($sql);

$sql = 'select last_insert_id() as lastId';
$result = mysql_query($sql);
while($row = @mysql_fetch_assoc($result)){

$lastId = $row['lastId'];

}

it is working.....