vb.org Archive - help with query to select counts

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - help with query to select counts (https://vborg.vbsupport.ru/showthread.php?t=64636)

Jakeman

05-02-2004 04:28 AM

help with query to select counts

I want to select the number of records for each idnumber that exists. In the below example, there are three 2's, four 3's, and three 4's. I want to capture this information in a single query if possible.

I know how to capture a record count for a single idnumber, but I'm not sure how to do capture counts for multiple idnumbers in one query.

An example of the table:

Code:

____________________

| idnumber | title |

|-------------------

| 2        | ..... |

| 2        | ..... |

| 2        | ..... |

| 3        | ..... |

| 3        | ..... |

| 3        | ..... |

| 3        | ..... |

| 4        | ..... |

| 4        | ..... |

| 4        | ..... |

Any help is appreciated.

Xenon

05-02-2004 09:43 AM

you need grouping:

[SQL]SELECT COUNT(*), idnumber
FROM table
GROUP BY idnumber[/sql]

sabret00the

05-02-2004 09:07 PM

i think he wants to capture the count of 2, then the count of 3's then the count of 4's

if that's the case, i'm not sure how to do it i'm afraid, it's what i'm reading up on now, but i'm pretty certain it's via a "while"

Jakeman

05-03-2004 02:08 AM

Quote:

Originally Posted by Xenon

you need grouping:

[SQL]SELECT COUNT(*), idnumber
FROM table
GROUP BY idnumber[/sql]

that worked. thx

Boofo

05-03-2004 03:50 AM

Quote:

Originally Posted by sabret00the

The code Stefan posted will do that. ;)

Xenon

05-03-2004 03:35 PM

You're welcome Jake :)

All times are GMT. The time now is 04:17 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02312 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: