MySQL Query Problem

eRIC · #1 18-May-2004, 04:48

Hi.
I want to list names like in statistics.
In table i have:
name|phone|
-------------
doctor 4522
doctor 8965
eng 523
doctor 320
eng 789
eng 01245
doctor 98662

i wanto to print out like this:

doctors:4
eng:3

AND Does MySQL Support Sub Select ?

JdS · #2 18-May-2004, 05:49

Try with this SQL and see if it works:

PHP Code:


<?php
$sql = "SELECT CONCAT_WS( ':', `name` , COUNT(`phone`) ) AS `detail`
FROM `tbl_name`
GROUP BY `name`";
//...
?>

Quote:

Originally Posted by eRIC

AND Does MySQL Support Sub Select ?

Not yet... but apparently soon.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP MySQL query	jgnasser	MySQL / PHP Forum	3	08-Apr-2004 06:42
A problem Between MySQL <> phpBB	mirable	MySQL / PHP Forum	3	10-Sep-2003 06:31
Integrate a mysql query into another	norok	MySQL / PHP Forum	2	22-Jul-2003 07:25
Search Engine Positioning 101 and 201 "How To" Tips...	000	Search Engine Optimization Forum	0	29-May-2003 11:34
MySQL Adds Subselects, Upgrades Performance and Security	JdS	MySQL / PHP Forum	4	22-Jan-2003 18:42