Hi there is there way to add all the values in my data base without useing while loop for example
i have students database
name
id
grade
grade is 0 as strat
and i want to call the DB and show link in my page to the students list page if i add grades in my data if at least 1 studnets have grade more then 0 then the link will show
my project is not about student but it is example i hope anyone can help
I don't really understand what you're looking for, but I think it is SUM.
From the manul:
SUM(expr) Returns the sum of expr. Note that if the return set has no rows, it returns NULL!
im really soccer my english is problim lol
anyway i think this is close for what i need
lets say i have table called (students) and we have in it (name) , (id) and (grade)
and i want return the sum of the row (grade)
do u know how i can do it ?