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
- 4610 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 |
What is csrf validation?
How to get the DNS servers of a domain name?
How do you check is php not empty?
Why should I learn php?
What is the difference between $_files['userfile']['name'] and $_files['userfile']['tmp_name']?
What is session php?
What does $globals means?
What is html used for?
Differentiate between require and include?
display selected value in dropdown list through javascript without page refresh
Is php used in 2019?
What is difference between isset and empty in php?
PHP 
