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
- 4812 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 |
Is php 7.0 stable?
When to use single quotes, double quotes, and backticks?
Is php faster than javascript?
Do you know what is php?
What is the importance of parser in php?
How you can update memcached when you make changes to php?
i m a B.E,passed out few yrs bak failed to find good job due to less marks now thinkin of a career as PHP developer. is it a lucarative field and wat r career prospects; hv heard dat initial salary is very less bout 6k also most jobs r contrct jobs.pls guide me need ur valuable advice.pls hellppp!! thnx..
What is difference between print_r and echo in php?
Which php framework is best for web development?
Which will start a session?
How to delete file in php?
Should I use mysqli or pdo?
PHP 
