= 2) ) {
if ($_GET["kw"] == "photographer favorite") {
$sql="select p.photo_id, p.filename, p.description, p.photographer_favorite, ptg.gallery_id, c.camera_folder_name from photo p, photo_to_gallery ptg, camera c where p.photographer_favorite=1 and p.public=1 and ptg.photo_id=p.photo_id AND c.camera_id = p.camera_id order by p.photo_id";
} else {
$sql="select p.photo_id, p.filename, p.description, p.photographer_favorite, ptg.gallery_id, c.camera_folder_name from photo p, photo_to_gallery ptg, camera c where p.keywords like '%".$_GET["kw"]."%' and p.public=1 and ptg.photo_id=p.photo_id AND c.camera_id = p.camera_id";
//if there are no quotation marks in the keyword, append wildcard character to each term
if (strstr('"',$_GET["kw"])) {
// $_GET["kw"]
}
/* $sql="
SELECT p.photo_id, p.filename, p.description, p.photographer_favorite, ptg.gallery_id, c.camera_folder_name, p.keywords, MATCH (p.keywords) AGAINST ('
".$_GET["kw"]."
') AS score
FROM photo p, photo_to_gallery ptg, camera c
WHERE MATCH (p.keywords) AGAINST ('
".$_GET["kw"]."
' IN BOOLEAN MODE)
AND p.public=1
AND ptg.photo_id=p.photo_id
AND c.camera_id = p.camera_id
;
";*/
}
$res = $my_conn->query($sql);
?>
1) ? $show_plural = "s" : $show_plural = "";
$fb_pagename = "apps|gallery|search";
$fb_sendquerystring = true;
?>
Displaying result for ".trim($tags[$i])."
Friggin image search >> error
empty or invalid search string. no search performed.