Sortable Column Snippets

PHP code to add sortable column to WordPress in admin area .

Returns the text between the specified delimiters in MySQL.

Returns the text between the specified delimiters in MySQL.

Create in dbgrid one column and insert the caption "RecNo" or other in title property. In dbgrid onDrawColumnCell event insert the following code:

Toggle a column bit regardless of state. Useful to change state without doing a query first to detect the state of the bit.

12 July, 2012   

PHP MySQL code to select row randomly fast

27 August, 2011   

The <frame> tag defines one particular window (frame) within a frameset. In the example below we have a frameset with two columns. The first column is set to 25% of the width of the browser window. The second column is set to 75% of the width of the browser window. The document "frame_a.htm" is put into the first column, and...

Example for adding filter column to FilterControl, Devexpress controls

12 January, 2012   

Here shown a php code example how to associative Array by Column Name

Get number of paragraphs in column 2 and display that number in an alert box. Including the one in the red box.

Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )

Example code to update or convert the field to UPPERCASE.

11 October, 2012   

Python code example for Grid made by Label and Entry

An example of finding duplicate values in a table column

MySQL code to find all duplicates in a database column(s)n.

09 February, 2012   

Syntax for both the column and table aliases

02 January, 2012   

The ORDER BY keyword is used to sort the result set by a specified column.

21 September, 2011   

Selecting the maximum value of the column in the brackets.

SQL uses the MAX function to find the maximum value in a column.

22 December, 2012   

How to select a random row in MySQL