| 08 8250 7155 |  |
| sales@pfapromotions.com.au |
PROMOTIONAL CATEGORIES 
- AUTOMOTIVE
- BADGES
- BAGS
- CAPS & HATS
- CLOCKS
- CLOTHING
- CLOTHING / WORKWEAR
- COMPENDIUMS & FOLDERS
- CONFECTIONERY
- DESK ACCESSORIES
- DRINKWARE
- GAZEBO
- GOLF ITEMS
- HEALTH & BEAUTY
- HOMEWARES
- KEYRINGS
- LANYARDS
- MAGNETS
- NOTEPADS
- NOVELTY ITEMS
- OUTDOORS / PICNIC
- PERSONAL ACCESSORIES
- SPORTS & LEISURE
- STATIONERY
- STICKERS
- TECHNOLOGY PRODUCTS
- TOOLS & TORCHES
- TOWELS
- TRAVEL
- UMBRELLAS
- WATCHES
- WINE ACCESSORIES
- WRISTBANDS
- WRITING ACCESSORIES
Products
| SELECT pfa_product.pid,pfa_product.pname,pfa_product.image,pfa_product.sprice,pfa_product.price,CASE WHEN pfa_product.sprice != '0' THEN pfa_product.sprice ELSE pfa_product.price END AS pfa_product.kprice FROM pfa_product JOIN pfa_category ON pfa_product.cid=pfa_category.cid AND pfa_product.status='1' AND pfa_category.type=1 ORDER BY pfa_product.kprice ASC - 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 '.kprice FROM pfa_product JOIN pfa_category ON pfa_product.cid=pfa_category.cid ' at line 1 |