There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Web Design & Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Internet & Networking > Web Design & Development >
SQL Count Function Challenge


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
Carnadyne's Avatar
Junior Member with 2 posts.
 
Join Date: Jun 2005
Experience: Intermediate
28-Oct-2007, 06:19 PM #1
Unhappy SQL Count Function Challenge
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

Last edited by Carnadyne : 28-Oct-2007 06:28 PM.
haswalt's Avatar
Computer Specs
Senior Member with 416 posts.
 
Join Date: Nov 2004
Location: South Coast, UK
Experience: Advanced
29-Oct-2007, 07:49 AM #2
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's Avatar
Senior Member with 1,767 posts.
 
Join Date: Feb 2002
Location: North Carolina, USA
Experience: Programming-Advanced|EVER
29-Oct-2007, 01:52 PM #3
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.
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 02:02 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.