How would you do this?

[k994519]

Hi guys

I want to create a form which the user enters there student or staff id. and their module code which is stored on the db tables students and staff respectively .... so im wondering if this query would work....

If [$student_id*] Isset then do the following query

$query= select student_id, module_id where student_id="$student_id" and where Module="$module";

Logical OR

$query= select staff_id, module_id where staff_id="$staff_id" and where Module_id="$module";

*I Ideally I would like it to use only one "$type" for the staff_id and student_id but I am uncertain as how to do this....

any help for this would be very much appreicated.....

[Kudose]

You could designate staff members to a $type of t10988 and students someting like s22345

Just designate a leading character to determine if the user is staff or student.