[Resolved] Help with Query

ppowell

I am getting the following PHP error:

Fatal error: Got error 'invalid character range' from regexp using query: SELECT a.image_id FROM image_person_assoc a , image s WHERE a.person_id = '21' AND s.id = a.image_id AND s.image_path REGEXP '^{/www/html/a[[.-.]]frame/ic/images/([a-zA-Z0-9-.]+.)+[a-zA-Z0-9-]+$'}

I am trying to write a very simple query that will select from joined tables where image_path will contain a very specific pattern.

How do I do this?

Thanx
Phil

Kudose

Check into the LIKE clause of MySQL.

ppowell

Can't use LIKE clause, because "image_path" can be:

/www/html/a-frame/ic/images/blah.jpg

/www/html/a-frame/ic/images/2000-Annual-Conference/blah.jpg

and the query would fail because you are doing a filtered query where you are only looking for images whose path contains "2000-Annual-Conference".. THEN AGAIN, you might be doing a filtered query where there is NO directory after "/images" and instead looking for all images in the ../images folder, which would fail because you can't search for "no album".

Doing like then would be like

LIKE '/www/html/a-frame/ic/images/%'

Which fails because you'll get /images/blah.jpg AND /images/2000-Annual-Conference/blah.jpg which is wrong

LIKE '/$album/%'

Which fails because if $album is NULL then it will look for '//%' which it also will never find.

That's why I came up with REGEXP it's the ONLY logical recourse I have.

Phil

ppowell

I got it and it was just plain bizarre, I don't even understand why this works now.. I just rearranged the character range and everything worked beautifully!

SELECT a.image_id FROM image_person_assoc a , image s WHERE a.person_id = '1' AND s.id = a.image_id AND s.image_path REGEXP '^{/www/html/a-frame/ic/images/([a-zA-Z0-9.-]+.)+[a-zA-Z0-9-]+$'}

Go figure!

Phil