A Minus B Query Snippets

23 March, 2016   

Get contents of table where the item does NOT exist in another table.

14 September, 2013   

An example for MySQL Results To Array

10 October, 2012   

This query will return the amount of records for the query

This is an example for Form Based Query

Basic Database Connection, Random Query, Display Result

20 October, 2012   

Create dynamic variables from a query or a list.

Note that to add a new column to the query, just add in an input box to the HTML, the PHP generates an insert for each field.

14 March, 2013   

PHP code example to process MySQL Timestamp

07 December, 2013   

Example code for Oracle Cursor Query

This is a very handy query that sorts your tables by their physical size in megabytes. Just be sure to edit the query to include the database name.

23 October, 2012   

MySQL code example for sorting data in a GRID

PHP & Mysql based code to Print table with client-side sorting function.

16 March, 2014   

How to create mysql table using php. The php script as follows as:

An example code to restore MSSQL database from backup

31 December, 2011   

MySQL's MAX aggregate function will find the largest value in a group. here shown an example

31 October, 2011   

It is a class file which can export to excel. simply call the function and give sql Query and sql connection.

24 September, 2012   

Connects to a database, and runs a query

05 April, 2015   

A simple PHP script that outputs data into formatted columns.

01 October, 2013   

This class has lots of common functionality built right into it. It also supports Mysql and Sphinx.

02 March, 2013   

Java code example shown here how to convert a number to words