[SOLVED] help with query

[dannyone]

hey everyone

 

i want to make a query so that i can display the supervisor,marker1 and marker2 of the person who has logged in. i can get it to display the supervisor easily by using this query;

 

$query="SELECT * FROM Student_Markers,Marker WHERE Student_Markers.Supervisor = Marker.Marker_ID AND Student = '" .$_SESSION['login'] . "'";

 

but i want to also link marker1 and marker2 to the same Marker_ID field, so the query would go something like this;

 

$query="SELECT * FROM Student_Markers,Marker WHERE Student_Markers.Supervisor = Marker.Marker_ID AND Student_Markers.Marker1 = Marker.Marker_ID AND Student_Markers.Marker2 = Marker.Marker_ID AND Student = '" .$_SESSION['login'] . "'";

 

can anyone suggest a way in which i could get this to work?

 

any help would be great

 

Thanks

[dannyone]

i figured it out now i feel like a right lemon, i just needed to use OR instead or AND

 

Thanks

[Maq]

For the future could you use

tags.

 

We also have a section specifically for MySQL Help.

[dannyone]

yeah sorry i will do in future

 

thanks