php - Get the number of rows -
I need to get the number of lines of studentID and then count if the count is greater than 10.
This is what I have written so far. But does not seem to work.
$ findID = ID1231275; $ Gipct = mysql_query ("SELECT COUNT (studentID) to classFees where studentID = '" $ findID. "' '); If ($ gipct> 10) {echo ("$ gipct"); }
$ searchID = 'id 1231275'; $ Gipct = mysql_query ("SELECT COUNT (studentID) classrooms as students where studentID = '$ searchID'"); $ Line = mysql_fetch_object ($ gipct); If ($ line-> Students & gt; 10) {echo $ row-> student; } The BTW, mysql_functions have been deprecated and can be removed in future versions, I recommend you see the PDF statement or the MyScal_Functions function.
Comments
Post a Comment