How do I insert this textfile into a table

Client Joined: Mar 09, 2005 Posts: 157

[url]unll.net/bxscr000.txt[/url]

I would like to add that data into my datatable. I saw the "insert data from a texfile into a table" link but when I click it and get checkboxes that I don't understand. What format do I have to get the textfile into before I can import. Thanks

Posted: Fri Apr 08, 2005 3:11 pm

That data is not formatted to be inserted into any table.

In order to "be inserted into a table" each item would need to be defined as a field element of an existing table/field structure.

The long and short of it is that you would need to define a new table with fields for:
Team
Player
POS
MIN
FGM-A
3PM-A
FTM-A
OFF
REB
AST
STL
BLK
TO
PF
PTS

Then you would need to identify the individual values seperated by a comma for each field.

Posted: Fri Apr 08, 2005 6:57 pm

I already have tables with these fields.

schid int(10) No 0
tid int(10) No 0
pid int(10) No 0
stat1 int(10) Yes NULL
stat2 int(10) Yes NULL
stat3 int(10) Yes NULL
stat4 decimal(10,3) Yes NULL
stat5 int(10) Yes NULL
stat6 int(10) Yes NULL
stat7 decimal(10,3) Yes NULL
stat8 int(10) Yes NULL
stat9 int(10) Yes NULL
stat10 decimal(10,3) Yes NULL
stat11 int(10) Yes NULL
stat12 int(10) Yes NULL
stat13 int(10) Yes NULL
stat14 int(10) Yes NULL
stat15 int(10) Yes NULL

Should I do something like this?

$query = "INSERT INTO nuke_league_games VALUES ('','schid', 'tid' ,'pid', 'stat1,'stat2','stat3','stat4'....)";
mysql_query($query);

I've never done this before. How would I identify something. If anyone can break it down for me I would really appreciate it.