X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_holiday.php;h=4db1e7553ffcba80d4bed4c31deb4a854a0e78b9;hp=713b45fcf497d2fc52ffee346a2e625c70c5ffa1;hb=c47144dd555bbab4acdf9085e4623900dedb0e7c;hpb=6c763653e88b9d10627e651ca59c7201d4b7d62b diff --git a/inc/modules/admin/what-list_holiday.php b/inc/modules/admin/what-list_holiday.php index 713b45fcf4..4db1e7553f 100644 --- a/inc/modules/admin/what-list_holiday.php +++ b/inc/modules/admin/what-list_holiday.php @@ -42,8 +42,8 @@ ADD_DESCR("admin", __FILE__); // Start listing holiday requests $result = SQL_QUERY("SELECT h.id, h.userid, h.holiday_start, h.holiday_end, h.comments, d.status, d.last_online -FROM "._MYSQL_PREFIX."_user_holidays AS h -LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS d +FROM `{!_MYSQL_PREFIX!}_user_holidays` AS h +LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d ON h.userid=d.userid ORDER BY h.userid", __FILE__, __LINE__);