News:

CPG Release 1.6.31
Minor maintenance release
Clean up remaining remnants of the .net CPG website
Improved installer_stub compatibility with various server configurations

Main Menu

how many pictures have titles and descriptions

Started by Infernal, December 14, 2007, 12:40:18 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Infernal

how can i tell this ?
i have some staff and because my site is damn huge and the pictures diverse i can only observe the db growing ..i need to know how many pics have descriptions and titles

my site is www.add-fun.com [if that helps usually i am told to post that here ]

Joachim Müller

Something likeSELECT COUNT(*) from yourTablePrefix_pictures WHERE caption='';or similar should do the trick.