|

// 17 Sept 2001
// originally we set the "letter" column here every time but this is not
// particularly efficient; e3 system was recently changed to have callback
// functions added to the product editor so the field is set there; a new
// callback will also be added to the import routine to deal with products
// when they are imported
//mysql_query('update product set letter = ucase(left(name,1))');
if($category_data[subcategories_visible]) {
e3_draw_category_box_ext($code, "code", $subcode, "Select Category", "", "name", "code", "submit_category_change()");
}
else {
$subcode = $code . "-FUL";
}
if($subcode) {
$dbquery = "select distinct(letter) from product p, product_category pc where exchange='0' and pc.product_code = p.code and pc.category_code = '$subcode' order by letter";
$id = mysql_query($dbquery);
$count = mysql_num_rows($id);
while($data = mysql_fetch_array($id)) {
$alpha[$data[letter]] = 1;
print "$data[letter] ";
}
if($count) {
print "order button at bottom of page";
}
}
?>
|
  |