Tag Archive for 'MySQL'

How to Get the Number of Rows in a MySQL Result Resource Using PHP

MySQL is a flexible database engine, and today I’m going to discuss ways to fetch the number of rows in your MySQL result resource. The first thing I want to mention is MySQL’s built-in function COUNT(field_name). Using this function you can easily get the quantity of results for a certain condition. This would be used [...]

MsSQL Version of “Show Tables”

MySQL has an easy command that places a list of all tables found within the active database into the result set. I have recently been working on a project for my job which requires me to use MsSQL as the database. I find MySQL and MsSQL to be very similar in terms of syntax, but [...]