[ProtoPC]

Thanks Abe. Version 2.5 search works for me now at http://www.cywire.com/member-albums.html. Took prefix I had added out:

------------------------------------------------------

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album AS album
WHERE state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
$searchwhere

------------------------------------------------------


// fetch data and prepare data
$albums = $db->query_read("
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
user.*
FROM " . TABLE_PREFIX . "album AS album
LEFT JOIN " . TABLE_PREFIX . "picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (album.userid = user.userid)
WHERE album.state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
$searchwhere
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");


------------------------------------------------------