Hi Jarich,

Like this??

# MySQL



      my $insert;
    if ($entry_order eq '1') {  
    }


    $insert = "INSERT INTO `mysql_db` (`Title`,
              `Email`, `City`, `State`, `Country`, 
              `URL`, `Date`, `Description`, `rid`,
              `dt_create`, `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)";
}

  else {
     $insert .= $_;
  }
  $sth=$dbh->prepare($insert);
  $sth->execute();
}
$dbh->disconnect();
[download]

Thanks,

-Bob

bobafifi.com