Re: [PHP-DB] Re: [PHP] need help looping through each record with a query -stumped

2002-01-10 Thread DL Neil
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

[PHP-DB] Re: [PHP] need help looping through each record with a query -stumped

2002-01-09 Thread Brian Tully
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

[PHP-DB] RE: [PHP] need help looping through each record with a query - stumped

2002-01-09 Thread Martin Towell
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