Hi guys. I have been searching the forum for hours and I can not seem to find any help for a problem I am currently getting.
Im currently trying to expand my knowledge of PHP and MYsql, I wouldnt say I was a advanced user in anyway and I would imagine the soloution to my problem is quite simple.
I currently have a database set up,
Users with the fields, id, name, distance in it. another table called locations which has id, name, distance in it.
What I want to do is have a drop down menu or a tick box menu with the locations on it and when a user selects a location the distance in the locations table is subtracted from the distance in the users table…