Posted by BlueNosE on 01/01/07 06:07
if u will send me a mail, i may give u a mysql-backup-code that i
created.
else, i will tell u my functions:
-----------------------------------
first function: mysql_list_tables ($DB);
-----------------------------------
this function allowed, at least at my server. like "SHOW TABLES FROM
{$DB}", but allowed.
after it i created a SQL syntax of table creation.
-----------------------------------
second function: mysql_query ("SHOW COLUMNS FROM {$TABLE}");
-----------------------------------
to see the field list and types, youll have to use it.
just do print_r and see.
-----------------------------------
third function: mysql_query ("SELECT * FROM {$TABLE}");
-----------------------------------
i dont think that i have to explain. simply use that list with INSERT
SQL syntax..
good luck!
[Back to original message]
|