T Month, Score FROM scores WHERE
> >> Username =
> >> '$Username'");
> >>
> >> to
> >>
> >> $query2 = ("SELECT count(*) FROM scores WHERE
> >> Username = '$Username' and
> >> Score &
query" .
>> mysql_error ());
>> $tally = mysql_fetch_row($result2);
>>
>> take out the while loop (the one with all the if's in it)
>> and, if I haven't
>> stuffed up somewhere, all will be okay - (btw, I haven't
>> had experience
>
be okay - (btw, I haven't had experience
using mysql, but I'm assuming that it's sql is compatable with interbase and
oracle)
Hope that helps
Martin
-Original Message-----
From: Brian Tully [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 8:59 AM
To: PHP DB; PHP
Su
Hi,
If I am not missing anything, you are not sorting
SELECT Month, Score
FROM scores
WHERE Username = '$Username'
Also, the requirement is not three consecutive test in a
month, so I would not break the loop into months.
once you have it ordered it by the date :
while (list($Month, $Score
hey folks -
i'm stumped. been working on what i thought would be a simple script to
cycle through users' records and perform a query. But I can't get the loops
right, it seems like only one or two records get updated.
Using MySQL, we have about 2000 students enrolled. each month they take a
tes
5 matches
Mail list logo
