I have the following code which will display all transactions for a given user. In the transactions table there's a users_id column which has got a bunch of numbers in it which relate to user names in the users table, but how do I write the code without having to manually look up the ??????? user_id in the users table? Thanks.
$transactions_query = "SELECT * FROM transactions WHERE users_id = ?????? ";