[dogman73]

$renew = mysql_query("SELECT product FROM table WHERE productcode = '$sku'")or die(mysql_error());
$row1 = mysql_fetch_array($renew);
$update = $row1[0];
if (preg_match("/$mpn/i", $update)) { $doit = "N";
} else { $doit = "";
}

The problem I'm having is that sometimes $mpn is indeed contained in $update but special characters will cause it not to match. Any ideas?

This post has been edited by Dormilich: 24 September 2012 - 10:37 PM
Reason for edit:: please use [code] [/code] tags when posting code

[Dormilich]

dogman73, on 25 September 2012 - 03:40 AM, said:

The problem I'm having is that sometimes $mpn is indeed contained in $update but special characters will cause it not to match. Any ideas?

I don’t see any relation between the two variables. there shouldn’t be anything working.

[dogman73]

$mpn comes from a csv feed it is compared to the stored product title which is stored in MySQL db. Works 90% of the time but if $mpn contains special characters, particularly / and others it returns a no match when indeed $mpn matches within string var $update.

[dogman73]

Yes

[Dormilich]

dogman73, on 25 September 2012 - 09:07 AM, said:

particularly / and others it returns a no match when indeed $mpn matches within string var $update.

well, obviously. a / prematurely closes your regular expression.

use a RegExp delimiter you don’t have in that variable.

[Atli]

dogman73, on 25 September 2012 - 07:07 AM, said:

$mpn comes from a csv feed it is compared to the stored product title which is stored in MySQL db.

You don't really have to do the comparison in PHP. MySQL can also do that. It has a LIKE operator for simple string comparisons, and a REGEXP operator for regular expression tests.

[dogman73]

Dormilich, on 25 September 2012 - 12:54 AM, said:

dogman73, on 25 September 2012 - 09:07 AM, said:

particularly / and others it returns a no match when indeed $mpn matches within string var $update.

well, obviously. a / prematurely closes your regular expression.

use a RegExp delimiter you don’t have in that variable.

Well of course it would be that easy. Thanks!