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).
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]