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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to