Updating mySQL with html data

[Jon12345]

I have a database with a BodyText field that is currently empty. Another field is Keyword which is populated.

The BodyText field is to be populated from data on another one of my websites. The URL is like this other site is:

www.myothersite.com/script.cgi/?keyword={keywordfrommysqldb}

I wish to cycle through all records from a named starting point (defined by the id. e.g. id=450), and take the content from myothersite.com that is queued up according to the current keyword from my site.

e.g. id=450 keyword=dogs

www.myothersite.com/script.cgi/?keyword=dogs

The html from that page is put into BodyText field where id=450

id=451 keyword=cats

www.myothersite.com/script.cgi/?keyword=cats

The html from that page is put into BodyText field where id=451

etc.

Make sense?

How can I do this?

Thanks,

Jon

[devinemke]

you can feed the URL to [man]file_get_contents[/man] to scoop up the rendered HTML and then stick the captured output to your db.