Counting specified fields that are not NULL

[mourningreign]

I'd like to count 4 specified text fields (last,last2,last3,last4) for which contain data and sum the total
then count 4 more text fields (last5,last6,last7,last8) for which contain data and sum that total.

Each total which will be a number from 2-4 will have a dollar value in a related table that I can then sum and display on a page.

[joshi_v]

select sum(field1,field2,field3,field4) as First_count, sum(field5,field6,field7,field8) as second_count from table_name;

For dollor sybmol you have to append it seperately. Is this what you are looking for?

Regards,
Joshi.

[mourningreign]

I'll be happy to just deal with one at a time...I get a syntax error.

[Jenk]

[code]SELECT CONCAT('$', SUM(`col1`, `col2`, `col3`, `col4`))
AS `count1`
--etc[/code]

[mourningreign]

SELECT CONCAT('$', SUM(`last`, `last2`, `last3`, `last`))
AS `count1`

Syntax error still

[joshi_v]

post the query with error message here!

[mourningreign]

Did I screw it all up?

<?php
$last_Recordset1 = "1";
if (isset(1)) {
  $last_Recordset1 = (get_magic_quotes_gpc()) ? 1 : addslashes(1);
}
$last2_Recordset1 = "1";
if (isset(2)) {
  $last2_Recordset1 = (get_magic_quotes_gpc()) ? 2 : addslashes(2);
}
$last3_Recordset1 = "1";
if (isset(3)) {
  $last3_Recordset1 = (get_magic_quotes_gpc()) ? 3 : addslashes(3);
}
$last4_Recordset1 = "1";
if (isset(4)) {
  $last4_Recordset1 = (get_magic_quotes_gpc()) ? 4 : addslashes(4);
}
mysql_select_db($database_bbb, $bbb);
$query_Recordset1 = sprintf("SELECT CONCAT('$', SUM(`%s`, `%s`, `%s`, `%s`))  AS `count1`", $last_Recordset1,$last2_Recordset1,$last3_Recordset1,$last4_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $bbb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

[joshi_v]

Replace your query with this query

[code]
<?php

$query_Recordset1 = "SELECT CONCAT('$',SUM('$last_Recordset1','$last2_Recordset1','$last3_Recordset1','$last4_Recordset1'))  AS `count1` ";

?>
[/code]

[mourningreign]

This-
[CODE]
<?php
$last_Recordset1 = "1";
if (isset(1)) {
  $last_Recordset1 = (get_magic_quotes_gpc()) ? 1 : addslashes(1);
}
$last2_Recordset1 = "1";
if (isset(2)) {
  $last2_Recordset1 = (get_magic_quotes_gpc()) ? 2 : addslashes(2);
}
$last3_Recordset1 = "1";
if (isset(3)) {
  $last3_Recordset1 = (get_magic_quotes_gpc()) ? 3 : addslashes(3);
}
$last4_Recordset1 = "1";
if (isset(4)) {
  $last4_Recordset1 = (get_magic_quotes_gpc()) ? 4 : addslashes(4);
}
mysql_select_db($database_bbb, $bbb);
$query_Recordset1 = "SELECT CONCAT('$',SUM('$last_Recordset1','$last2_Recordset1','$last3_Recordset1','$last4_Recordset1'))  AS `count1` ";
$last_Recordset1,$last2_Recordset1,$last3_Recordset1,$last4_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $bbb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
[/code]

Gets this -

Parse error: parse error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /homepages/19/d125543458/htdocs/bbb/test.php on line 4

[joshi_v]

Just remove the above part of the query.I think that part is automatically generated by Dreamweaver.Use just query part.nothing else

and let us know the status.