devan Posted November 20, 2011 Share Posted November 20, 2011 TRUNCATE TABLE CubeCart_cats_idx; INSERT INTO CubeCart_cats_idx (productid, cat_id) SELECT productid, cat_id FROM CubeCart_inventory; I an running the following in MyPHPAdmin, but need this to be automated in a PHP script, how would I do it ? all help is appreciated, still new to PHP & MySQL many thanks D Link to comment https://forums.phpfreaks.com/topic/251494-how-would-i-run-the-following-mysql-query-in-a-php-script/ Share on other sites More sharing options...
Pikachu2000 Posted November 20, 2011 Share Posted November 20, 2011 mysql_connect mysql_select_db mysql_query Link to comment https://forums.phpfreaks.com/topic/251494-how-would-i-run-the-following-mysql-query-in-a-php-script/#findComment-1289802 Share on other sites More sharing options...
devan Posted November 21, 2011 Author Share Posted November 21, 2011 thank you, me bad ! Link to comment https://forums.phpfreaks.com/topic/251494-how-would-i-run-the-following-mysql-query-in-a-php-script/#findComment-1289918 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.