Sortuj wg. ID Nazwa Kategoria Cena Magazyn ▲ Rosnaco ▼ Malejaco -- Wszystkie kategorie --'; foreach ($categoriesArray as $CategoryID => $CategoryName) { $selected = (isset($_GET['category']) && $_GET['category'] == $CategoryID) ? ' selected' : null; echo ' ' . $CategoryName . ''; } if (isset($_GET['category']) && array_key_exists($_GET['category'], $categoriesArray)) { $whereCategory = 'where p.CategoryID = ' . $_GET['category']; $category = $_GET['category']; } else { $whereCategory = null; $category = 0; } echo '

'; $result = mssql_query('select ProductID, ProductName, CategoryName, UnitPrice, UnitsInStock from Products p join Categories c on p.CategoryID = c.CategoryID ' . $whereCategory . ' order by ' . $by . $sort); while ($product = mssql_fetch_assoc($result)) { $hilight = !$product['UnitsInStock'] ? ' style="color: #fff; background: #f00;"' : null; echo ' '; } echo '

ID	Nazwa	Kategoria	Cena	Na magazynie	Edycja
' . $product['ProductID'] . '	' . $product['ProductName'] . '	' . $product['CategoryName'] . '	' . $product['UnitPrice'] . '	' . $product['UnitsInStock'] . '	Edytuj

'; ?>