Hi folks. Any suggestions on the following?
If a student signs up for classes, I don't want them viewing those
classes so they can choose them again. So I want to take out their
'signups' from the master class list.
"select classnumber, classnumbersignup
from classes, signups
where classnumber !IN (select classnumbersignup from signups where
userid = [$myID])
and mytype = 'yellow'";
I don't want to have to rely on middleware for this.
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
