our system is as follows;
MySQL
Server: Localhost via UNIX socket
Server version: 5.1.41
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)
Apache/2.2.3 (CentOS)
MySQL client version: 5.0.67
PHP extension: mysql
phpMyAdmin - Version information: 3.3.5
i am looking for some one to manage our db.
regular maintenance
additional data parsing
## Deliverables
our db collects copies of receipts from bars/nightclubs.
i want to parse out the data in db. i will want to create reports from this data.
1. i have attached 5 samples of the data in the text
2. also attached is a screen shot from the db
3. for example the first receipt is #159
4. i want to parse out all the data (so for receipt #159)
a. date = 06/17/2010
b. bartender = Jimmy
c. time = 12:15 AM
d. bar =FITZPATRICK BRE
e. check = 1 of 1
f. Term = 1
g. number = 1
h. item name = PREMIUM
i. price = 12.00
j. TOTAL: = $12.00