|
|
Posted by G0ng on 02/01/06 10:08
I have the following tables:
students
id, name,....
lessons
id,description,....
studentslessons
id,studentid,lessonid,grade
I want to list the lessons of student with name="John" for example.
The one way to do it is :
select id from students where name="John" and grab the id. then select *
from studentslessons where studentid=id;
the other is
select * from students,studentslessons where students.name="john" AND
students.id=studentslessons.studentid
Which is more efficient when using php4 and mysql 4.1? I'm using a
rather old computer Pentium 800MHz.
thanks
Navigation:
[Reply to this message]
|