PHP MySQL sum or max Problem

[Anon]

Hello all. I've seen some posts relating to problem I'm having, but I haven't yet seen any explanation or solution.

Here's the problem:

I'm doing an SQL query to select the SUM of all values in a particular column. I.e.,

$result=mysql_query("SELECT SUM($timespent) FROM followinfo WHERE ticketnum=$ticketnum");
if($row=mysql_fetch_array($result))
{...

I have MySQL running on a Linux6.2 server. The thing is it DOES work from the command line. Only, in the script, calling it from the browser, it returns bogus or no results. Same thing for MAX. Any ideas?

[Anon]

Hmm... since you're using "mysql_fetch_array(...)", you should give the sum a name, like:

"SELECT SUM($timespent) AS total FROM followinfo WHERE ticketnum=$ticketnum"

... and you can refer to it with $row["total"]

Hope it helps ... 🙂