kytschBASIC

DSORT

Helps sort the results of a database query.

Example

DATA

	REM Open the database connection from the config file labelled kytschBASIC.

	DOPEN "kytschBASIC"



	REM Read from the menu table in the database.

	DREAD "menu"



	REM Select all entries from the menu table.

	DSELECT "*"



	REM Condition the select to those that aren't deleted.

	DWHERE "(slug=:header OR slug=:footer) AND deleted_at IS NULL"



	REM Bind the slug string to be used in the query.

	DBIND header="header", footer="footer"



	REM Sort the results by their name alphabetically.

	DSORT "name ASC"



	REM Fetch the results and assign them to menu variable.

	DFETCH menu&

END DATA



REM Loop through the results stored in menu& variable.

FOR item& IN menu&

	SWRITE

		PRINT item&("id")

		PRINT ": "

		PRINT item&("name")

	END SWRITE

NEXT

Output

Sort directions

ASC is ascending, i.e. A-Z

DESC is descending, i.e. Z-A

See also