Sortuj wg.

'; if (isset($_GET['edit']) && (int) $_GET['edit'] > 0) { $result = mssql_query('select ProductID, ProductName, CategoryID, UnitPrice, UnitsInStock from Products where ProductID = ' . $_GET['edit']); $editData = mssql_fetch_assoc($result); $editProductID = $editData['ProductID']; $editProductName = $editData['ProductName']; $editUnitPrice = $editData['UnitPrice']; $editUnitsInStock = $editData['UnitsInStock']; $editCategoryID = $editData['CategoryID']; } else { $editProductID = 0; $editProductName = null; $editUnitPrice = null; $editUnitsInStock = null; $editCategoryID = null; } if (isset($_POST['ProductID']) && (int) $_POST['ProductID'] > 0) { $result = mssql_query('update Products set ProductName = "' . $_POST['ProductName'] . '", CategoryID = ' . $_POST['CategoryID'] . ', UnitPrice = ' . $_POST['UnitPrice'] . ', UnitsInStock = ' . $_POST['UnitsInStock'] . ' where ProductID = ' . $_POST['ProductID']); } echo '

Nazwa:
Cena:
Na magazynie:
Kategoria:

'; $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 '
IDNazwaKategoriaCenaNa magazynieEdycja
' . $product['ProductID'] . '' . $product['ProductName'] . '' . $product['CategoryName'] . '' . $product['UnitPrice'] . '' . $product['UnitsInStock'] . 'Edycja
'; ?>