Hi all,
I have created my first MySql database to use with a small flash game and PHP. Its a simple 4 field table - userid (primary key and auto incremented), username, co_name, and score_ref.
What I need to be able to do using PHP is search my table for all co_names that equal say "Dublin" and return a new co_total i.e. the total of all the score_ref fields for co_name Dublin.
I am not sure what the SQL query is though now looking at this. Can someone please point me in the right direction. I am thinking that I have not structured my database correctly!
