Thanks MCS,

You mean like this? (getting errors, so maybe something simple here I'm messing up?)

# MySQL



      if ($entry_order eq '1') {
        
      }

{
         my $insert =  "INSERT INTO `mysql_db` (`Title`, `Email`, `Cit
+y`, `State`, `Country`, `URL`, `Date`, `Description`, `rid`, `dt_crea
+te`, `publish`, ) VALUES (";
      }


      if ($line_breaks == 1) {
         $FORM{'Title'} =~ s/\cM\n/\n/g;
      }

      $insert .= "$FORM{'Title'}";

$insert .= ", ";

      if ( $FORM{'Email'} ){
    my $email_name = $dbh->quote($FORM{'Email'});

#         if ($linkmail eq '1') {
            $insert .= $email_name;

#         }
#         else {
#            $insert .= "$FORM{'Email'}";
#         }

         $insert .= ", ";
      }

      if ( $FORM{'City'} ){
         $insert .= "$FORM{'City'}";
      }
     {
         $insert .= ", ";
      }
      if ( $FORM{'State'} ){
         $insert .= "$FORM{'State'}";
      }
{
         $insert .= ", ";
      }
      if ( $FORM{'Country'} ){
         $insert .= "$FORM{'Country'}";
      }
{
         $insert .= ", ";
      }

if ($FORM{'URL'}) {
         $insert .= "$FORM{'URL'}";
      }
      else {
         $insert .= "$FORM{'URL'}";
      }
{
         $insert .= ", ";
      }

if ($separator eq '1') {
         $insert .= "'$date'";
      }
      else {
         $insert .= "'$date'";
      }
{
         $insert .= ", ";
      }
      
if ( $FORM{'Description'} ){
         $insert .= "$FORM{'Description'}, '', NOW(), 0) \n\n";


      }

           if ($entry_order eq '0') {
         $insert .= "<!--begin-->\n";
      }

   }
   else {
      $insert .= $_;
   }
}

$sth=$dbh->prepare($insert);
$sth->execute();

$dbh->disconnect;
[download]

Thanks,

-Bob

bobafifi.com