BillyBoB Posted July 14, 2006 Share Posted July 14, 2006 [code]<?phpif($_POST[submit]) {$query = mysql_query("SELECT * from profile where username = '$_GET[user]'") or die(mysql_error);$profile = mysql_fetch_array($query);$aim = $_POST[aim];$msn = $_POST[msn];$yim = $_POST[yim];$website = $_POST[website];$gender = $_POST[gender];$age = $_POST[age];$location = $_POST[location];if($aim==NULL|$msn==NULL|$yim==NULL|$website==NULL|$gender==NULL|$age==NULL|$location==NULL){echo("You have left a spot empty!");}else{$query = mysql_query("UPDATE profile SET (aim = '$aim',msn = '$msn',yim = '$yim',website = '$website',gender = '$gender',age = '$age',location = '$location') WHERE username = '$logged[username]'");}}?>[/code]i try to use this but it does't work can u help me? Link to comment https://forums.phpfreaks.com/topic/14559-error-maybe-its-not-sending-to-the-db/ Share on other sites More sharing options...
toplay Posted July 14, 2006 Share Posted July 14, 2006 Change the bitwise operator | to the logical or operator of || in your "if" statement. See:http://us2.php.net/manual/en/language.operators.logical.phpTake out the left and right parenthesis in the UPDATE. See:http://dev.mysql.com/doc/refman/4.1/en/update.html Link to comment https://forums.phpfreaks.com/topic/14559-error-maybe-its-not-sending-to-the-db/#findComment-57784 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.