I'm not great at PHP but I'm learning. Tables are cTeams, cGames, cTmstats. The cTmstats gets updated each week along with cGames that have been played. I don't know how to update the MySQL cTmStats with the foxpro cTmstats.dbf each Tuesday morning. I need to update the MySQL tables at godaddy with my foxpro data and I don't know how. PHP gives me access to MySQL but how do I connect foxpro? ... I tried delimited text but they usually crash at 1/2 to 2/3rds using MyAdmin... whatever its called.
Gary Jeurink -----Original Message----- From: Stephen Russell [mailto:[email protected]] Sent: Tuesday, August 09, 2011 6:07 PM To: ProFox Email List Subject: Re: visual foxpro 6 to mysql On Tue, Aug 9, 2011 at 5:26 PM, Gary Jeurink <[email protected]> wrote: > I have developed a football statistics database that I update each week for > the 120 d1a college football teams and the 32 pro teams. Included is the > schedule so you can pick a game and the various yds and points are predicted > for upcoming games. Its fun and I do well on college pickem and pigskin > pickem on espn. I update from web pages to excel sheets and then merge to my > database with a view each week. What is the easiest way to reload a MySQL > table on a server [godaddy] from my foxpro data table? > ------------- I would do update statements as well as insert statements. You can crunch many togther via a union and pass a long string as a script So how do you set up to accomplish this? I would make two passes to identify updates to existing rows and then add in new rows. Create a script per table for both types of statements. Just a guess but you have a row for each team in a game ? You also put in some rows to support players accomplishments in that game? Inserts are pretty simple : INSERT INTO table1 (field1, field2) VALUES ('foo', 'bar'); UPDATE table1 SET field1 = 'foobar', field2' = 'new value' where ID=??? -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/33275FD21D904FC5A6EB095C1FA31506@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
