[RESOLVED] select sum value as a number not a string

[jacksonpt]

Here's my code:

$sql = "SELECT sum(NumPeople) FROM fall2005 WHERE VisitTime LIKE '10 a.m.' AND VisitDate LIKE '$VisitDate'"; 
  $result = mysql_query($sql); 
  $count_10am = mysql_fetch_row($result);

This gives me an array value for count_10am - I need it to be an integer. How do I get that value out of the query as an integer?

[pohopo]

Try this...

 $sql = "SELECT sum(NumPeople) as sum_NumPeople FROM fall2005 WHERE VisitTime LIKE '10 a.m.' AND VisitDate LIKE '$VisitDate'"; 
  $result = mysql_query($sql); 
  $count_10am = mysql_result($result,0,"sum_NumPeople");

[jacksonpt]

Great - that works. Could you explain to me why it works, so I actually understand what's going on? I understand the query, but not the 0,"sum_NumPeople" part.

Thanks for the help.

[pohopo]

0 means to pull from the first record of the array
sum_NumPeople is your field name so it is saying pull the value from this field.