lazysheepmedia
Member
Folks
I have a database join where I have my properties listed - How can I display only the one that are available?
Would I need to add a yes/no (or another) element and then filter using that element on the db join element?
I have added this query but I am getting a 1054 error (unknown column)
The first table where I get my properties from is called properties ( filtered by {$my->id} ) and the second where I am trying to get the yes/no value is called tenancies
Any ideas why this would be is appreciated as always
I have a database join where I have my properties listed - How can I display only the one that are available?
Would I need to add a yes/no (or another) element and then filter using that element on the db join element?
I have added this query but I am getting a 1054 error (unknown column)
The first table where I get my properties from is called properties ( filtered by {$my->id} ) and the second where I am trying to get the yes/no value is called tenancies
PHP:
WHERE {thistable}.properties_userid = {$my->id} AND tenancies.tenancy_avail_yesno = 0
Any ideas why this would be is appreciated as always