Well I reworked it a bit
Code:
$sql = "SELECT stkcatpropid,
label,
controltype,
defaultvalue
FROM stockcatproperties
WHERE categoryid ='" . $myrow['categoryid'] . "'
AND reqatsalesorder =0
ORDER BY stkcatpropid";
$PropertiesResult = DB_query($sql, $db);
$PropertyCounter = 0;
$PropertyWidth = array();
while ($PropertyRow = DB_fetch_array($PropertiesResult)) {
$PropValResult = DB_query("SELECT value
FROM stockitemproperties
WHERE stockid='" . $StockID . "'
AND stkcatpropid ='" . $PropertyRow['stkcatpropid']."'", $db);
$PropValRow = DB_fetch_row($PropValResult);
if (DB_num_rows($PropValResult)==0){
$PropertyValue = _('Not Set');
} else {
$PropertyValue = $PropValRow[0];
}
echo '<tr>
<th align="right">' . $PropertyRow['label'] . ':</th>';
switch ($PropertyRow['controltype']) {
case 0:
case 1:
echo '<td class="select" style="width:60px">' . $PropertyValue;
break;
case 2; //checkbox
echo '<td class="select" style="width:60px">';
if ($PropertyValue == _('Not Set')){
echo _('Not Set');
} elseif ($PropertyValue == 1){
echo _('Yes');
} else {
echo _('No');
}
break;
} //end switch
echo '</td></tr>';
$PropertyCounter++;
} //end loop round properties for the item category
echo '</table></td>'; //end of Item Category Property mod