Re: Is this kind of querry possible in MySQL?
| From: | Peter Westergaard | Date: | Mon, 07 Jan 2002 16:37:40 +0000 |
| Subject: | Re: Is this kind of querry possible in MySQL? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15500@lists.php.net to get a copy of this message | ||
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