423,323 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,323 IT Pros & Developers. It's quick & easy.

I want to select data from one table and want to insert it into another table with ne

P: 1
I want to select data from one table and want to insert it into another table with new values.Please help me .
$query = 'INSERT INTO opportunities VALUES(id, fname, lname, email, contact, vertical, location, global ,(SELECT fname,

lname, email, contact) FROM register WHERE id = $id';
$sql = mysql_query($query);
Please check this query and if it is wrong then send the correct query.
May 17 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.