servername

1.0.0

Mysql server

dbname

1.0.0

Database name

user

1.0.0

User name

password

1.0.0

Password

selectquery

1.0.0

Query used to retrieve the rows to show. Notice the 'where '. If you don't add condition (i.e 'where id>1'), you must add the 'where' without any other condition (the module append to it the condition that it get from the search box).
If you add some conditional statement you must end the statement with 'and' (i.e '... where id>1 and ') to allow to append the required search patterns.

selectcount

1.0.0

Query used to retrievethe number of the rows to show. It has the same rule about the 'where ' statement as 'selectquery'

Ignored in Yap 1.1.0

orderfield

1.0.0

Field to use to order the rows it must 'selected' from 'selectquery'

orderdirection

1.0.0

Order direction: A=upward, D=descending

needopendb

1.0.0

Should the module open the connection to the database? (true/false). This parameter is useful if you make some temporary table so you need to open the connection inside the caller script and the module must not open its own connection to the database.(Optional, default: true)

db_class

1.2.0

Class to use to connect to the database. Must be a class that extends CYapDb. (Optional, default: CYap_Mysql)