Join foutmelding
Weet iemand wat er in onderstaande code niet klopt?
Code (php)
1
2
3
2
3
<?php
$sql = "SELECT m.msg_id,m.msg_title,m.msg_from,m.msg_time,m.msg_message,u.user_name FROM tbl_msg AS m INNER JOIN tbl_users AS u ON u.user_id = m.msg_from ON m.msg_to = ".$_SESSION['user_id']." ORDER BY m.msg_id DESC LIMIT 5";
?>
$sql = "SELECT m.msg_id,m.msg_title,m.msg_from,m.msg_time,m.msg_message,u.user_name FROM tbl_msg AS m INNER JOIN tbl_users AS u ON u.user_id = m.msg_from ON m.msg_to = ".$_SESSION['user_id']." ORDER BY m.msg_id DESC LIMIT 5";
?>
Quote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON m.msg_to = 1 ORDER BY m.msg_id DESC LIMIT 5' at line 1
edit opgelost: (ON ipv AND)
Code (php)
1
2
3
2
3
<?php
$sql = "SELECT m.msg_id,m.msg_title,m.msg_from,m.msg_time,m.msg_message,u.user_name FROM tbl_msg AS m INNER JOIN tbl_users AS u ON u.user_id = m.msg_from AND m.msg_to = ".$_SESSION['user_id']." ORDER BY m.msg_id DESC LIMIT 5";
?>
$sql = "SELECT m.msg_id,m.msg_title,m.msg_from,m.msg_time,m.msg_message,u.user_name FROM tbl_msg AS m INNER JOIN tbl_users AS u ON u.user_id = m.msg_from AND m.msg_to = ".$_SESSION['user_id']." ORDER BY m.msg_id DESC LIMIT 5";
?>
Gewijzigd op 01/01/1970 01:00:00 door Yearupie Achternaamloos
Gesponsorde koppelingen:
Er zijn nog geen reacties op dit bericht.
