你怎么知道mysql数据库是否有多个结果？

Question

I have a portfolio which is showing results from my database... I need to know how to find out if there's more than one of the items with the same owner using an if statement...

It's not advanced I just have a table with the company name, website address etc. and at the end a column that's named "owner" which has the owners email address...

I need to find out if there's more than one portfolio item with the same email address

Please Help

Thanks Ben

Update: mysql_num_rows($result) is the answer

Answer 1

So, your table looks like this:

portfolio
=============
company
url
owner

A SQL query to retrieve the number of portfolio items per owner:

SELECT COUNT(*) as Num_Portfolio_Items, owner FROM portfolio GROUP BY owner;