action.php

prefix}institutionsdetails
INNER JOIN {$wpdb->prefix}category_tbl
ON {$wpdb->prefix}institutionsdetails.`category_id` = {$wpdb->prefix}category_tbl.category_id
INNER JOIN {$wpdb->prefix}type_tbl
ON {$wpdb->prefix}institutionsdetails.`type_id` = {$wpdb->prefix}type_tbl.type_id
INNER JOIN {$wpdb->prefix}county_tbl
ON {$wpdb->prefix}institutionsdetails.`county_id` = {$wpdb->prefix}county_tbl.county_id
INNER JOIN {$wpdb->prefix}status_tbl
ON {$wpdb->prefix}institutionsdetails.`status_id` = {$wpdb->prefix}status_tbl.status_id
WHERE institution_id= %d”;

$row=$wpdb->get_row($wpdb->prepare($query, $id), ARRAY_A);

$vinstitution_id=$row[‘institution_id’];
$vinstitution_name=$row[‘institution_name’];
$vregistration_no=$row[‘registration_no’];
$vcategory_id=$row[‘category’];
$vtype_id=$row[‘type’];

$vcounty_id=$row[‘county’];
$vregistration_date=$row[‘registration_date’];
$vexpiry_date=$row[‘expiry_date’];
$vstatus_id=$row[‘status’];
}
?>