count seperate columns

[LukeFilms]

I want to have a dash board page that shows the total counts of info from certain columns but just can not get it to work

"SELECT count(*) AS total_rows, count (MovieDvd) as total_dvd where MovieDvd = 1 from dbo.t_contacts "

Total Rows Move DVD Interest

100 64

any ideas

right now i get
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'from'.
/lfdata/html/dashboard.asp, line 126

 

[vongrunt]

FROM comes before WHERE...

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[druer]

Try this:

select sum(1) as TotalRows, sum(case when moviedvd = 1 then 1 else 0 end) as Total_DVD
from dbo.t_contacts