Manufacturers Stocked starting 1, 2 & 3
Click the manufacturer name to see a list of products.
| 1 |
$sql = 'SELECT DISTINCT UPPER(man) AS man FROM parts WHERE man LIKE "1%" AND se = "1" AND private != 1 ORDER BY UPPER(man)';
foreach ($conn->query($sql) as $row) {
?>
|
print "" .htmlspecialchars($row['man']) ."";
//print $row['man'];
?>
|
};?>
| 2 |
$sql = 'SELECT DISTINCT UPPER(man) AS man FROM parts WHERE man LIKE "2%" AND se = "1" AND private != 1 ORDER BY UPPER(man)';
foreach ($conn->query($sql) as $row) {
?>
|
print "" .htmlspecialchars($row['man']) ."";
//print $row['man'];
?>
|
};?>
| 3 |
$sql = 'SELECT DISTINCT UPPER(man) AS man FROM parts WHERE man LIKE "3%" AND se = "1" AND private != 1 ORDER BY UPPER(man)';
foreach ($conn->query($sql) as $row) {
?>
|
print "" .htmlspecialchars($row['man']) ."";
//print $row['man'];
?>
|
};?>