Re: Witango-Talk: searching for elegant count sql statement

[Brent Skean]

Hi John,   Using RBase:   sel count(distinct studentname) from tablename   What db are you querying?   Brent Skean Current Solutions       -----Original Message----- From: John Newsom <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Sunday, March 02, 2003 10:08 AM Subject: Witango-Talk: searching for elegant count sql statement Hi, I have a database with a table which contains multiple student id's, +----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+----------------+ | projID | int(11) | | | 0 | | | stuID | int(11) | | | 0 | | | rank | int(11) | | | 0 | | | uniqueID | int(10) unsigned | | MUL | NULL | auto_increment | +----------+------------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) most occurring more than once since a student may make multiple requests which are stored in the table. I want to count the number of times each student name occurs, and then store the frequency in an array. I thought that the sql count function would help, but it seems not directly. I had to first do a search to find each unique id (using distinct), then with a for loop iterate through the resultset, and do a search for each id, and then add each numrows value to an array. I also tried bracketing the second search between two results html with a beginning and ending rows loop, but that doesn't seem to work either! So, short version is I have the thing working (see attached taf) but seems like a lot of work that should be able to be accomplished in a single select statement. Thanks for any insights. John Newsom ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body