ccrevcypsys Posted November 14, 2007 Share Posted November 14, 2007 So i am getting this error when ever i try to run this input code <?php $mail["sending_cust"] = $ccUserData[0]['customer_id']; $mail["recieve_cust"] = $_GET['customer_id']; $mail["subject"] = "Friend Request With ".$ccUserData[0]['screenname']; $mail["message"] = "<div style='width:250px; float:left;'> <p class='minititle' style='width:230px;'>Friend Request From:</p> <div style='width:249px; float:left; border:#000000 1px solid; background:#003399;'> <span style='float:left; width:100%; font-size:18px; '>".$ccUserData[0]['screenname']." </span> <span style='float:left;'><img src='".$ccUserData[0]['cust_image']."' title='".$ccUserData[0]['screenname']."' /></span> <span style='float:right; margin-top:-5px;'><a href='index.php?act=addFriend&friend=accepted&customer_id=".$ccUserData[0]['customer_id']."' class='txtviewCart' style='padding:25px 23px; float:left;'>Yes</a> <a href='index.php?act=addFriend&friend=denied&customer_id=".$ccUserData[0]['customer_id']."' class='txtviewCart' style='padding:25px 23px; float:left;'>No</a></span> <span style='float:left;'>If you happen to press no they will not be able to invite you again. <Br /> You will have to invite them instead!</span></div></div>"; $mail["friend_req"] = "1"; $Mail = $db->insert($glob['dbprefix']."Mail", $mail); if($Mail==TRUE){ $addFriend->assign("TXT_NAME",$query[0]['screenname']." will recieve a message regarding your request. And You will be notified when they add you as a friend!"); }else{ $addFriend->assign("TXT_NAME","Sorry this has faild please try again..."); } ?> MySQL Error Occured n1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Request With No NaMe 3000, n QUERY = INSERT INTO cc_Mail (`se di g_cust`, ` ecieve_cust`, `subject`, `message`, `f ie d_ eq`) VALUES (30, 32, F ie d Request With No NaMe 3000, F ie d Request F om: No NaMe 3000 Yes No If you happe to p ess o they will ot be able to i vite you agai . You will have to i vite them i stead! , 1); n Quote Link to comment Share on other sites More sharing options...
ccrevcypsys Posted November 14, 2007 Author Share Posted November 14, 2007 sorry about the double post there was an error! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.