Re: need help with a query

"Mihail Bota" <mbota@almaak.usc.edu> wrote in message news:Pine.GSO.4.33.0312311433190.24399-100000@almaak.usc.edu... > I do not think it is going to work, you may want to stick with the PHP > script. MySQL says that is going to enable subqueries from version 4.1 and > the most recent release is 4.0.16 or 4.0.17. > > A question and 2 comments: > q: the teams are fixed within league? > c1: it is not clear how you record the goals of a team against of another. > 2. you may want to check the sizes of some fields; some are too big, or > too small. > > Mihai Thanks, Mihail. I'm using PHP 4.3.3 and MySQL 4.0.15-standard (stuck with what my ISP is providing). RE q: I don't understand your question. Do you mean, the teams are fixed for each season? The answer is yes. RE c1: I do not know how I was going to record the records of one team vs another in a specific series. That is a very good point and I don't have an answer. RE c2: I'll check the field sizes, thanks. Regards, Kirk