Skip navigation links

MySQL Forums :: PHP :: How to use form field as filter to query Mysql table?


Advanced Search

How to use form field as filter to query Mysql table?
Posted by: bosco Jean ()
Date: September 29, 2012 07:33AM

Hi

I am new in Php and My Sql.
I have created in Mysql a table
*Table1
organisation
title
country

I made a php form.
In the form, I have 2 fields organisation and title both are list fiels
here is what I want to do.
1-
I whant organisation to collect list from organisation in table1 but only the first per organisation. exemple It migh have 10 entry with organisation called hospital1. I want the list to show hospital1 once not 10.
2-
For the fiel title in the form, I want the list to show only tilte in organisation alredy selected in the field1.

All I need for those is just the Mysql sintax.
Thank you for your assistance

Options: ReplyQuote


Subject Written By Posted
How to use form field as filter to query Mysql table? bosco Jean 09/29/2012 07:33AM
Re: How to use form field as filter to query Mysql table? laptop alias 09/29/2012 08:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.