MySQL Matches.... please help me

[90Nz0]

Hello everyone, long-time-no-post..etc.

Anyway...

I have a search page that has a var part number ($pn), ie, "158223-b21". When people search for "158223-b21 " (with space), it doesn't show.

Is there a way of fixing it, or doing a 'relevent' match, so if they do "158223-b22 " it would still show (etc).

Cheers guys/gals.

I really apprechate your help.

Paul.

// Edit

Some people also leave out the dash and just put a space, ie, "158223 b21", could you also help me shove in the '-'.

Thanks again people, it's apprechated.

[90Nz0]

ltrim = remove white space from the left
rtrim = remove white space from the right

Sorry, worked it out myself.

[dalecosp]

Or, [man]trim/man; // removes whitespace from both sides

And then

$var=str_replace(" ", "-", $var);

to get your dash back in. Of course, that doesn't address the possibility that they've put more than one space in the middle of the number.

Your true best bet would probably to use regular expression matching to make sure they've done it right. But of course, if you do, they may think that whoever programmed the app was a tad bit too <$adjective> ....

[90Nz0]

lol, yeh.

I ended up doing this for all the rules...

$replacevarz = array("/", "\\", "\#", "$", "&", ",", "£", "%",  "\"", "!", ".");


$frmPartNumber = rtrim($frmPartNumber);
$frmPartNumber = ltrim($frmPartNumber);
// $frmPartNumber = str_replace($replacevarz, "", $frmPartNumber);
$frmPartNumber = str_replace(" ", "-", $frmPartNumber);
$frmPartNumber = str_replace($replacevarz, "-", $frmPartNumber);

$frmPartNumber = str_replace("-------", "-", $frmPartNumber);
$frmPartNumber = str_replace("------", "-", $frmPartNumber);
$frmPartNumber = str_replace("-----", "-", $frmPartNumber);
$frmPartNumber = str_replace("----", "-", $frmPartNumber);
$frmPartNumber = str_replace("---", "-", $frmPartNumber);
$frmPartNumber = str_replace("--", "-", $frmPartNumber);

(There is a '\' before the hash, but it isn't showing on this copy'n'paste)