[RESOLVED] Noob:Can someone please help with a query?

[jmaccs64]

Can someone please tell me what is wrong with my syntax below:

SELECT students.student_id, students.first_name, students.last_name, students.grad_year, students.grade_level, acad_adv.acad_adv_id, acad_adv.student_id, acad_adv.assigned_resource, acad_adv.assigned_date, acad_adv.present WHERE students.student_id = acad_adv.student_id AND students.student_id LIKE '%" . $name .  "%' OR students.last_name LIKE '%" . $name ."%' AND acad_adv.assigned_date = $date AND acad_adv.assigned_resource = $resource

[jmaccs64]

I figured it out!

SELECT
students.student_id, students.first_name, students.last_name, students.grad_year, acad_adv.assigned_resource, acad_adv.assigned_date
FROM students
INNER JOIN acad_adv
ON students.student_id=acad_adv.student_id
WHERE
students.last_name LIKE '%ith%'
AND
acad_adv.assigned_resource = "1"
AND
acad_adv.assigned_date = "2010-05-08"