Big thank you to David Reynolds and MJ Ray for their help.
I've got the script working. It was the insert syntax that I had wrong.
I also need to add slashes before each field is inserted and the only way I could do it with my limited PHP/MySQL knowledge is by adding slashes to each field:
$title = addslashes($result[title]); $description = addslashes($result[description]); $contact = addslashes($result[contact]); $url = addslashes($result[url]); $email = addslashes($result[email]);
mysql_query("INSERT INTO $table2 (title,description,contact,url,email) VALUES('$title','$description','$contact','$url','$email')"); }
I'm sure there is an easier way to do it but it works!
Just need to tidy the syntax up a bit and be more specific about which resource is connected to.
It's kept me out of trouble for the past three days :-)