Welcome Guest, Not a member yet? Register   Sign In
how to create this query
#1

[eluser]Unknown[/eluser]
select teacher.name, school.name from teacher, school where teacher.teacherID=teaching.teacherID and school.schoolID=teaching.schoolID and teacher.name like $data;

and for the data is insert by user from an input form....
#2

[eluser]kevinprince[/eluser]
Look at active record in the user guide, and look at doing a join rather than a cross table search.




Theme © iAndrew 2016 - Forum software by © MyBB