New User Questions..

[mystique]

Is there a way to limit with a where clause?

I am looking a vpopmail database and there are several domains in the mysql database (vpopmail.mysql)

I was wondering if I could limit my view to one domain?

from vpopmail.vpopmail where pw_domain='domain.com'

Thanks in advance.

dadabik_4.3_alpha
FreeBSD
Mysql 4.x
Safari
Nginx w/ssl
php5

 

[JP]

Where do you want to limit this "view"? In the results page / show all records page, or in your search form?

 

[mystique]

The entire 'site' ..

I've been looking through the forums and found you can do "something" in the php files.. but I'd rather have control over it in the gui if at all possible.

and thank you for taking the time to respond.

 

[JP]

Why not strip the database of all the domains you don't want before you publish your site? If you only want one domain it would be a waste of space to keep a database full of information (domains) you do not want. You can set up your search to look for a specific domain but all the domains would still be in the database and would still be shown on an empty search or show all pages. I'm sure a where clause could be used, I'm just not sure where in the code it would be placed.