Does any1 know how 2 search for a contain keyword in an MySQL database using PHP.
For example if i search for ummmm lets say "fo" then it would display everything which has those letters in it like "fo"rd or "fo"cast.
I already have a piece of the code: $result = mysql_query("SELECT * FROM tablename WHERE columnname = \"$textboxname\",$db); except for that one little command.
i've been trying 2 figure it out for months with no luck, if anybody knows how, could u please reply
QA means Quality Assurance NOT Question & Answer.
If you´ve general questions regarding use, installation and configuration of PHP, please contact php-general@lists.php.net or
subscribe at php-general-subscribe@lists.php.net.
Anyway this is an SQL question, read about the "LIKE" command (usage: select text from tablenmae where text columnname LIKE 'fo%')
Thanks for using PHP.
--
· André Langhorst · t: +49 571 3201801 ·
· waldschrott@php.net · m: +49 173 9558736 ·
· PHP Quality Assurance · http://qa.php.net ·