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.