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! Quote Link to comment 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... Quote Link to comment 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;"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.