If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

create export table script - php + mysql

ChicoMendez · 2007-07-17 12:30:59

hi i need to get an export script for a table on a database im using does anyone know where i could see sample code or a tutorial on how to create this script so as i can save the script into a variable and then run it on another database. tnx

Options

17-07-2007 1:30pm

#1

ChicoMendez

Registered Users Posts: 648 ✭✭✭

Join Date: July 2003

Posts: 364

hi

i need to get an export script for a table on a database im using

does anyone know where i could see sample code or a tutorial on how to create this script so as i can save the script into a variable and then run it on another database.

tnx

0

Comments

Options
#2 17-07-2007 2:18pm
The Corinthian

Closed Accounts Posts: 19,777 ✭✭✭✭

Join Date: June 2001

Posts: 19153

If you have access to phpmyadmin you should be able to see the typical syntax used when you export a table using CREATE TABLE. Beyond that all you need is the mysql_list_fields function in PHP. The following links are all you realistically need:

http://ie2.php.net/manual/en/function.mysql-list-fields.php
http://dev.mysql.com/doc/refman/5.0/en/create-table.html

0