[RESOLVED] Select Count

drax007

Hi there im trying to count numbers in fields of a table but i get the error message: FUNCTION starwarsbattles.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

Whats up with my code?

Thanks

$colname_resultp = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_resultp = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_resultp = sprintf("SELECT COUNT (Class1, Class2, Class3, Class4) FROM planet WHERE PlayerName = %s", GetSQLValueString($colname_resultp, "text"));
$resultp = mysql_query($query_resultp, $swb) or die(mysql_error());
$row_resultp = mysql_fetch_assoc($resultp);
$totalRows_resultp = mysql_num_rows($resultp);

bradgrafelman

For one, MySQL's COUNT function only takes one parameter, so I'm not sure what you're trying to do with COUNT() using multiple parameters.

Second (unrelated to your error, but still important), note that [man]addslashes/man should never be used to prepare data for a MySQL query string. Instead, you should use a function specifically designed for such a task, such as [man]mysql_real_escape_string/man (for string data).

drax007

Hi there,

Does that apply to Sum as well??

$query_resultp = sprintf("SELECT Class1, Class2, Class3, Class4, SUM(Class1, Class2, Class3, Class4) FROM planet WHERE PlayerName = %s", GetSQLValueString($colname_resultp, "text"));

Thanks

bradgrafelman

Look it up in the MySQL manual to find out.

drax007

Yes it doesnt seem to work that way... Heres how i got it working:

$query_resultp = sprintf("SELECT SUM(Class1) As Class1_totla, SUM(Class2) As Class2_totla, SUM(Class3) As Class3_totla, SUM(Class4) As Class4_totla FROM planet WHERE PlayerName = %s", GetSQLValueString($colname_resultp, "text"));

Thanks