> visit sample site here: http://test.rowait.com/new/inventory.php > problem: i want to search two columns from one input field. you can > test it. > search for ie. 93 honda > and i should get all the results matching those two words (numeric as > well as alphanumeric). > so far, i can only search by typing a specific field, where LIKE in > mysql query has been used to match against possibilities. I'd suggest you look into using full-text searching with MySQL: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html -- Sarah Sweeney Web Developer & Programmer Portfolio :: http://sarah.designshift.com Blog, etc :: http://hardedge.ca