yandoo Posted February 12, 2007 Share Posted February 12, 2007 Hi i was hoping for a bit of help if possible please... ive created a database which loans laptops to users. I have a table detailing "laptops", a table detailing "loan information" (laptop loaned to user) and table detailing "users". This is how the form is structured: Loan ID Users Name - Users table Date Time Laptop Name - Laptop table Complete Y/N Description I have created a loan form that details all of the three tables details. Using the "Laptop" table, i have made a dynamic select menu of the laptops avaliable for loan on the form. My problem is that when the laptops are on loan they will ALL still appear i the menu. THIS is where i need some help please??!! I need to make it so that if the laptops are out on loan(i.e. "Loan completed" Select menu on the form "Y/N"), they dont appear in "Laptop" table dynamic select menu. This would then avoid the Laptops every being Loaned Twice!!!! Any help much apreciated thank you Link to comment https://forums.phpfreaks.com/topic/38215-please-help/ Share on other sites More sharing options...
Jessica Posted February 12, 2007 Share Posted February 12, 2007 Add a boolean field to the laptop table called "available" or something. When you loan one, mark it as not-available. Have your select get all WHERE available = 1 Link to comment https://forums.phpfreaks.com/topic/38215-please-help/#findComment-183004 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.