Assuming that c.province is the province name, and c.province_id is the province code, and U.province_id is the province code from the User table, I don't see where in your statement you have filtered the search down to just the province_id for the CURRENT USER.
I think you need something like "... and U.user_id = (current user_id). Yes? -Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]