Re: Mysql Query
| From: | Matthew Kendall | Date: | Sat, 23 Dec 2000 05:32:22 +0000 |
| Subject: | Re: Mysql Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-31656@lists.php.net to get a copy of this message | ||
"Gerry" <gerry@behost.com> wrote ...
> I'm having a problem with a PHP script that uses a Mysql database.
> <snip>
> How can i get all the images that match a keyword? what query?
SELECT download_image.*
FROM download_keywords
INNER JOIN (download_image
INNER JOIN download_keyw_img
ON download_image.id = download_keyw_img.image_id)
ON download_keywords.id = download_keyw_img.keyword_id
WHERE ((download_keywords.name) LIKE $search_keyword );