"where" limits?
| From: | Addison Ellis | Date: | Wed, 05 Feb 2003 00:37:34 +0000 |
| Subject: | "where" limits? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25438@lists.php.net to get a copy of this message | ||
hello,
is there a limit to how many "where" statements one can include in a query?
i am wondering if i can add this:
where createdate >= subdate(now(),interval 1 month)"
to this:
$obj = mysql_db_query($dbname,"select a.*,s.name as subcategory_name,c.name as category_name from ads a,subcategory s,category c where a.subcategory=s.id and s.category=c.id and a.subcategory=$id and a.que='checked'");
with no complications and if so, where should i insert it???
i do appreciate your time. best regards, addison
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
addison@bellsouth.net
info@smipco.com
subsidiaries of small independent publishing co.
info@gloabaldog.com
info@momandpocentral.com