Web Development

Ask something
Discussion Locked

Website

0 helpful
2 replies

by a_masoka

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi guys, I'm building a website for a restaurant using php & mySql, however i do not know how to add the function to enable me to remove booked table and then putting it back on again when table is free. Anyone knows how to go about it??

2 replies

by j.edney

You should be able to use a simply PHP/MySQL script to call for that function. I'm assuming you have an administrative area where you will be editing these booked tables. Add a checkbox next to each table you have available that would be called something like "cleartable". When you check the box next to table 1 and hit update for example, it would remove the reservation information from that table. Then, just tell PHP to see the row in the database for that table is empty or null, and have it print on the page as free or open.

Hope this assists you.

~Jon

by a_masoka

Sure does help, thanks a mil mate, most appreciated and if I do get stuck I'll be back:).

This discussion is closed to new replies.