MySQL Forums
Forum List  »  Ruby

avg () and Joins in mysql
Posted by: Erfan anjum
Date: May 24, 2010 12:22PM

hi,

i am using following query to fetch data from multiple tables now i want to get the average of fetched records.
like i want to get the average marks of IRFAN.

CAN ANYONE PLS TELL ME HOW TO USE AVG() IN THIS QUERY




$QUERY = "SELECT subject,FirstName,marks FROM subject,all_members,marks WHERE all_members.mid = marks.mid and subject.subjectid = marks.subjectid and marks>=40 and all_members.FirstName='irfan'";
$rs = mysql_query($QUERY);

Options: ReplyQuote


Subject
Written By
Posted
avg () and Joins in mysql
May 24, 2010 12:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.