Having some trouble understanding this .....query updates when string doesn't contain an apostraphe in the text input fields, hoever if a (apostraphe ' ) is entered in a text field the query doesn't update .....confused how do I overcome?
Thanks
$q1 = "update class_members set password = '$_POST[p1]', FirstName = '".$_POST[FirstName]."', LastName = '".$_POST[LastName]."', Address = '".$_POST[Address]."', City = '".$_POST[City]."', State = '$_POST[State]', ZipCode = '".strip_tags($_POST[ZipCode])."', Country = '$_POST[Country]', Phone = '".strip_tags($_POST[phone])."', AlternatePhone = '".strip_tags($_POST[AlternatePhone])."', Fax = '".strip_tags($_POST[Fax])."', email = '".strip_tags($_POST[email])."', news = '$_POST[news]', crawl = '$_POST[sengine]', plock = '$_POST[lock]', map = '$_POST[map]', search = '$_POST[search]', salary = '$_POST[salary]', occupation = '".$_POST[occupation]."', interests = '".$_POST[interests]."', clubs = '".$_POST[clubs]."', adore = '".$_POST[adore]."', abhor = '".$_POST[abhor]."', drink = '".$_POST[drink]."', party = '".$_POST[party]."', otherinfo = '".$_POST[otherinfo]."' where MemberID = '$_SESSION[MemberID]' ";
mysql_query($q1);
