mcubedma Posted September 22, 2007 Share Posted September 22, 2007 I'm sure this is not a hard thing to do, but for some reason I can't get my mind to figure this out. I have a database with Name, Address, and Car Type tables. I'm just trying to do a simple php form to allow the user to enter part of a last name and/or part of a first name to display the data in the tables. My brain has twisted around this and I cannot figure it out. Can you please help? Thanks! Link to comment https://forums.phpfreaks.com/topic/70269-need-help-with-search-form/ Share on other sites More sharing options...
rarebit Posted September 22, 2007 Share Posted September 22, 2007 If it's for a search use 'LIKE', otherwise if it's autocomplete, use either js and clientside copy of db(!) or use AJAX... Link to comment https://forums.phpfreaks.com/topic/70269-need-help-with-search-form/#findComment-352924 Share on other sites More sharing options...
dewey_witt Posted September 22, 2007 Share Posted September 22, 2007 $sql="Select * from $table where LName is LIKE "%.$request.%" limit 1;"; Link to comment https://forums.phpfreaks.com/topic/70269-need-help-with-search-form/#findComment-352976 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.