SQL join url parameter issues

Hello everyone.

I have 3 tables in my database.

table_User

user_id (Primary key)

username

password

table_account

account_id

first_name

last_name

email

account_id_fk (foreign key) linked to the user_id on table_user

table_listing

item_id (primary key)

item_type

item_number

item_colour

item_id_fk  (foreign key) linked to the user_id on table_user

All users have a different Username and password to login to access individual account.

There is a link after users login to their account that will take users to item_view.php page using url

parameter.

I created a recordset with dreamweaver to join table_listing and table_account tables on the item_view.php

page as i want all columns in both tables to be accessible on the item_view.php page for each individual

user account.

I am using below sql

SELECT *

FROM table_listing, table_account

WHERE table_listing.item_id_fk  = table_account.account_id_fk

ORDER BY trxn_id ASC

below created in the variable column

name: colname

default value: -1

run-time value: $_Get['item_id_fk']

Issues:

when click test or ok, this error comes up

colname is an invalid variable name; it does not appear in the SQL

when i deleted the variable column, i was able test the recordset at it works well.

and I am able to retrieve all columns from the database as it is visible in the binding panel.

But i am not able to make different login users to view their individual specific account details.

What could be the variable name?

Do i have to add another variables in the field?

How do i go about this please