search only retreives from first letter of the record

christL

Being new to this whole PHP/SQL thang I need help getting my search to look past the first word in the column and still retrieve the record even if the keyword is the 10th word in.

Does that make sense ???😕

Eg.

The keyword MASSAGE is typed into the form.

The results page looks to = MASSAGE to the $field but because MASSAGE is the 2nd word in it dosen't retrieve the record.

CODE:

$varTreat_rs2 = "Massage";
if (isset($Treatments)) {
$varTreat_rs2 = (get_magic_quotes_gpc()) ? $Treatments : addslashes($Treatments);
}

is this sonething to do with ARRAYs instead of STRINGS ???

HELP PLEASE !!!!!!!!

christL

OhLordy

What does your query look like. It should be something like this
SELECT [columns] FROM [tables] WHERE [column] LIKE '%$input%'

see?
HTH
Rob

christL

SELECT spa.Spa Name, spa.SpaType, spa.Spa of Distinction, spa.City or Town, spa.State, spa.Description, spa.Image, spa.Region
FROM spa
WHERE spa.State LIKE 'varState%' AND spa.Accomodation = 'varType' AND spa.Region = varRegion

There'tis🙂

thanks for your time

christL

ps: what is that image in your profile.... ?

kevinsequeira

SELECT spa.Spa Name, spa.SpaType, spa.Spa of Distinction, spa.City or Town, spa.State, spa.Description, spa.Image, spa.Region
FROM spa
WHERE spa.State LIKE 'varState%' AND spa.Accomodation = 'varType' AND spa.Region = varRegion

where do you search for $varTreat_rs2 in this query ??

reg
kevin

OhLordy

Poi, checkout this site http://www.homeofpoi.com

Hope you're not scared of fire 😃
Rob

christL

thanks kevin - i accidently pasted the code from the previous results page

heres the right code

SELECT spa.Spa Name, spa.SpaType, spa.Facilities, spa.Treatments, spa.Image, spa.City or Town, spa.Spa of Distinction
FROM spa
WHERE spa.Treatments LIKE 'varTreat%' AND spa.Region = varRegion
ORDER BY spa.Spa of Distinction

christL