Hi , I a kinda new to all this database thing so i would appreciate your help. I have three tables First table named "student" stu_id f_name l_name 2nd table named "grade" stu_id cours_num grade 3rd table named "course" course_num cours_title cours_desc I have an HTML form with a text field where i need to enter cours_num Now when i click submit button it should first look into my database to check if that course number exists or not. If it does then it should display All the stu_id, f_name and l_name (remember $studentid=$_POST["coursenumber"] and also count the number of record.( relating to that cours_num that we entered from the html page) else display message "course number not found";
Prajita - Rather than worry about what they enter after the fact, use the data you have in the 'course' table to populate a select on your form. That will force the student to supply an existing course.