Code Forums - View Single Post

trevor · 02-23-2007, 05:26 PM

Hi everyone,

I'm back

Yeah, I am having a little trouble getting a basic search engine working on a website that I'm building.
I got one working where it is only looking for a single word, ie.

search by city - user enters "toronto",

and I have a line:

$query = "SELECT * FROM users WHERE city LIKE 'search' order by Id";

and that works fine because I only have to search one field with one word.

But I need to add a search engine that searches for users by first and last name.

So say someone enters 'John Smith' and my database is set up where the users name is stored under 'first' and 'last'.

Sorry my PHP is pretty rusty, I played around with it a fair bit a few years ago (some people here may remember me), but anyways I took on a little project to I have to learn it all again :-)

I hope that makes sense.

thanks,
Trevor

02-23-2007, 05:26 PM	#1 (permalink)
trevor Code Monkey Join Date: Jan 2003 Location: Canada Posts: 91	basic search engine with PHP Hi everyone, I'm back Yeah, I am having a little trouble getting a basic search engine working on a website that I'm building. I got one working where it is only looking for a single word, ie. search by city - user enters "toronto", and I have a line: $query = "SELECT * FROM users WHERE city LIKE 'search' order by Id"; and that works fine because I only have to search one field with one word. But I need to add a search engine that searches for users by first and last name. So say someone enters 'John Smith' and my database is set up where the users name is stored under 'first' and 'last'. Sorry my PHP is pretty rusty, I played around with it a fair bit a few years ago (some people here may remember me), but anyways I took on a little project to I have to learn it all again :-) I hope that makes sense. thanks, Trevor