Happy Codings - Programming Code Examples

Php Programming Code Examples

Php > Code Snippets

Count and display the number of rows in a mysql database table



Count and display the number of rows in a mysql database table

<?php
Connect to the databasedb_connect();
// Query the database and get the count$result = mysql_query("SELECT * FROM tablename");
$num_rows = mysql_num_rows($result);
// Display the resultsecho $num_rows;?>

Challenges are what make life interesting and overcoming them is what makes life meaningful.

Joshua J. Marine

Disciplining yourself to do what you know is right and important, although difficult, is the high road to pride, self-esteem, and personal satisfaction.

Brian Tracy

I never teach my pupils, I only attempt to provide the conditions in which they can learn.

Albert Einstein

The most important thing is that sometimes you have to go through hard times to get to the good stuff.

Abby Wambach

Change will not come if we wait for some other person or if we wait for some time. We are the ones we've been waiting for.

Barack Obama

Success is the sum of small efforts, repeated day in and day out.

Robert Collier

If we could all just laugh at ourselves, in hard times or good times, it would be an incredible world.

Jena Malone

Anyone can hide. Facing up to things, working through them, that is what makes you strong.

Sarah Dessen