= 2) ) {
$sql="
SELECT p.photo_id, p.filename, p.description, p.date, ptg.gallery_id, c.camera_folder_name
FROM photo p, photo_to_gallery ptg, camera c, gallery g
WHERE p.keywords like '%".mysql_real_escape_string($_GET["kw"])."%'
AND p.public=1
AND ptg.photo_id=p.photo_id
AND g.gallery_id=ptg.gallery_id
AND g.active=1
AND c.camera_id = p.camera_id
ORDER BY p.date, p.photo_id";
/*
SELECT p.photo_id, p.filename, p.description, p.keywords, ptg.gallery_id, c.camera_folder_name
FROM photo p
LEFT JOIN (photo_to_gallery ptg, camera c, gallery g)
ON (ptg.photo_id=p.photo_id AND c.camera_id = p.camera_id AND g.gallery_id=ptg.gallery_id)
WHERE MATCH (p.keywords) AGAINST ('
%".$_GET["kw"]."%
')
AND p.public=1
AND g.active=1
ORDER BY p.photo_id";
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 = mysql_query($sql,$my_conn);
$num_rows = mysql_num_rows($res);
($num_rows == 1) ? $show_plural = "" : $show_plural = "s";
?>
Loading results
photo_id;
if ($thisimg != $lastimg) {
$count++;
?>
Friggin error!!
empty or invalid search string. no search performed.
