> I'm trying to pull all the records from the table class where classID is
> not equal to the value of classID in the table assignment.

> Currently, I have 'select class.classID, class.classDesc from class,
> assignment where assignment.classID >= class.classID and
> assignment.assignmentID=$assidn'. $assidn is value of
> assignment.assignmentID.

> When I do this query, I am missing a good chunk of records. What am I
> doing wrong?

You're only getting the rows that are less then or equal to class.classID,
i think you want <> or not equal to.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to