SQL Tables

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Warning: Use of undefined constant Tooltip - assumed 'Tooltip' (this will throw an Error in a future version of PHP) in /home/u894969250/domains/abbydalesystems.com/public_html/SQLPaging.php on line 39

Name	Description
CountEntries Totaling records from multiple tables in a database.	This is an example of how to count total records in multiple tables using selection criteria. The tables must reside in the same database, but the table names can be different. You can also omit the selection criteria and get a total for the entire table.
LastUpdate How to add the last updated field to a table.	How to add a last updated field to an existing table. This is useful if your database system doesn't hold statistics. This will work regardless.
tblCounty Link to a list of UK Counties	This is a list of all the counties in England prior to 1965's reorganisation.
tblDistrict Link to a list of UK registration districts	This table contains a list of all the registration districts and counties in England prior to 1968 It can be used to obtain just a list of English counties by using the following SQL: "SELECT DISTINCT County FROM 'tblDistrict'"
tblLanguage Link to a table of all the world languages	This is a list of all the world languages along with their ISO 639-1 two digit code. If you need the three digit codes then we recommend Github
tblUSCounty Link to all US counties and parishes	This is a SQL Table of all the counties (and Parishes) in the USA.

Page #1  

If you need any support or assistance with any of the code on this site
or
if you would just like to contact us, please click here


Follow us on Facebook