PHP/mySQL Issue thats driving me bonkers

shad0w2k2

Hey everybody, I've got a interesting issue I hope someone here can shed some light on. I'm using PHP and mySQL to pull some data from a database and add up groups of info. I'm using the fallowing code.

<?

   $con = mysql_connect("***","***","***");
   mysql_select_db("qdts",$con);

   $sql = "SELECT exe, SUM(runnningTime) FROM Repository GROUP BY exe";
   $result = mysql_query($sql) or die(mysql_error());

   while($row = mysql_fetch_array($result))
   {
           echo "<center>".$row2['exe']." is at ".$row2['SUM(runningTime)']."<br>"."</center>";
           echo $row['SUM(runningTime)'];
   }

?>

but I just get "firefox.exe is at " in the browser. The funny thing is if I run the query directly in the mySQL console it runs just fine. This is the only code I have on this page.

Any ideas on why this would happen? Thank you all in advance for all your input.

-Dan

NogDog

You may want to do a var_dump() on $row and see how it indexes that summed field. (I'm not sure how PHP handles it.) What I usually do is assign an alias, as I then know how it will be indexed:

SELECT . . . SUM(runningTime) AS runTime FROM . . .

Then you'll know that your mysql_fetch will have it as $row['runTime'].

shad0w2k2

okay so I get...

array(4) { [0]=> string(11) "firefox.exe" ["exe"]=> string(11) "firefox.exe" [1]=> string(2) "20" ["SUM(runnningTime)"]=> string(2) "20" }

Funny thing is if I use the sql call in phpMyAdmin it works great too! But for some reason just a simple php script doesn't work.

Thank you again for all your help.

NogDog

Didn't catch this first time through:

       while([B][color=green]$row[/color][/B] = mysql_fetch_array($result))
       {
               echo "<center>".[B][COLOR="Green"]$row[/COLOR][COLOR="Red"]2[/COLOR][/B]['exe']." is at ".[B][COLOR="Green"]$row[/COLOR][COLOR="Red"]2[/COLOR][/B]['SUM(runningTime)']."<br>"."</center>";
               echo $row['SUM(runningTime)'];
       }