What DBMS are you using? ... Oracle, MySQL or what? If MySQL then you don't have to make it manual with PHP code (I mean copy process) .. use something link PhpMyAdmin - there it is very easy to do it. -- Muhammed Mamedov Software Engineer YTM.com.tr "Jeremy" <jeremy@elijahgeneration.com> wrote in message 20030907132515.88322.qmail@pb1.pair.com">news:20030907132515.88322.qmail@pb1.pair.com... > I need to copy some tables from one mysql database to another mysql database > on the same server. > > I looked at the php manual and couldn't find it...I found stuff on > mysqlhotcopy, but it doesn't look like that will do what I need it to do, or > maybe I'm reading the manual wrong. > > Can someone please show me how to do this? To be specific, it's just a table > with a list of US states in it... > table name: states > fields: state_id, name, abbreviation > > Thanks, > > Jeremy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php