Search Tutorials

Latest Questions

Timer in the code
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
My Eclipse deployed problem.
Dear All, I am facing a problem. When First time I am deploying a web project in eclipse in jboss its fine b
jsp code
how to count no of clicks made on a link and save it on database( using jsp)
Another Question
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
Connection pooling
Respected Sir/Madam, I am Ragavendran.R.. I need some clarification on what connection pooling is?
Error in a code.
This is the question I posted yesterday: "I'm trying to write a program that has a text field for input, two buttons an
netbeans resource prob
Hi,please can you tell me how to include a file like an image in the jar package in netbeans so that i dont need to prov
Failed to run Online Quiz Application in JSP
Hi, I have been following your following link to run the online quiz application, but I failed to get the result scre
Pass by Reference
Hi Friends, What is Pass by value and Pass by Reference?can u please explain with examples.is java supports Pass by r
no driver
i am having problem connecting to DB2 database fro netbeans: program: import java.sql.*; import java.lang.*; i
All Questions...

Comments

PHP SQL Number of Rows
To understand how to count the number of rows in a table, we have created a sql_num_rows.php file.

PHP SQL Number of Rows

This example illustrates how to count the rows of the table.

To understand how to count the number of rows in a table, we have created a sql_num_rows.php file. If you are not connected to the database, then create a connection first using mysql_connect("hostName", "userName", "Password") and mysql_select_db("databaseName", connectionObject). Now the query can be executed using mysql_query("SELECT * FROM tableName"). The number of rows are returned by the mysql_num_rows() method.

Table: users

Source Code of sql_num_rows.php


<?php

  $con = mysql_connect('localhost','root','root');

  if (!$con) {

    die('Could not connect: ' . mysql_error());

  }

  mysql_select_db("test", $con);



  $sql = "SELECT * from users";



  $res = mysql_query($sql);



  if (!$res) {

    print("SQL statement failed with error:\n");

    print(mysql_error($con));

  } else {

    $number_of_rows = mysql_num_rows($res);

    print("$number_of_rows rows found");

  }  

  mysql_close($con);

?>

Download Source Code

Output:

� View all related tutorials

Related Tags: sql mysql c data display group example salary to exam e il it spl use in m play clause isp

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.