Различные вопросы по PHP и MySQL

Koenig (18.02.2013 / 23:27)
Screamer, если без точки имя будет, возможно, но обычно проверки всякие и пишутся, ты проверил?
$f = '1.exe';
echo end(explode('.', $f));

$get_history = $this->db->query(
"SELECT `h`.`time`, `h`.`value`, `h`.`comment`, "
. "`u_f`.`nickname` AS `from`, `u_t`.`nickname` AS `to` "
. "FROM `module_balance_history` AS `h` "
. "LEFT JOIN `users` AS `u_t` ON `u_t`.`id` = `h`.`to`"
. "LEFT JOIN `users` AS `u_f` ON `u_f`.`id` = `h`.`from` "
. "WHERE `h`.`from` = '" . $this->user->id . "' OR `h`.`to` = '" . $this->user->id . "' "
. "ORDER BY `time` DESC "
. "LIMIT " . $limit['start'] . ", " . $limit['end']
);

Koenig (19.02.2013 / 19:07)
Screamer, два раза users разве канает?

. "LEFT JOIN `users` AS `u_t` ON `u_t`.`id` = `h`.`to`"
. "AND `u_f`.`id` = `h`.`from`

. "LEFT JOIN `users` AS `u_t` ON `u_t`.`id` = `h`.`to`"

. "LEFT JOIN `users` AS `u_t` ON `u_t`.`id` = `h`.`to` "

$get_history = $this->db->query(
"SELECT `h`.`time`, `h`.`value`,`h`.`comment`, "
. "`to`.`nickname` AS `to`, `from`.`nickname` AS `from` "
. "FROM `module_balance_history` AS `h` "
. "LEFT JOIN `users` AS `to` ON `h`.`to` = `to`.`id` "
. "LEFT JOIN `users` AS `from` ON `h`.`from` = `from`.`id` "
. "WHERE `h`.`to` = " . $this->user->id . " OR `h`.`to` = 0 "
. "OR `h`.`from` = " . $this->user->id . " OR `h`.`from` = 0 "
. "ORDER BY `time` DESC "
. "LIMIT " . $limit['start'] . ", " . $limit['end']
);