I can call and ask advice but the free help at godaddy usually consists of helping you surf throughout their various web screens. I might use the pasted text method to build the starting team tables but I want to do stats and game outcome updates directly if possible.
Thank you very much Gary Jeurink -----Original Message----- From: Kevin Cully [mailto:[email protected]] Sent: Wednesday, August 10, 2011 7:39 AM To: [email protected] Subject: Re: visual foxpro 6 to mysql Hello Gary, Graham gave some good advice. One thing I seem to recall people talking about GoDaddy, is that there is a setting to allow for external connections to the MySQL database. Something needs to be turned on for that to work, if I recall correctly. If you are using phpMyAdmin, you can use Foxpro to create a string of INSERT statements. Check out TEXT ... ENDTEXT with the TEXTMERGE option. SELECT MyCursorOfNewTeamStats SCAN TEXT TO lcNewStats ADDITIVE TEXTMERGE NOSHOW INSERT INTO cTmStats (gamePK, cStat, nValue) VALUES (<<MyCursorOfNewTeamStats.gamePK>>,'<<MyCursorOfNewTeamStats.cStat>>',<<MyCu rsorOfNewTeamStats.nValue>>); ENDTEXT ENDSCAN _CLIPTEXT = lcNewStats && <-- Copies the series of INSERT statements from variable lcNewStats to the clipboard Now you can switch over to phpMyAdmin and paste in the series of commands into the SQL window and execute it. Quick. Dirty. Works. I (basically) use this scenario to update my archery club's MySQL based calendar for the year. -Kevin On 08/09/2011 11:29 PM, Gary Jeurink wrote: > 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 _______________________________________________ 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/F856BF5228E145BA97D097BBB9EE3D5A@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.
