Okay, you guys helped me immensely to move my foxpro football app (college & pro) to a web application. It still has a few bugs but it essentially works. My lowest ranking on the ESPN 'pigskin pickem' is 97.0 percentile. Currently at http://www.garyjeurink.com/addons/football/index.php
1. pardon me for requiring a login, 2. I'm also struggling with making an auto function to set the current week (right now you have to set the week). MY QUESTION: My method to update the team records (W-L, conW-conL, hmW-hmL, vsW-vsL) is really messy and now the stupid pro-games have had a tie. My games table looks like .. [Date, hmID, vsID, hmSc, vsSc, conf, gmrecno, season]. I keep the win loss record along with curAVG stats in a table for each team by the season but it must be updated each week after the new scores are entered. In foxpro, I make 1-view to count wins for each category for wins and losses, then I make a second view that joins the 1st view to the stats table and I then use REPLACE to update each category. 16 separate views and then the main 8-called in an update procedure. I would think there is an easier way.AND on top of that, now I need to detect ties in the NFL. Gary Jeurink --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5E4E7458C5BB49E391ED13555A9DC9AA@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.