I need to construct a PHP script that will take the results of a query to a MYSQL database (fields may vary) and then construct an array that is indexed on the State field or the Country field. THe script needs to tacke whether there are results for any given state/country, and if there are print out the results for that state/country. There needs to be a row check for the number of results by state/country, so that presentation options can be looped through. As an example, the MySQL database will have records including Patient Name, Address, City, State, Country and Phone, Plan 1, Plan 2, Plan 3. I The query will select all Patient Name, City, State and Plan 1,2,3 fields from the database. Inside the Plan 1,2,3 fields records contain a Y to indicate if they are a member of that plan. The output will need to be a list of patients that are alphabetical by State and then By City, then by patient name, and an indication of what Plan they are on. If there are no records for a state, then nothing for that state will be listed. All the state fields are 2 letters, and will need to be convereted to ALL CAPS full names (AL or Al becomes ALABAMA) The output would look like this ALASKA Fairbanks John Doe Plan 1, Plan 3 Wheeler jane Doe COLORADO Boulder Jim Doe Plan 3 Frank McDonald Plan 1, Plan 2, Plan 3
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
PHP 4.x, Mysql 3.23 unix bases. Global Variables are off.