PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Oh, and also you should look up what mysql_query does...it doesn't return a string that you can just echo. You have to retrieve the data somehow with mysql_fetch_array, mysql_fetch_row, etc, depending upon how you want to work with it.
Without looking it up, I'm also fairly certain that SUM is a group function, in which case you would need GROUP BY syntax at the end of your query. So in this case it would be "GROUP BY `status`".
And you are trying to access the value in the $rows array with the key that corresponds to your query object?? That makes no sense...in this case, since you're not giving SUM($column) a name, you'd have to $rows[0] to get the first returned value, which is the result of the SUM function.