How do i copy SomeField of SomeTable data to...

[Aou_Student]

Hello friends,

Im asking, How can I copy SomeField of SomeTable data to AnotherField of AnotherTable?

Means Im searching for a code that Select data from someField and insert it into AnotherField!

I`ll be grateful if you help me.

Also I need a code that deals with the quotation mark as string (data) not a quotation mark! so It wont break the php code when it`s part of the data to be dealt with.

For Example: When I excute this code "INSERT INTO SomeTable `SomeField` VALUES ('Alen's Site');"

I get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Site');' at line 1.

The quotation mark in (Alen's Site) are dealt with as part of the php code NOT as part of the data to be inserted! I need to fix this some how.