require_once("../conn.php"); require_once("access.php"); include_once("LeftStyles.php"); if(isset($_POST[s1])) { $q1 = "update yellow_prices set PackageName = '$_POST[NewPackageName]', PriceValue = '$_POST[NewPrice]', Duration = '$_POST[NewDuration]', PriorityLevel = '$_POST[NewLevel]' where PriceID = '$_POST[PriceID]' "; mysql_query($q1) or die(mysql_error()); } //get the price info $q1 = "select * from yellow_prices, yellow_priority where yellow_prices.PriceID = '$_GET[PriceID]' and yellow_prices.PriorityLevel = yellow_priority.PriorityLevel "; $r1 = mysql_query($q1) or die(mysql_error()); $a1 = mysql_fetch_array($r1); ?>