Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
Sfinxs
Client


Joined: Mar 09, 2005
Posts: 157

PostPosted: Fri Apr 08, 2005 12:47 pm Reply with quote

[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
 
View user's profile Send private message
64bitguy
The Mouse Is Extension Of Arm


Joined: Mar 06, 2004
Posts: 1159
Location: Sanbornton, NH USA

PostPosted: Fri Apr 08, 2005 3:11 pm Reply with quote

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.

_________________
Steph Benoit Only registered users can see links on this board! Get registered or login!
1CMS, 100% Section 508 and W3C XHTML/CSS Compliant (Truly) 
View user's profile Send private message Visit poster's website
Sfinxs
PostPosted: Fri Apr 08, 2005 6:57 pm Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©