How cool would it be if there was a restaurant where you had to execute an SQL query to order your food? And the food there was so good that it resulted in people having to learn SQL just so they can eat there? Like some kind of geek elite.
Hello, could I please have:
And then when you've finished your meal:
Hello, could I please have:
PHP:
SELECT s.ItemName, s.ItemPrice
FROM dbo.Starters s
WHERE s.ItemName = 'Prawns with Crispy Chorizo'
UNION
SELECT m.ItemName, m.ItemPrice
FROM dbo.Mains m
WHERE m.ItemName = 'Burgers - Quarter Pounder With Cheese'
UNION
SELECT si.ItemName, si.ItemPrice
FROM dbo.Sides si
WHERE si.ItemName IN ('Chips - Regular', 'Onion Rings')
UNION
SELECT d.ItemName, d.ItemPrice
FROM dbo.Desserts d
WHERE d.ItemName IN ('Chocolate Brownie')
UNION
SELECT b.ItemName, b.ItemPrice
FROM dbo.Beverages b
WHERE b.ItemName = 'Lagers - Corona Extra'
PHP:
SELECT *
FROM dbo.Bills b
WHERE b.TableUser = SUSER_SNAME()
