---> Commands * include [filename] Executes the file 'filename' and continues execution of the current file. (Very usefull to keep settings of a bunch of sqlmeta-files in one file.) * print [text] Print the text [text]. * host [hostname] Set the hostname of the mysql server we will fire our queries at. * user [username] [password] Set the username and password used to authenticate to the mysql server. * db [database] Select a database on the mysql server. * info Spit out version info etc... * set [varname] {value} Set/unset variables. If a value is specified, it is stored as variable [varname]. Variables can be used anywhere with string ${varname}. If set is used without a value, the variable will be unset. * table [sql query] Create a table out of a sql query. It's just a 'standard' table, no fancy colors or blinking thingies. If you want it any other way, do it yourself with the 'with' directive. * query [sql query] Query the mysql server. Just dump any results the server returns. Could be used to insert something into a table or whatever else that doesn't need results. If you want results, use the 'table' or 'with' directive instead. * with [sql query] ... loop Query the mysql server. For every line of results the server returns the code between 'with' and 'loop' will be executed. The result-columns can be used as ${col1}, ${col2}, etc... * for [variable] in "txt1 txt2 txt3 etc foo bar..." ... next Executes all code between 'for' and 'next' with the variable [variable] set to 'txt1', then to 'txt2' etc... ---> Special things you can use in your code * ${environmentvarname} Will be replaced by variable 'environmentvarname' * ${col1} Will be replaced by the first column of the current query. (Works only inside a 'with' loop.) '1' can be replaced by any column number you like. * ${form_fieldname} If we have POST data from a html