please help

Anon

Hi everyone,
I have a wierd problem that I would really appreciate advice/ help with (it is for an urgent project). My problem is that I have a mysql database which I am querying with variables generated by forms and text boxes on a html form. Howver, each of the variables generated by the form has an extra space at the beginning of the variable, which of course means the search doesn't work. Eg:
instead of searching
"%theft%" (same as the form value )
I get "% theft%"

any ideas thankfully recieved

Sam Price

Anon

I'm not sure why your forms are putting extra spaces in, that's rather stupid.

How about using str_replace to take the space out? or checking if it's a space first?

if (substr($string, 0, 1) == ' ') {
substr($string, 0, 1) == ''
}

then search for %$string%.

If the % is in already in the variable:

if (substr($string, 0, 2) == '% ') {
substr($string, 0, 2) == '%'
}

I'm can't remember exactly, but in substr the $string may go at the end (as the last arguement, not the first), so you should check the manual.

HTH,

Danny
http://MyBest50.com

rrijnders

Just use trim() before you use the variable in your search comparison. trim() will remove whitespace from beginning and end of input data.

-- Rich Rijnders
-- Irvine, CA US