Fitler to just horses for sale
On this page: http://www.communityhotline.com/PrideFarms/Barrel-Racing-Horses-For-Sale.php?customerid=6246&Search=Search
which will be this page shortly:
http://www.pridefarms.com/Barrel-Racing-Horses-For-Sale.php?customerid=6246&Search=Search
I have this statement
"SELECT ads_horses.*,tbl_posts.* FROM ads_horses INNER JOIN tbl_posts ON ads_horses.adid = tbl_posts.postid ORDER BY featured DESC";
I want to add this to statement but I keep blowing it out.
WHERE (enddate >= CURDATE() OR adexpires >= CURDATE()) AND displaylevel = '0' AND ad_type !='' ORDER BY postid post
I got this to work.