how can i make a comprehensive search query?
Posted: Sun Jul 24, 2005 10:07 am
hi all,
can any body help me?
if have a table in mysql and a code of php that when the user enters the full name, the php code queries the table and returns the results in a web page.
if the user enters for example in the text box the name without putting spaces between the first and the last name it will get no results, cuz it is stored with a space between them..
my question is: how can i make the code get the results of the nonspaced characters and recognize them as spaced characters if the spelling is right as stored in the table???
can any body help me?
if have a table in mysql and a code of php that when the user enters the full name, the php code queries the table and returns the results in a web page.
if the user enters for example in the text box the name without putting spaces between the first and the last name it will get no results, cuz it is stored with a space between them..
my question is: how can i make the code get the results of the nonspaced characters and recognize them as spaced characters if the spelling is right as stored in the table???