search Text area boxes is it possible
Posted: Fri Apr 13, 2007 4:04 am
Normally when I search for a record I simply search a field that contains a single value - like so:
But I am planning on using some large text areas to make genereal notes, I understand that the data will still be inserted into a normal field BUT
How difficult will it be to search for any text in this field, when I say 'any text' I mean any word,number,value which is stored in the fiield.
Maybe I am making this more complex than what it is. Please advise
Code: Select all
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$query = "SELECT
orgname, web_url,sector,org_id,person_id,
notes
FROM organisations
WHERE orgname LIKE '$formVars[orgname]%'";How difficult will it be to search for any text in this field, when I say 'any text' I mean any word,number,value which is stored in the fiield.
Maybe I am making this more complex than what it is. Please advise