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.