This shows you the differences between two versions of the page.
| linuxmce_sql_queries [2014/01/04 23:18] – created admin | linuxmce_sql_queries [2014/01/04 23:36] (current) – admin | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| < | < | ||
| SELECT PK_Room FROM Room ORDER BY PK_ROOM Limit 1; | SELECT PK_Room FROM Room ORDER BY PK_ROOM Limit 1; | ||
| + | </ | ||
| + | |||
| + | **Description** | ||
| + | |||
| + | < | ||
| + | SELECT Description FROM Room WHERE PK_Room = $currentRoom | ||
| </ | </ | ||
| Line 17: | Line 23: | ||
| < | < | ||
| SELECT PK_Users FROM Users ORDER BY PK_Users Limit 1; | SELECT PK_Users FROM Users ORDER BY PK_Users Limit 1; | ||
| + | </ | ||
| + | |||
| + | |||
| + | **Description** | ||
| + | |||
| + | < | ||
| + | SELECT UserName FROM Users WHERE PK_Users = $currentUser | ||
| </ | </ | ||