Brian,
> first off, Martin your suggestion looks great but I don't think its SQL
> syntax is supported by MySQL. It's a good start though - gives me something
> to work with :)
=until it is tried, you won't know! From an SQL point of view it looks ok. In fairness
to Martin, from the
'further in
thanks guys, I really appreciate it.
first off, Martin your suggestion looks great but I don't think its SQL
syntax is supported by MySQL. It's a good start though - gives me something
to work with :)
I guess I need to clarify a bit more about what needs to happen...
in the MySQL database, ther
could you change this
$query2 = ("SELECT Month, Score FROM scores WHERE Username =
'$Username'");
to
$query2 = ("SELECT count(*) FROM scores WHERE Username = '$Username' and
Score >= 75 and Month in ('January', 'December', 'November', 'October')");
$result2 = mysql_query($query2) or