Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can we find the number of rows in a result set using PHP?

Answers were Sorted based on User's Feedback



How can we find the number of rows in a result set using PHP?..

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

How can we find the number of rows in a result set using PHP?..

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

Post New Answer

More PHP Interview Questions

What advance thing in php7?

0 Answers  


Which is the latest version of php?

0 Answers  


Which are the best start and end tags to use?

0 Answers  


What is the meaning of a final class and a final method?

0 Answers  


What are php data types?

0 Answers  


How can you declare a constant variable in php?

0 Answers  


What is the delimiter default in PHP?

0 Answers  


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

7 Answers  


Explain what is the use of "echo" in php?

0 Answers  


Explain the types of string comparision function in PHP

0 Answers  


How to install PHP with --mcrypt and --mhash?

1 Answers  


Categories