dools Posted March 23, 2011 Share Posted March 23, 2011 Can anyone help me with the following php query>?? CLINIC(ClinicName, ClinicLocation, DoctorName) APPOINTMENT(AppointmentNumber, PatientName, MedicalCondition, ClinicName) Get the appointment number and patient name for appointments where the clinic name is < select box value > Thanks Link to comment https://forums.phpfreaks.com/topic/231498-php-query/ Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 What part are you having trouble with? Link to comment https://forums.phpfreaks.com/topic/231498-php-query/#findComment-1191329 Share on other sites More sharing options...
dools Posted March 23, 2011 Author Share Posted March 23, 2011 This is what i have so far.... <html> <body> <head> Query1 </head> <br> Please select a Clinic: </br> <Form action = "query1.php" method= "post"> <select> <select value= "valuelist">; <option value= "Falls Road Surgery">Falls Road Surgery</option> <option value= "Ballyowen Health Centre"> Ballyowen Health Centre</option> <option value = "Carrick Hill Medical Centre"> Carrick Hill Medical Centre</option> <option value = "Hillhead Surgery"> Hillhead Surgery</option> </select> <INPUT TYPE = "Submit" Name = "Enter" VALUE = "Enter"> </form> </body> </html> Link to comment https://forums.phpfreaks.com/topic/231498-php-query/#findComment-1191345 Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 Please use tags when posting code. Link to comment https://forums.phpfreaks.com/topic/231498-php-query/#findComment-1191348 Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 You don't give the select input a name. Can you post the query1.php? Link to comment https://forums.phpfreaks.com/topic/231498-php-query/#findComment-1191350 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.