Photo searching

[M@]

Hey Dave:
Sorry to report a bug - I know it's nothing but more work - however I think you'll want to know about it:
I was trying to search for images, clicked the "Search" link in the gallery pages. I did not specify any parameters, but I did shift-click the "individual member galleries" so both choices were selected in that list box.

When I hit "Search" I got the following error:
MySQL error reported!

Script:

Query: SELECT id,user,userid,cat,storecat,date,title,description ,keywords,bigimage,width,height,filesize,views,med width,medheight,medsize,approved,rating,allowprint FROM photos WHERE approved='1' AND cat IN (all,500) ORDER BY disporder,lastpost DESC

Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'all,500) ORDER BY disporder,lastpost DESC' at line 1

Database handle: Resource id #19

Lemme know if you need more info.

I was hoping to get a list of images, and sort by "rating" to see the top photos.

M@

[skicdave]

Thanks M@

I think I read on the PhotoPost forum about a bug in search. I'll look into that later. This is a REAL recent version, and I know they are some small issues but they are constantly providing updates... if I can keep up :)

I have made a few mods so I can see what photos have keywords. Still need to update titles, keywords and locations on photos, plus upload a zillion others then we'll have a great database with options for integration into the trail maps/guides and such. Once all the photos are populated and updated, then I'll be addind numerous enhancements and improvements including accessing photos by combinations and ratings etc, as well as accessings albums by name, member, location etc.