adding rows to another table where values are a variable

[blanktarget]

I have a listing that needs to added from a content management system. The add script is getting the row\'s id from the page before it

$id=$_GET[\'id\'];

 

what I want to do is have that number which exists in a table for temporary listings and move it (with the \'add\' script) into the permament \'listing\' table from the content management system.

$query="INSERT INTO listing (business, name, address, phone, website, email,) VALUES (\'business\',\'name\', \'address\', \'phone\', \'website\', \'email\',) FROM temp_listing WHERE temp_listing_id=\'$id\'"



$result=mysql_query($query);

[Guest Weirdan]

insert into listing (business, name, address, phone, website, email) select business, name, address, phone, website, email from  temp_listing where temp_listing_id=\'$id\'

?

[blanktarget]

Thanks. That worked well, I had to change \"\'$id\'\" to \' . $id \'