prefix . "ap_services"; $ServiceDetails ="SELECT * FROM `$ServiceTable` WHERE `id` ='$sid'"; $ServiceDetails = $wpdb->get_row($ServiceDetails); $ServiceDetails->category_id; } else { $ServiceDetails = NULL; } ?>

		" >
		<?php if($ServiceDetails) { echo $ServiceDetails->desc; } ?> " >
		Enter Numeric Value. Eg: 5, 10, 15, 30, 60", "appointzilla"); ?>" >
		" >
		Enter Numeric Value Eg: 5 , 10, 25, 50, 100, 150", "appointzilla"); ?>" >
		" >
		" >

prefix . "ap_services"; $insert_service = "INSERT INTO `$ServiceTable` ( `name` , `desc` , `duration` , `unit` , `cost` , `availability`, `category_id` ) VALUES ('$servicename', '$desc', '$Duration', '$durationunit', '$cost', '$availability', '$category');"; if($wpdb->query($insert_service)) { echo ""; } echo ""; } //update a service if(isset($_POST['updateservice'])) { $sid = $_GET['sid']; $ServiceName = $_POST['name']; $desc = $_POST['desc']; $Duration = $_POST['Duration']; $durationunit = $_POST['durationunit']; $cost = $_POST['cost']; $availability = $_POST['availability']; $category = $_POST['category']; $ServiceTable = $wpdb->prefix . "ap_services"; $update_service ="UPDATE `$ServiceTable` SET `name` = '$ServiceName', `desc` = '$desc', `duration` = '$Duration', `unit` = '$durationunit', `cost` = '$cost', `availability` = '$availability', `category_id` = '$category' WHERE `id` = '$sid';"; $wpdb->query($update_service); echo ""; echo ""; } ?>