to trouble shoot what is wrong, the first thing we will need to know id the actual SQL that is being run by the script.
Just after the body tag of you page, add the following:
<?php echo($query_recordsetName); ?>
where recordsetName is the name of your recordset.
once you know the SQL being run by the script, try taking that and running it against the database directly. I use the MySQL GUI Tools Query Browser, you may have something else.
If you having problems, post the SQL here so I can see it.