this is my script:
$query1 = "SELECT count(*) FROM result WHERE class = '$Class' AND subjects='English' AND matrics IN ("SELECT matric FROM student WHERE course= '$f_kursus'")";
when i run, this error is appear:
Parse error: syntax error, unexpected T_STRING in c:\wamp\www\ikm\papar.php on line 34
whereas line 34 refer to the above script.
could anyone tell me where is the error............

Looks like there are extra double-quotes -- around the subquery.

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!

oh yes! i've found it. but it still didn't work because apache server i'm using is doesn't support nested query. so, does anyone know what else alternative that can produce the same output instead of above nested query?

I don't think apache cares whether there is a nested query (or not), that typically depends on the backend database. What DB do you use? If it is mysql, what is the version?

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!

i'm using mysql v 4.something. but, that query has been settled. i've convert it to 2 single query. now, i have another one query that i failed to convert it. it already four days i worked for it, but i got no solution.

query=SELECT * FROM student WHERE course = 'TKK' AND matric NOT IN (SELECT matrics FROM result WHERE subject = 'mathemathics')