Получить данные из двух таблиц

[Black Fregat]

Сообщение от Shouldercannon

Тут совсем без вариантов?

Надо два раза ставить join, примерно так:

SELECT `treq`.`uid`, `tusr1`.`nick` AS `from`, `tusr2`.`nick` AS `executor`
       	 FROM `requests` AS `treq`
         LEFT JOIN `users` AS `tusr1` ON `tusr1`.`uid` = `treq`.`from`
         LEFT JOIN `users` AS `tusr2` ON `tusr2`.`uid` = `treq`.`executor`

[Shouldercannon]

Подскажите как вывести from два раза. Первый - это id в текущей таблице requests, а второе - это nick по id из таблицы users

SELECT `treq`.`uid`, `treq`.`from`, `tusr1`.`nick` AS `from`, `tusr2`.`nick` AS `executor`
       	 FROM `requests` AS `treq`
         LEFT JOIN `users` AS `tusr1` ON `tusr1`.`uid` = `treq`.`from`
         LEFT JOIN `users` AS `tusr2` ON `tusr2`.`uid` = `treq`.`executor`
echo $row['uid'].'~'.$row['from'].'~'.$row['from'].'~'.$row['executor'];

В таком случае на выходе будет: 1~cali~cali~illana
должно быть
1~7~cali~illana

[Black Fregat]

Вы же сами второй from делаете при помощи AS
Поставьте там какое-либо уникальное имя.
Или же первый from переименуйте, опять же, используя AS

[Shouldercannon]

Работает

SELECT `treq`.`uid`, `treq1`.`from` AS `id`, `tusr1`.`nick` AS `from`, `tusr2`.`nick` AS `executor`
       	 FROM `requests` AS `treq`
         LEFT JOIN `requests` AS `treq1` ON `treq1`.`uid` = `treq`.`from`
         LEFT JOIN `users` AS `tusr1` ON `tusr1`.`uid` = `treq`.`from`
         LEFT JOIN `users` AS `tusr2` ON `tusr2`.`uid` = `treq`.`executor`
echo $row['id'].'~'.$row['from'].'~'.$row['from'].'~'.$row['executor'];

[Shouldercannon]

Теперь точно гуд

$query = "SELECT `treq`.`uid`, `treq`.`from`, `tusr1`.`nick` AS `nick_from`, `tusr2`.`nick` AS `took`
       	 FROM `requests` AS `treq`
         LEFT JOIN `users` AS `tusr1` ON `tusr1`.`uid` = `treq`.`from`
	 LEFT JOIN `users` AS `tusr2` ON `tusr2`.`uid` = `treq`.`took`
	 WHERE `treq`.`uid` = '".$_GET['rid']."'";	
$result = mysql_query($query) or die ("ERROR: ".mysql_error());
if (mysql_num_rows($result) > 0) {
	while ($row = mysql_fetch_array($result)) {
		// Берём результаты из каждой строки
		echo $row['from'].'~'.$row['nick_from'].'~'.$row['took'];
	}
}