Soldato
- Joined
- 21 Jul 2004
- Posts
- 6,368
- Location
- Harrow, UK
I am trying to do a HTML / PHP script that works along side 2 SQL databases.
The plan is to do the following:
One a website, the user selects an event from a drop down box (from database 2), enters their surname and University ID Number.
They then click Submit, which then queries database 1 and checks if the surname and Uni ID exist. If it does not, it returns a message saying "You are not a member of this society". If the details do exist, it appends a table in database 2 and adds the event, surname and id in... and brings back a message saying "Booking confirmed".
Now on another page, you should be able to select the event and it should show all the booked members for that event (surname only).
I know quite a bit of HTML and can understand what PHP code means, but cannot write it... so any chance someone can help me with this.
It is for the University of Warwick Student Industrial Society website (you may have seen me asking for the tree picture - its for the same website)... so its not a piece of coursework or anything I am trying to cheat on
Any help will be greatly appreciated
The plan is to do the following:
One a website, the user selects an event from a drop down box (from database 2), enters their surname and University ID Number.
They then click Submit, which then queries database 1 and checks if the surname and Uni ID exist. If it does not, it returns a message saying "You are not a member of this society". If the details do exist, it appends a table in database 2 and adds the event, surname and id in... and brings back a message saying "Booking confirmed".
Now on another page, you should be able to select the event and it should show all the booked members for that event (surname only).
I know quite a bit of HTML and can understand what PHP code means, but cannot write it... so any chance someone can help me with this.
It is for the University of Warwick Student Industrial Society website (you may have seen me asking for the tree picture - its for the same website)... so its not a piece of coursework or anything I am trying to cheat on
Any help will be greatly appreciated