Link to home
Start Free TrialLog in
Avatar of Zeke Rich
Zeke RichFlag for United States of America

asked on

php COUNT on left join

I am trying to count the results with count and left join but i am getting error.  

Please help if you can. Thanks.
// find out how many rows are in the table 
$sql2 = sed_sql_query("SELECT DISTINCT l.*, u.* COUNT(*) FROM leads AS l LEFT JOIN $db_users AS u ON l.current_sales_rep_id=u.user_id $where $order");
$r = sed_sql_fetchrow($sql2);
$numrows = $r[0];

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial