have info

[mohamad_1978]

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

[greg252]

Why don't you want to use a while loop?

[ajmoore]

I'm not sure if I'm completely understanding the question, but I'll give it a shot. If you want to sum a column of data from a DB you could always use the mySql's SUM function...

$sql = "SELECT SUM(field) FROM table";

But if you just want to check to see if there are values greater than 0 why not just do this:

$sql = "SELECT * FROM students WHERE grade > 0";
$res = mysql_query($sql);
if(mysql_num_rows($res)>0) {
      //display link because grades higher than 0 exist
} else {
      //do something else
}

[mohamad_1978]

thanks guys

why i dont use while .. i just want to lern new ways

ajmoore ------------ the 2nd code work fine with me but the first did not return the sum i dont know why