How we put the rows count in php and mysql?

Answer 1

by using mysql_num_rows function

Answer 2

do a fetch_assoc in a rows var, and then loop or use lenght property

Answer 3

DO NOT USE mysql php functions. they are depreciated.

depends on if you're using pdo or mysqli. but as stated previously, with fetch_assoc you can count() the rows or pass a count in the query itself.