PHP SQL - How to select fields form two tables, where one is containing some text+field form ot

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to select fields form two tables, where one is containing some text+field form ot

filipwitczak@gmail.com

2007-10-01, 7:07 pm

I have a problem - I need to select fields from two tables, where
field form table1 contains text + table2.id + text.

I have table reservations which has clients field. clients contains
client's id (taken from table2) with client's options. It's syntax is
like

|61=[49!130]&[50!15]|62=[49!130]&[50!15]|
where each |client.id=[option.id!value]&[option.id!value]|

the problem is that I need to secect specific reservation which
contains a client's data within one select statement.

So, I thought that it will be like

select * from reservations,clients where reservations.clients like
'%|' + client.id +'='

but I do not know sql so good to solve the probem and I do not know
how to google it (my native language is polish so every query I did to
google gave me carp results)

I would be grateful for any help.

regards
Filip W.

Sponsored Links