> 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.
I realize this is getting more OT, but if anyone has a nice table structure
for handling team v. team series stats I'd like to hear i
"Mihail Bota" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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 commen
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 goa
If (in MySQL) I have to select 'playerID' from the table soccer.players
based on lname='smith', fname='john', and dob='1988-12-02' and THEN update
soccer.teams 'coachID' equal to the result of the select statement, can I do
it all in one query?
Or must I let my PHP script execute a select, grab th
