Re: Apostrophe in preg_match?

Thanks DL, I've read that part of the manual. My original syntax was as you suggested [^a-zA-Z-'], but the PostgreSQl query barfed on the apostrophe. The preg_match works, but the db refuses to accept the apostrophe. Reading the postgresql docs, they suggest escaping the character, but since the variable is contained in $_POST['ssname'] I don't know how to get the escaped character inserted into this POST'd variable. After the validation check : if (!preg_match("^[a-zA-Z-/\'/]^", $_POST['ssname'])) die . . . . . the POST'd variable is transformed: $_POST['ssname'] = ucwords("{$_POST['ssname']}"); $_SESSION['ssname'] = $_POST['ssname']; $_SESSION['ssname'] = ucwords("{$_SESSION['ssname']}"); and then inserted into the db: "INSERT INTO sponsor (sid, sfname, ssname, . . . '{$_SESSION['ssname']}', . . . . So, how would I get this escaped character into the db? Any further help would be greatly appreciated. I'm stumped on this one. Perhaps, I'll have to exclude apostrophes, but there must be a way?? Tia, Andre On Wednesday 28 August 2002 06:16 am, DL Neil wrote: > > I'm trying to get an apostrophe (and a dash, as well) to be > > included in a preg_match expression, but I don't know how to escape the > > characters. > > The manual discusses which characters need escaping and how to escape > characters: > http://www.php.net/manual/en/pcre.pattern.syntax.php > > > <?php > > if (preg_match("^[!a-zA-Z-/\\\'/]^", $_POST['ssname'])) die > > ("<h5>Numbers and special characters not allowed in > > 'Surname'<br><br> > > Click 'Back' on your browser to re-enter > > information.</h5>"); > > > > ?> > > Any help will be greatly appreciated. > > Keep it simple: [^a-zA-Z-'] > > Regards, > =dn