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 is the function func_num_args() used for?
What is difference between print_r and echo in php?
Does php have a future?
What was the old name of php?
What is the use of "echo" in php?
Do you know what is the use of rand() in php?
What is the purpose of the '.myd' file extension? What do thes file contain?
Which is faster for or foreach php?
What are the differences between PHP3 and PHP4 versions?
How can I use the COM components in php?
1 Answers Covansys, Rushmore Consultancy,
How can image properties be retrieved in php?
Is rent a variable cost?