Count a phrase in SQL

[melloorr]

Hello, sorry if I do not explain this well but I am wondering if there is some code that allows me to search a database for a username, and counts how many times the username is in the database, then displays the total amount on-screen

[voip03]

you can use mysql_num_rows()

http://php.net/manual/en/function.mysql-num-rows.php

http://www.plus2net.com/sql_tutorial/mysql_num_rows.php

 

mysql count()

http://www.tizag.com/mysqlTutorial/mysqlcount.php

 

if you google it  mysql_num_rows vs count

 

[Philip]

IMO count is the way to go.

[Pikachu2000]

As a general rule, if you need to run a SELECT query to get data that you're going to use for something, and you also need the count, use mysql_num_rows(). If all you need is a count and no other data, use a SELECT COUNT() query.

[melloorr]

Thanks for the help everyone, but it will be too hard to implement it so I am giving up for now.

 

But I plan on Learning PHP and SQL properly soon, so you may see more of me here

 

Thanks again!

[fenway]

Thanks for the help everyone, but it will be too hard to implement it so I am giving up for now.

 

But I plan on Learning PHP and SQL properly soon, so you may see more of me here

 

Thanks again!

What's too hard to implement -- one query?

[melloorr]

What's too hard to implement -- one query?

 

Yeah, I am using pbpbb so it will also mean would having to find the username without actually typing it in. (too complicated for me to understand)

[fenway]

What's too hard to implement -- one query?

 

Yeah, I am using pbpbb so it will also mean would having to find the username without actually typing it in. (too complicated for me to understand)

I don't know what that means.