home gear home donate
Search Results For

Libraries book

HTML Library CSS Library JavaScript Library PHP Library


PHP and MySQL JavaScript HTML and CSS Vector and 3D Flash Actionscript Android Dev Miscellaneous


Website Hosting Developer Q+A
Sprite Programming Mastery
Obtain a Table Row Count
The most efficient way to count rows in a database table is by using SQL's COUNT() syntax in your query. It is made for counting. You can then use the mysql_fetch_row function to obtain the amount from the COUNT() query. You can target the data you want to count within your query using the WHERE clause and assign what the field's value must equal in order to be counted.

Using mysql_fetch_row and COUNT() to count rows in a MySQL database table:
Learn HTML
// include your MySQL database connection script here
require_once "connect_to_mysql.php";
// Build sql command
$sqlCommand "SELECT COUNT(*) FROM members"
// Execute the query here now 
$query mysql_query($sqlCommand) or die (mysql_error()); 
// Access the count using mysql_fetch_row
$row mysql_fetch_row($query);
// output the value we want
echo "There are " $row[0] . " people in my members table.";
// Free the result set 
// close mysql connection 

Develop PHP browser display window
There are 3 people in my members table.

Home   •   Terms of Use   •   T-Shirts   •   RSS   •   Testimonials   •   Subscribe   •   Classroom Chalkboard   •   Developer Q+A   •   Donate   •   Top ↑
Popular In PHP / MySQL E-Commerce Store Production
Social Network Website Building
Image Upload / Photo Processing
CMS Software Programming
Mass Email Systems
Magic XML Data
Search Programming
Popular In JavaScript JSON Programming
Ajax Programming
Animating Elements
WYSIWYG Programming
Date/Time Programming
DOM Scripting
Object Reference
Popular In HTML Canvas Element
New Form Elements
Audio Element
Video Element
Drag and Drop
Event Handling
Element Grouping
Popular In CSS Custom Font Embedding
Dynamic Fit Backgrounds
Theatre Mode
Box Overlays
CSS Level 1 Properties
CSS Level 2 Properties
CSS Level 3 Properties is a growing educational system packed with video and written material that you can access 24/7 100% free. The focus here in 2014 is spread between five technologies: HTML, CSS, JavaScript, PHP and MySQL. Learn programming theory, database interaction, web design, animation, graphics editing, vector art, 3D modeling, and much more. The educational experience here is a hybrid one offering both high quality video tutorials and code libraries that grow more robust every day. The code libraries are being assembled so that developers can discover all of the building blocks of their favorite languages. The libraries coupled with high quality video tutorials will take you deep down the rabbit hole very quickly. You can also ask questions and get free advice at