how to copy table to another database[PHP]

[slackman]

i use this query on mysql console it's working.

CREATE TABLE backup.backup_table SELECT * FROM data_orig.user


and i use on php not working .!!! how to connect 2 database on 1 query.


thank you.

[gerard4143]

Could we see the php code...Thanks Gerard4143

[HROAdmin26]

You can read the PHP documentation, find the section on the DB you're using (MySQL, Postgre, etc.), and then look at the select_db function.

PHP > MySQL > mysql_select_db