query($wpdb->prepare("INSERT INTO ".AMYLITE_PRICINGS." (name, description, code, price) VALUES (%s,%s, %d, %d)", $_REQUEST['name'], $_REQUEST['description'], $_REQUEST['code'], $_REQUEST['price'])); } if(!empty($_REQUEST['save'])) { $wpdb->query($wpdb->prepare("UPDATE ".AMYLITE_PRICINGS." SET name=%s, description=%s, code=%d, price=%d WHERE id=%d", $_REQUEST['name'], $_REQUEST['description'], $_REQUEST['code'], $_REQUEST['price'], $_REQUEST['id'])); } if(!empty($_REQUEST['del'])) { $wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_PRICINGS." WHERE id=%d", $_REQUEST['id'])); // delete ads assigned to the campaign $wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_PRICING_ZONES." WHERE pricing_id=%d", $_REQUEST['id'])); } // select pricing plans $plans=$wpdb->get_results("SELECT * FROM ".AMYLITE_PRICINGS." ORDER BY name"); ?>

			Cost	Create
		days	$

Plan Name	Description (optional)	Duration	Cost	Save
	<?php echo stripslashes($plan->description);?>	days	$