looking for script

New Member Joined: Sep 24, 2003 Posts: 10

Looking to convert HTML to MYSQL. Can anyone point me i the right direction??

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Need clarification. HTML is a browser markup language. MySQL is an rdbms (Relational DabaBase Management System). There is no relating the two. You can use PHP to embed serevr side calls to MySQL, but there is no conversion.

Posted: Fri Sep 26, 2003 4:29 pm

I have a table (HTML) that I would like to convert to text, then put it in my DB.

Raven it is this whole standings thing Smile

I am tryin to lighten my load and throwin' lots of idea's around.

I still would like u to qoute me your idea's for my top ten block.

I have scripts that will grab HTML from the standings but it is limited to using a startgrab= (htm tag) and endgrab=(HTML tag) but the tag cannot be a duplicate tag else where! well to make a long post short, I cannot get the tywo columns of info I want I get all the stats for the top ten.

Sorry to ramble.

Posted: Fri Sep 26, 2003 4:48 pm

I have been only answering some posts this week as I have been somewhat under the weather. Let me try to toss together a real quick PoC (Proof of Concept) for you. I was hoping the file_get_contents thing was enough to help you get there. Give me a few minutes.

Posted: Fri Sep 26, 2003 7:44 pm

I have done a PoC for you. Under the Site Navigation is an entry called Raga_Test. When you select it, it will pull from that link you gave and then parse the html and produce the first 10 entries. There are many ways to do this and this is but one. As long as you have static documents, it's not too complicated.

Posted: Sun Sep 28, 2003 3:21 pm

Have you tried this to see if it's what you need?