Current location: Hot Scripts Forums » Programming Languages » PHP » Mysql- Count number of results that match

Mysql- Count number of results that match

  #1 (permalink)  
New Member
Join Date: Dec 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Mysql- Count number of results that match


I am looking for a way to count the results that match based on two fields, expert and customer.. My table structure is:

Expert SessionID Customer Problem Details
Sam 1111111 mike blah
Sam 2222222 Dave blah
Mike 2222222 Emily blah
Sam 3333333 mike blah

and so on, when the script outputs the info I need it to also display how many sessions the expert did with that customer, so for instance for expert Sam it would show 2 for mike, and 1 for Dave..
Reply With Quote

Featured Marketplace Scripts (view more)



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

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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] issue with mysql results and rows sinister-edd PHP 4 04-06-09 01:05 PM
PHP and MySQL ? rob2132 Hot Scripts Forum Questions, Suggestions and Feedback 4 08-29-08 02:22 AM
Look for advice on free and best match making(software) with php and mySQL peter2000 Script Requests 0 08-03-07 12:36 AM
Combing mysql results patter Database 3 04-29-07 12:20 PM
Which way to display results from mysql Peter_web PHP 2 09-13-03 05:39 PM

All times are GMT -5. The time now is 10:13 AM.
vBulletin® Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.