SELECT * FROM templates WHERE (name = 'info') SELECT categ_id, descr, disp_seq_no, img_file, REPLACE(img_file, '.jpg', 'T.jpg') AS thumbnail FROM ec_categ WHERE (parent_id = '') AND (descr != 'new items') ORDER BY disp_seq_no; my $where_engraved = ''; my $info_request = "!template.temp_param1!"; if ($info_request =~ /engrav/) { $where_engraved = qq(AND ATTR_COD_1 != ''); } return qq( SELECT item_no, long_descr, REPLACE(ecomm_img_file, '.jpg', 'T.jpg') AS thumbnail FROM im_item WHERE qty_avail > 0 $where_engraved ORDER BY RAND() LIMIT 4);

Questions? Call us toll free at 888-465-6614

- - - - -

Free Shipping on Orders over $100...some restrictions apply