This is one part of a multiphase project. The output of this project will be read by a remote program that will use this data to perform its task. The remote program is NOT part of this bid.
The intent of this bid is two fold:
1) To have a mysql/php query program written that reads from the mysql db and streams the output to the user.
2) To find qualified talent that we can work with over the course of this project on a bid by bid bases.
The initial request is as follows:
1) Query a mysql db on the server (The db currently consists of 4 tables and these tables have from 2 to 17 columns).
2) Output the query using a data stream that will be read by a remote client computer that will read that data stream.
For this project only two of the four tables will be used. For this phase of the project two mysql queries need to be coded. The first query will stream all of the information in the table that has 17 columns but stream a subset of the 17 columns. The second query will get specific record requests from the remote program and the query will stream that one record to the remote program.
The two tables are setup as follows, one contains the data that is streamed to the remote program and the other has data in it to identify, validate and track the remote user. For the purpose of this project you are NOT expected to track any users.
We have the mysql database created already.