Fix MySQL C script

Closed Posted Jun 4, 2008 Paid on delivery
Closed Paid on delivery

I had someone (on here) write me a queuing script.

Basically what it does is creates 10 spawns of the program.

For each spawn, it will do this.

- SELECT from the mysql database

- Send the mysql data to a website via curl

- Insert the results from the webserver into another database

- Delete the record from the original database

It will keep doing this... I need some things fixed, all related to the mysql portion.

1) Right now, it selects and inserts from the same database. I need that fixed, it needs to select from a different database (on another machine) and then insert on another one so there's two different databases.

2) Currently it locks a table for who knows what reason, the developer said so other spawns don't take the "record" again... However that needs to be fixed. As soon as it selects from the data, it needs to delete that same record, THEN send it to the web server, and then insert the webserver result.

Thats it -- Pretty simple.

C Programming Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3959457

About the project

12 proposals Remote project Active Jun 26, 2008

12 freelancers are bidding on average $144 for this job

meral

See private message.

$85 USD in 2 days
(111 Reviews)
7.6
rgdavis

See private message.

$169.15 USD in 2 days
(35 Reviews)
7.4
yazwas

See private message.

$170 USD in 2 days
(113 Reviews)
6.7
vw6868760vw

See private message.

$42.5 USD in 2 days
(53 Reviews)
5.6
Aldarund

See private message.

$17 USD in 2 days
(43 Reviews)
5.6
macFR

See private message.

$85 USD in 2 days
(37 Reviews)
5.5
b0tivw

See private message.

$80.75 USD in 2 days
(17 Reviews)
5.0
csigvw

See private message.

$85 USD in 2 days
(24 Reviews)
4.9
inversen

See private message.

$21.25 USD in 2 days
(14 Reviews)
3.4
jessewhite

See private message.

$17 USD in 2 days
(5 Reviews)
3.3
faprodev

See private message.

$42.5 USD in 2 days
(2 Reviews)
2.7
sumitsahay

See private message.

$850 USD in 2 days
(0 Reviews)
0.0
ashitpro

See private message.

$85 USD in 2 days
(0 Reviews)
0.0