Y i still can't get total amount?? can check the coding for me????
$sql = "SELECT SUM(SCPrice) AS TotalAmount FROM orderlist WHERE userID ='$username' AND SCDate='$todate' AND Status = 'A'";
$Result = mysql_query($sql,$db);
$row = mysql_fetch_array ($Result);
$totalAmount = $row['TotalAmount'];
check coding
Moderator: General Moderators
- launchcode
- Forum Contributor
- Posts: 401
- Joined: Tue May 11, 2004 7:32 pm
- Location: UK
- Contact:
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
mysql_fetch_array($result) returns both
mysql_fetch_array($result, MYSQL_ASSOC) returns associative same as mysql_fetch_assoc($result)
mysql_fetch_array($result, MYSQL_NUM) returns numeric as is mysql_fetch_row($result)
http://us3.php.net/manual/en/function.m ... -array.php
mysql_fetch_array($result, MYSQL_ASSOC) returns associative same as mysql_fetch_assoc($result)
mysql_fetch_array($result, MYSQL_NUM) returns numeric as is mysql_fetch_row($result)
http://us3.php.net/manual/en/function.m ... -array.php
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA