Level 102
You have users twice. Did you mean
SELECT users.* from users Inner Join students on students.user_id = users.id WHERE users.id = $loggedIN
Feb 1, 2023
10
Level 20
database sql query error?
code
$loggedIN = $_SESSION['id'];
$sql = "SELECT * users from users Inner Join students on students.user_id = users.id WHERE users.id = $loggedIN";
$data = mysqli_query($conn, $sql);
and error https://paste.pics/d0bdd014f4f9bb6678d41c803929790f
and i want to fetch alll the created data by the logged in users?
Level 20
@Sinnbeck no sir. in the image it shows after i removed it from the query .. You can see it on the $sql variable
Level 102
@Shivamyadav the query you posted is incorrect. Show the updated one if you fixed it
1 like
Level 55
It'd be nice to paste the error here instead of screenshots. syntax error in the SQL query: there is no "from" keyword after the asterisk (*).
The correct query should be:
$loggedIN = $_SESSION['id'];
$sql = "SELECT * FROM users INNER JOIN students ON students.user_id = users.id WHERE users.id = $loggedIN";
$data = mysqli_query($conn, $sql);
SELECT * FROM users
NOT
SELECT * users from
1 like
Level 20
@azimidev thanks sir ..
1 like
Level 55
@Shivamyadav Youre welcome buddy.
Level 20
@azimidev
can I know sir what is the difference between these two queries..
1 st one is showing error that unknown column 'users.id' in where clause
and 2nd query is working properly.. why
SELECT * FROM users INNER JOIN students ON students.user_id = users.id WHERE users.id = 15;
SELECT * FROM users INNER JOIN students ON students.user_id = users.id WHERE users.id = 15;
Level 55
@Shivamyadav i cant see any difference.
Level 20
@azimidev me also , but 1st one is not working how can be this possible ?
Level 102
@Shivamyadav they are 100% identical. Not a space or anything. So we are missing some information here. The code for how you are doing each?
Please or to participate in this conversation.