TalkPHP - View Single Post

buildakicker · 07-29-2009, 08:08 PM

Hi all,

I have simple form that puts data into a DB table. For some reason, it always gives me two entires. I cannot find why it would do that in the code anywhere. Here's my snipit:

PHP Code:


			
if(isset($_POST['go'])){

   $atitle   =    mysql_real_escape_string($_POST['articleTitle']);

   $abody =    mysql_real_escape_string($_POST['articleBody']);

   $acategory =    mysql_real_escape_string($_POST['articleCategory']);

   $atags =    mysql_real_escape_string($_POST['articleTags']);

   $aauthor =    mysql_real_escape_string($_POST['articleAuthor']);   

   $alink =    mysql_real_escape_string($_POST['articleLink']);

   

   

   if(!get_magic_quotes_gpc())

   {

      $atitle   = addslashes($atitle);

      $abody   = addslashes($abody);

      $atags   = addslashes($atags);

   }

   include 'config.php';

   include 'opendb.php';



   $query = " INSERT INTO jf_posts (title,bodytext,category,tags,author,link) ".

            " VALUES ('$atitle', '$abody', '$acategory', '$atags', '$aauthor', '$alink')";

   mysql_query($query) or die('Error ,query failed');



   include 'closedb.php';



   echo "<div id='topbar' align='center'>Article '$title' added!</div>";

}

07-29-2009, 08:08 PM	#1 (permalink)
buildakicker The Acquainted Join Date: Jan 2008 Posts: 119 Thanks: 21	What is causing Duplicate Entries Hi all, I have simple form that puts data into a DB table. For some reason, it always gives me two entires. I cannot find why it would do that in the code anywhere. Here's my snipit: PHP Code: if(isset($_POST['go'])){ $atitle = mysql_real_escape_string($_POST['articleTitle']); $abody = mysql_real_escape_string($_POST['articleBody']); $acategory = mysql_real_escape_string($_POST['articleCategory']); $atags = mysql_real_escape_string($_POST['articleTags']); $aauthor = mysql_real_escape_string($_POST['articleAuthor']); $alink = mysql_real_escape_string($_POST['articleLink']); if(!get_magic_quotes_gpc()) { $atitle = addslashes($atitle); $abody = addslashes($abody); $atags = addslashes($atags); } include 'config.php'; include 'opendb.php'; $query = " INSERT INTO jf_posts (title,bodytext,category,tags,author,link) ". " VALUES ('$atitle', '$abody', '$acategory', '$atags', '$aauthor', '$alink')"; mysql_query($query) or die('Error ,query failed'); include 'closedb.php'; echo "<div id='topbar' align='center'>Article '$title' added!</div>"; } __________________ SkiLeases.com Last edited by codefreek : 07-30-2009 at 03:11 PM. Reason: PHP tags added - please read http://www.talkphp.com/lounge/4563-prettifying-pasted-code-talkphp.html