[SOLVED] division by 0 error

[sprint10s]

below is the code that i wrote and it still works but i get a warning error on the site.  basically im trying to select all the rows in a racing event of in the case below the dash for cash race and take the results of the race and show an average start and a average finish of each event.  but if that user does not race in the dash and puts a 0 or null value i get the following error

Warning: Division by zero in /home/www/standridgemotorsports.com/func/db_results_body.php on line 105

 

i think i need another if statement to say if total is 0 then print 0 or something but not sure how to do it.

Thanks in advance.

 

//calculates average Dash Start

$ds = mysql_query("SELECT d_start FROM track WHERE user_id=1 ");

$numds = 0;

while($datads = mysql_fetch_array($ds)) {

if($datads['d_start']!=0 && $datads['d_start']!=""){

$numds++;  //This line is a shortcut that basically means $numhf=$numhf+1

}

 

$totalds += $datads['d_start'];

}

$avgds = round($totalds/ $numds, 2);

 

//end of Dash Start

[Renlok]

before

$avgds = round($totalds/ $numds, 2);

add

$numds ? ($numds == 0) ? 1 : $numds;

[sprint10s]

tried that then get a

 

 

Parse error: syntax error, unexpected ';'

on the line that i added

[Maq]

$numds = ($numds == 0) ? 1 : $numds;

[sprint10s]

Sweet it worked thanks guys for the quick response and help, I really appreciate it.