How can we find the number of rows in a result set using PHP?
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 advance thing in php7?
Which is the latest version of php?
Which are the best start and end tags to use?
What is the meaning of a final class and a final method?
What are php data types?
How can you declare a constant variable in php?
What is the delimiter default in PHP?
How can we submit a form without a submit button? What is the use of obj_star?
2 Answers Rushmore Consultancy,
I went to an php interview yesterday.I got selected there.But,They asked me to sign bond by submitting my certificates for 2 years.Is it good or bad
Explain what is the use of "echo" in php?
Explain the types of string comparision function in PHP
How to install PHP with --mcrypt and --mhash?