database query
Posted: Fri Oct 05, 2007 12:54 pm
Hi All, Could anyone help with some code?
I have a list in a 1 column mysql table (around 1million rows)
eg
red
blue
green
orange
purple etc....
I need to submit the list to a remote server (e.g. telnet to abc.co.uk 2034 ) going through the whole table but can only do 100,000 per day or will get banned.
I then need to store the data returned in another table.
e.g. I have a table with a column
red
blue
green
orange
purple etc.... I submit this to abc.co.uk 2345
It returns 1 line with about 5 fields which I want to write to a table with each field in it's own column.
Would anyone be so kind as to tell a complete newb how to go about this?
thanks in advance
I have a list in a 1 column mysql table (around 1million rows)
eg
red
blue
green
orange
purple etc....
I need to submit the list to a remote server (e.g. telnet to abc.co.uk 2034 ) going through the whole table but can only do 100,000 per day or will get banned.
I then need to store the data returned in another table.
e.g. I have a table with a column
red
blue
green
orange
purple etc.... I submit this to abc.co.uk 2345
It returns 1 line with about 5 fields which I want to write to a table with each field in it's own column.
Would anyone be so kind as to tell a complete newb how to go about this?
thanks in advance