sql query

[jhsands]

How do I embed this into a php file, calling the database name and such so I can run it just by accessing a php file?

 

database: allisons_osc1

Table: products_groups

customers_group_id

 

 

$sql = 'DELETE FROM `products_groups` WHERE `products_groups`.`customers_group_id` = 0 LIMIT 25;# MySQL returned an empty result set (i.e. zero rows).'
	. ' ';

[Guest]

you could create a new file in the admin folder with

 

<?php
 require('includes/application_top.php');
 tep_db_query("DELETE FROM products_groups WHERE products_groups and customers_group_id= '0'");
?>

backup your dbase first.