\n";
// cCode='99300003W', name'99300003W', mfg'99300003W', mo'99300003W', sn'99300003W', remote'99300003W', ctl_type'99300003W', ctl_port'99300003W', code_set'99300003W'
if (empty($_REQUEST['equipment_tid'])) // if REQUEST[tid] is empty, this is a new entry
{
echo "\n";
$r = sqlRecycle("equipment", $q, "name = ''");
}
else // the record already exists, so this is an edit
{
echo "\n";
$r = sqlUpdate("equipment", $q, "tid='{$_REQUEST['equipment_tid']}'");
}
}
// ==========================================
$q = "select * from equipment where cCode='{$_REQUEST['cCode']}' and name != '' order by name,mfg,mo,sn";
$equipmentList = sqlEx($q);
$equipmentCount = mysql_num_rows($equipmentList);
switch ( $equipmentCount )
{ case 0:
$caption = "No Entries";
break;
case 1:
$caption = "1 Item";
break;
default:
$caption = "$equipmentCount items";
break;
}
echo "
Un-Networked Equipment ($caption)
\n";
echo "\n";
while ($equipmentItem = mysql_fetch_assoc($equipmentList))
{
echo " \n";
}
unset($equipmentItem);
echo " \n";
echo "
\n";
?>