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 | ||
</ | </ | ||