Getting # of Rows from database where variable = $variable

[GnaUnited]

How do I go about getting the number of columns where say variable1=$variable2. I dont want to get all of the columns, just the one under a certain catagory.

[steved]

Select count(*) as RowCount from myTable where something = $something