search help

OKAY so I was wondering what the problem is here.

i try this



$query_in is select * from users, and the other variables jsut set up for page settings.

they work because I can do this without the search.

when I search though, I get an error.

it is echoing out the proper variable. Is something wrong with this?

and I really just want to get a search page done. I have posted on this before... and got responses, and they were good, but I jsut can't figure out where to begin. Well I have begun, but,...

I am passing the variables though the url, so do i jsut do a query for each variable passed and in each combination? that seems so difficult. Any suggesations would be great. But the firs step is figureing out why my basic search wasn't working.
thanks guys

Try removing the comma after the limit 0 part.

You probably need quotation marks around your search value, outside the percent signs. Also, I'd recommend actually not removing the comma after 0. It's there because you're expecting a value in $perpage. If you remove the comma (by, say, prepending it to the $perpage value) and $perpage isn't passed, you'll just get no results, since you'd be limiting your result set to 0. If you leave the comma where it is, at least you'll get a syntax error if $perpage isn't passed. Or, of course, you could add some code above the query that tested for $perpage and rewrote the LIMIT statement according to what you got. That'd probably be the best thing to do.

Looks like dhouston is right... I didn't catch the

once again you guys rock. I really should have seen that gosh. sorry to post to hastily. :P