please help me with this mysql query

[littlegirl]

please tell me how i can do this :
i have 2 tables:
student
id_student
name_student
Lname_student
ID_drejtimi
year_studing

drejtimet
ID_drejtimi
Name

i have even a from in wich i choose the year in wich the student is and the "drejtimi"(this is a field that tells if student its for inforatic, telecom or electronic ) based on this i have to generate a table with all studnts lets say of first year , telecomunication .
the query that i did is this :

<?$query= "select *from student,drejtimet where drejtimet.Name='$Drejtimi' and student.year_studing='$Vit' and drejtimet.ID_drejtimi=student.ID_drejtimi order by student.name_studnet ";?>

the result that i take from this query is an ampty table .... may u help me please

[devinemke]

have your form pass the ID_drejtimi rather than the drejtimi Name, then you query would be:

SELECT * FROM student WHERE year_studing = '$year_studing' AND ID_drejtimi = '$ID_drejtimi' ORDER BY name_student

where $year_studing and $ID_drejtimi are passed from the form.

[littlegirl]

but how can i do that ?