i have two user tables in my database. one is users table and another one is users records table, one user login id = one user record id how to get user records in user login page by login id in phpmysql
please help me,
Thanks in advance
Without seeing your table structure:
[php]
$stmt = $dbconn->prepare(“SELECT (whatever your want to select) FROM users
INNER JOIN records ON users.id = records.userid
WHERE users.id = :userid”);
$stmt->execute([
“:userid” => $_POST[‘userid’]
]);
[/php]