Database Query Problem with Sorting.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
gjb79
Forum Commoner
Posts: 96
Joined: Fri Jul 18, 2003 6:35 am
Location: x <-- (DC)
Contact:

Finally Solved

Post by gjb79 »

Ofcourse!

Thanks a lot Jam!
Dunno how I missed that. I have been rather brain dead today.

For anyone wondering, the

Code: Select all

WHERE (CharID = '$GCharID' AND BookID < '$GBookID') or (BookID = '$GBookID' AND ChapterID <= '$GChapterID')
is correct, It groups the search character with the previous books then adds the current book chapters to the query.

Thanks again Jam and feyd! :P
Post Reply