Problem With Count Function

[sam02]

Hi,

 

I have got a problem with my count function.

I have two tables personal_details, sources.

 

Personal Details

--------------------

Title

Name

Address etc...

source_id

 

 

Source

---------

source_id

source

 

 

I want to create a query that shows the total number of customers entered with a specific source for example my result should show:

 

 

Source - Total

--------------------------------

Source 1 - 2

Source 2 - 1

Source 3 - 5

 

 

 

"SELECT personal_details.*, source.source COUNT(source_id) FROM personal_details, source WHERE (personal_details.source_id=source.source_id) AND TO_DAYS(NOW()) - TO_DAYS(leaddate) <= 30 GROUP BY source_id" 

 

 

Anybody Help?

Thanks

[micah1701]

what if you alias your COUNT() result, like:

 

SELECT personal_details.*, source.source COUNT(source_id) AS total_source_id FROM personal_details, source WHERE (personal_details.source_id=source.source_id) AND TO_DAYS(NOW()) - TO_DAYS(leaddate) <= 30 GROUP BY source_id"

 

[sam02]

I just get an error with adding that bit of code

[Barand]

try

<?php
$sql = "SELECT s.source, COUNT(p.source_id) as total
    FROM source s
    LEFT JOIN personal_details p 
    ON (p.source_id=s.source_id) 
        AND TO_DAYS(NOW()) - TO_DAYS(p.leaddate) <= 30 
    GROUP BY s.source_id"; 

?>

[sam02]

Hi, sorry for not replying sooner, but i still cant get that code to work, im not sure what is going wrong, there isnt an error but no data is shown on the page

 

any help is greatly appreciated

 

Thanks