[Solar-talk] problem with related tables with latest svn

Paul M Jones pmjones at paul-m-jones.com
Sat Apr 12 08:21:36 CDT 2008


On Apr 12, 2008, at 06:45 , Jeff Surgeson wrote:

>         SELECT
> 	COUNT(gallery.id)
> 	FROM gallery
> 	WHERE
> 		gallerycat.sub_cat_name = \'bike images\'
> 	LIMIT 1

The reason it doesn't work is the WHERE clause; there's no FROM or  
JOIN to the "gallerycat" table.  I'll go back over the countPages()  
code and make sure it's not stripping things out that it needs.  Sorry  
for the trouble.


-- pmj


More information about the Solar-talk mailing list