Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND subcatid=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND subcatid=2' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_alarm=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_atomic=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_automatic=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_chronograph=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_date=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_dive=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_diamondf=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_diamondm=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_extreme=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_fashion=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_luxury=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_military=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_pilot=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_sport=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_titanium=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_unique=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attr_vintage=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND isspecialdeal=1' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kmwPrice>0 AND kmwPrice<100' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kmwPrice>=100 AND kmwPrice<200' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kmwPrice>=200 AND kmwPrice<350' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kmwPrice>=350 AND kmwPrice<500' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kmwPrice>=500' at line 1<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 7<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 16<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 8<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 8<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 9<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 8<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 8<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 16<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 12<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 4<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
Error 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND j.bid=b.bid AND (j.catid=1 OR j.catid=2)' at line 8<br />
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/usr/home/watchwear/domains/kenmarwatches.com/public_html/uni.php</b> on line <b>1312</b><br />
SELECT j.*,b.bname,c.colname
				FROM Brands b, JeffStore j, Collections c
				WHERE 
					
					j.isactive=1 AND
					j.bid= AND
					b.bid=j.bid AND
					c.colid=j.colid 
				ORDER BY c.colname,j.model