Jump to content

Recommended Posts

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.