// Start listing holiday requests
$result = SQL_QUERY("SELECT
- h.`id`,
- h.`userid`,
- h.`holiday_start`,
- h.`holiday_end`,
- h.`comments`,
+ `h`.`id`,
+ `h`.`userid`,
+ `h`.`holiday_start`,
+ `h`.`holiday_end`,
+ `h`.`comments`,
`d`.`status`,
`d`.`last_online`
FROM
LEFT JOIN
`{?_MYSQL_PREFIX?}_user_data` AS `d`
ON
- h.`userid`=`d`.`userid`
+ `h`.`userid`=`d`.`userid`
ORDER BY
- h.`userid` ASC", __FILE__, __LINE__);
+ `h`.`userid` ASC", __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// List all holiday requests