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 Quote Link to comment Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 What part are you having trouble with? Quote Link to comment 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> Quote Link to comment Share on other sites More sharing options...
Maq Posted March 23, 2011 Share Posted March 23, 2011 Please use tags when posting code. Quote Link to comment 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.