prefix."wpsp_teacher"; $classnumber = $wpdb->prefix."wpsp_class"; $teacher_data = $wpdb->get_results("select * from $teacher_table"); $subtable=$wpdb->prefix."wpsp_subject"; //$wpsp_subjects =$wpdb->get_results("select * from $subtable where id='".esc_sql($subjectid)."'"); $wpsp_subjects = $wpdb->get_results($wpdb->prepare("SELECT * FROM $subtable WHERE id = %d",$subjectid)); foreach ($wpsp_subjects as $subject_data) { $subid = intval($subject_data->id); $classid = intval($subject_data->class_id); $subname = $subject_data->sub_name; $subcode = $subject_data->sub_code; $subteacherid = $subject_data->sub_teach_id; $subbookname = $subject_data->book_name; } ?>

get_results("select c_name from $classnumber where cid='".esc_sql($classid)."'"); $wpsp_class = $wpdb->get_results($wpdb->prepare("SELECT c_name FROM $classnumber WHERE cid = %d",$classid)); ?>