Interested to Buy Any Domain ? << Click Here >> for more details...
How can we find the number of rows in a result set using PHP?
- 2 Answers
- 4734 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajan vardawaj
Here is how can you find the number of rows in a result set
in PHP: $result = mysql_query($any_valid_sql,
$database_link); $num_rows = mysql_num_rows($result); echo
“$num_rows rows found”;
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sunil kumar
<?php //first establish connection with database
mysql_connect("localhost","root","");
mysql_select_db("demoprj");
// then write the query suppose our table is tbl_student
$sql_stu="select* from tbl_student";
$res_stu=mysql_query($sql_stu);
$rows_stu=mysql_num_rows($res_stu);
echo"number of rows in tbl_student are=".$rows_stu;
?>
| Is This Answer Correct ? | 2 Yes | 0 No |
How to use validations in php?(codelgniter)
What is the differences between $a != $B and $a !== $B?
How do I stop php artisan serve in windows?
What type of errors can be occurred in php?
What is the use of mysql_fetch_array in php?
What does type casting mean in php? Explain with an example?
What is the difference between print() and echo()?
Tell me how a constant is defined in a php script?
What does it mean when it says the csrf token is invalid?
what is php?
What is the scope of career in PHP/Mysql
Which function gives us the number of affected entries by a query?
PHP 
