[Carnadyne]

I've been trying to solve a problem using the count function. What I want to do is count all the non-null values in a table but I want to exclude the first column. Is there a simple way to do this without having to use something like array_walk on the whole table?

OH I should mention I'm trying to get a count of all the fields in the whole table that are not null... not just the number of rows.

This is sorta what I'm trying to do... I know EXCLUDE is not an SQL statement

$q = "SELECT COUNT(*) FROM data_table EXCLUDE id_number";
$result = $system_database->query($q);

Any help would be greatly appreciated!

Thanks,

Chris

[haswalt]

well where you ahve count(*) that's where you would solve this.

Count i believe takes a list of columns to read in. If you put star it means all. Try only putting the columns you want. eg:

PHP Code:

$q = "SELECT COUNT(column2,column3,column4) FROM data_table"; 
$result = $system_database->query($q); 


[Fyzbo]

You seem to be almost there.

The following sql gives you a count of all rows where Column1 is not null.

Select Count(Column1) From Table Where Column1 is Not Null

Since sql is row oriented you may need to get the count of each column and then add them together afterwards.