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 Quote 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 Quote 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 ! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.