prefix . "ap_services"; $servicedetails="SELECT * FROM $table_name WHERE `id` ='$sid'"; $servicedetails1 = $wpdb->get_row($servicedetails); $servicedetails1->category_id; } ?>

Name
Description		<?php echo $servicedetails1->desc; ?>
Duration
Duration Unit		Select Duration's Unit unit == 'minute') echo "selected"; ?> >Minute(s)
Cost
Availability		Select Service Availability availability == 'yes') echo "selected"; ?> >Yes availability == 'no') echo "selected"; ?> >No
Category		Select Category prefix . "ap_service_category"; $service_category = $wpdb->get_results("select * from $table_name"); foreach($service_category as $gruopname) { ?> category_id == $gruopname->id) echo "selected"; ?>id) echo "selected"; ?> > name; ?>
		Update Create Cancel

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