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