- This topic is empty.
Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
- The forum ‘Back End’ is closed to new topics and replies.
The forums ran from 2008-2020 and are now closed and viewable here as an archive.
I have two tables, table1 and table2.
I need to select all records in table1 where
table1.name = ‘$name’
and where table1.id = table2.id {
table2.url_key = ‘google’
and
table2.url_key = ‘$url’}
do you know how this would be constructed to be a valid query?
cheers
can you give the structure of both tables and explain which values you want out of both tables?
all the fields are varchar and I want to be able to select all the values and records in table1 based on the criteria
Thanks
ill give it a shot, but i kinda need more info:
the only problem is .. how can `table2`.`url_key` be $url AND google at the same time??
sorry, my fault. One of the key’s meant to be ‘value’. But anyway, your code works.
thanks