Hi there I've a problem with this query:
SELECT DISTINCT Hotel.Nome,Indirizzo, Categorie.Categoria FROM Hotel,
Servizi,Categorie, Hoteldetail WHERE Hoteldetail.IDHotel = Hotel.IDHotel AND Hoteldetail.IDServizio =
Servizi.IDServizio AND Hoteldetail.IDCategoria=Categorie.IDCategoria AND Servizi.IDServizio LIKE '3'
AND Categorie.IDCategoria LIKE '2'
this work fine but if I change IDServizio Like '$Servizio%' it doesn't work. The variable is given by php form.
thank you in advance
SELECT DISTINCT Hotel.Nome,Indirizzo, Categorie.Categoria FROM Hotel,
Servizi,Categorie, Hoteldetail WHERE Hoteldetail.IDHotel = Hotel.IDHotel AND Hoteldetail.IDServizio =
Servizi.IDServizio AND Hoteldetail.IDCategoria=Categorie.IDCategoria AND Servizi.IDServizio LIKE '3'
AND Categorie.IDCategoria LIKE '2'
this work fine but if I change IDServizio Like '$Servizio%' it doesn't work. The variable is given by php form.
thank you in advance