MySQL insert combo from php var and other table

Question

i am trying to insert into my sql table a combination of php variables and 1 row data from another table. ive found examples that are similar but none that have this combination.

OTHERTABLE.liveDate would be where i need the single record from, but i would need to add a condition such as WHERE id='1' from OTHERTABLE

'$navid', '$loginid', '$total', '$where' are not from OTHERTABLE

INSERT INTO myTable (`navid`,`loginid`, `pageDisplayNum`, `whereFrom`, `liveDate`) 
VALUES ('$navid', '$loginid', '$total', '$where', 'OTHERTABLE.liveDate')

Gratzy · Accepted Answer · 2012-05-08 23:40:30Z

2

INSERT INTO myTable (`navid`,`loginid`, `pageDisplayNum`, `whereFrom`, `liveDate`) 
select '$navid', '$loginid', '$total', '$where', OTHERTABLE.liveDate 
from OTHERTABLE
where OTHERTABLE.id='1'

answered May 8, 2012 at 23:40

Gratzy

9,4174 gold badges32 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yamiko Over a year ago

+1 I did not know you can do this. I always inserted a foreign key. What are the pro/cons of the answer vs using a foreign key?

s_p Over a year ago

thank you for the response, i've edited my question. '$navid', '$loginid', '$total', '$where' are not from OTHERTABLE

Collectives™ on Stack Overflow

MySQL insert combo from php var and other table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related