thnks, i will give it a shot "Armand Turpel" <armand@a-tu.net> wrote in message 3EFAEDCE.2060100@a-tu.net">news:3EFAEDCE.2060100@a-tu.net... > I use an db abstraction class. You have to replace this by yours. Of > course you got a "Fatal error: Call to a member function on a > non-object" because such an object dosen't exist in your script. First > you have to connect to a database using mysql_connect() and using > mysql_query and mysql_fetch_row. > > Armand > > Nabil wrote: > > >thanks a lot for your response but i got > > > >Fatal error: Call to a member function on a non-object in > >c:\inetpub\wwwroot\dump.php on line 3 > >not that mysql is 3.23.53 > > > >my script is : > >///// > ><?php > >$sql = 'SHOW TABLES FROM chat'; > >$db->query($sql); > >while ($row = $db -> fetchRow ('DB_GETMODE_NUM') ) > >{ > >$sql = ' BACKUP TABLE '.$row[0].' TO "/db_backup" '; > >$db->query($sql); > >} > >?> > >///// > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php