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