yet another quotation problem (kinda general)

Hi all.. as almost any1 in here i happen to have variables to be inserted intoa DB (postgres in this case) and need proper escaping if i want the whole thing not to break down if a ' character comes in.. this is usually automatically done by php4 if a variable is posted from a FORM. .. but i have a function (logging function) that needs to work property with both preescaped and non escaped variables. How to do this? by recognizing wether a variable has been escaped already! I have quickly come up with this thing here to check just this here is the function function StrtoDBStr($string) { if (!ereg("[^\\\\]'",$string)) { echo "YES"; } else {echo "NO!";}; }; .. but it is of course not well functioning since it will not handle the case where a \ has been already escaped before .. IE this will return true (since, according to the regex, there are no ' that dont have a \ infront) while it is clearly not a valid "DB string": it\\'s an example Any1 can hack in a better regex to check for \\ \\\\ etc? (it appairs all the even number of \\ are to be considered not valid) or maybe some other routine? am i the only one with this problem ? :) Thanks! Sincerely Giovanni Tummarello tummarel@ascu.unian.it Fight Spam! Join CAUCE (Coalition Against Unsolicited Commercial Email) at http://www.cauce.org/ and tell your Congresspeople how Spam mailings hurt you. Help protect genuine Internet commerce: Outlaw UCE Spamming.