Jump to content

Archived

This topic is now archived and is closed to further replies.

blanktarget

adding rows to another table where values are a variable

Recommended Posts

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);

Share this post


Link to post
Share on other sites
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\'

?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.