[SOLVED] Need help with submit button! labeled 'Enter Information'

GreenSmurf · March 5, 2009

Need help with submit button labeled 'Enter Information'. Just recently it stopped working in IE7+ but works in all other browsers. Any suggestions?

<input type="Submit" name="submit" value="Enter information">

Sorry for the lack of code but there is too much to post and I would much rather begin the troubleshooting process and perhaps look at particular areas of my code than try to take it all at once. If anyone wants a copy of the code to help I can email it or post it in chunks.

PS The code is a little sloppy.

trq · March 5, 2009

Were going to need to see the relevent processing code, what you have posted doesn't help at all.

GreenSmurf · March 5, 2009

<script type="text/javascript" src="autoCurrency.js"></script>
<?php
//Includes Necesary for functionality
include ("include/dbconnect.php");
include ("include/format.inc.php");
include ("include/header.inc.php");
php?>
<h1>Edit / add address book entry</h1>
<?php

//Phone Strip function
function phn_strip($value){

   $value = preg_replace("/[^0-9]/", "", $value);
   if ($value == 0 OR $value == NULL)
      $value='';

   return $value;
}
//End Function
//Validate String
function Validate_String($string)
         {
         $valid_chars = "1234567890-_.^~abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
         $invalid_chars = "";

         if($string == null || $string == "")
            return(true);

         //For every character on the string.
         for($index = 0; $index < strlen($string); $index++)
            {
            $char = substr($string, $index, 1);

            //Is it a valid character?
            if(strpos($valid_chars, $char) === false)
              {
              //If not, is it already on the list of invalid characters?
              if(strpos($invalid_chars, $char) === false)
                {
                //If it's not, add it.
                if($invalid_chars == "")
                   $invalid_chars .= $char;
                else
                   $invalid_chars .= ", " . $char;
                }
              }
            }

         //If the string does not contain invalid characters, the function will return true.
         //If it does, it will either return false or a list of the invalid characters used
         //in the string, depending on the value of the second parameter.
         if($return_invalid_chars == true && $invalid_chars != "")
           {
           $last_comma = strrpos($invalid_chars, ",");

           if($last_comma != false)
              $invalid_chars = substr($invalid_chars, 0, $last_comma) .
              " and " . substr($invalid_chars, $last_comma + 1, strlen($invalid_chars));

           return($invalid_chars);
           }
         else
           return($invalid_chars == "");
         }
//End Validate string
//Email Verifaction
function Verify_Email_Address($email_address)
         {

	 if ($email_address==""){return(true);}
         //Assumes that valid email addresses consist of [email protected]
         $at = strpos($email_address, "@");
         $dot = strrpos($email_address, ".");

         if($at === false ||
            $dot === false ||
            $dot <= $at + 1 ||
            $dot == 0 ||
            $dot == strlen($email_address) - 1){return(false);}

         $user_name = substr($email_address, 0, $at);
         $domain_name = substr($email_address, $at + 1, strlen($email_address));

         if(Validate_String($user_name) === false ||
            Validate_String($domain_name) === false){return(false);}

         return(true);
         }
//end email function
//
//truncate function
function truncate($string, $max, $rep = '')
{
    if (strlen($string) <= ($max + strlen($rep)))
    {
        return $string;
    }
    $leave = $max - strlen ($rep);
    return substr_replace($string, $rep, $leave);
}


//E-mail strip function
function email_slash($value){
  $value = str_replace('\_','_',$value);
  return $value;
}
//End Function
//Security Funtion
function sql_safe($value,$allow_wildcards = false, $detect_numeric = true) {
  // Taken from the PHP site and modified for wildcards and automatic formatting for numbers/strings.

  // Reverse magic_quotes_gpc/magic_quotes_sybase effects on those vars if ON.
  if (get_magic_quotes_gpc()) {
    if(ini_get('magic_quotes_sybase')) {
      $value = str_replace("''", "'", $value);
    } else {
      $value = stripslashes($value);
    }
  }

  //Escape wildcards for SQL injection protection on LIKE, GRANT, and REVOKE commands.
  if (!$allow_wildcards) {
    $value = str_replace('%','\%',$value);
    $value = str_replace('_','\_',$value);
  }

  // Quote if $value is a string and detection enabled.
  if ($detect_numeric) {
    if (!is_numeric($value)) {
      return "'" . mysql_real_escape_string($value) . "'";
    }
  }

  return mysql_real_escape_string($value);
}

//End Function
//Capitalize the first letter
function first_caps($string)
{

    $str = ucwords(strtolower($string));
    return ($str);

}
//End Function
//Convert all to lowercase
function lower_all($string)
{

  $str = strtolower($string);
  return ($str);

}
//End Function
//Convert all to uppercase
function upper_all($string)
{

  $str = strtoupper($string);
  return ($str);

}
//End Function
//Check if information is submitted
if($submit)
{
//Check if write abilities are present
if(! $read_only)
{
        //Strip characters from numbers
        $home = phn_strip($home);
        $phone2 = phn_strip($phone2);
        $work = phn_strip($work);
        $work2 = phn_strip($work2);
        $mobile = phn_strip($mobile);
        $mobile2 = phn_strip($mobile2);
        $fax = phn_strip($fax);
        $ssnum1 = phn_strip($ssnum1);
        $ssnum2 = phn_strip($ssnum2);
        //Change CASE in strings
        $firstname = first_caps($firstname);
        $firstname2 = first_caps($firstname2);
	$M1 = first_caps($M1);
        $M2 = first_caps($M2);
        $lastname = first_caps($lastname);
        $lastname2 = first_caps($lastname2);
        $boss = first_caps($boss);
        $city = first_caps($city);
        $city2 = first_caps($city2);
        $address = first_caps($address);
        $address2 = first_caps($address2);
        $salesrep = first_caps($salesrep);
        $accnt = first_caps($accnt);
        $clientID = upper_all($clientID);
        $email = lower_all($email);
        $email2 = lower_all($email2);

  if(($firstname!=NULL AND $lastname!=NULL AND strlen($M1)<=1 AND strlen($M2)<=1) AND (is_numeric($home.$phone2.$mobile.$mobile2.$work.$work2.$fax.$byear) == true
      OR $home.$phone2.$mobile.$mobile2.$work.$work2.$fax.$byear == NULL) AND (Verify_Email_Address($email)==TRUE AND Verify_Email_Address($email2)==TRUE)){

          //Writes the display for the first notes in the history
          $display=' -First Entry ';

          for($i=1; $i<=4; $i=$i+1)
          {
            if ($_REQUEST["status".$i] != NULL AND $_REQUEST["status".$i] != '-'){
               if ($i==1){
                  $tat='Personal: ';}
               else if ($i==2){
                    $tat='Business: ';}
               else if ($i==3){
                    $tat='Payroll: ';}
               else if ($i==4){
                    $tat='Retainer: ';}
               else{
                   $tat='';}
		   if ($tat!=""){
			$display=$display."- ".$tat.$_REQUEST["status".$i]." ";
			}
            }
          }
	  if ($newnotes!=""){$display = $display." - ";}
	  
	if (strpbrk($firstname, " ")!="")
	{
		$nameARR = explode(" ", $firstname);
		$firstname = $nameARR[0];
		$M1 = $nameARR[1];
		$M1 = truncate($M1, 1);

	}
	if (strpbrk($firstname2, " ")!="")
	{
		$nameARR = explode(" ", $firstname2);
		$firstname2 = $nameARR[0];
		$M2 = $nameARR[1];
		$M2 = truncate($M2, 1);

	}

       //Add function. Writes to DB information input by user.
       $sql = "INSERT INTO $table (firstname, lastname, firstname2, lastname2, clientID, boss, address, home, mobile, work, email, email2, bday, bmonth,
            byear, address2, phone2, mobile2, work2, ext2, accnt, fax, ext, notes, status1, status2, payroll, status4, qb, comment, city, state, zip,
            city2, state2, zip2, ein, bustype, qbserv, fstats, stax,tx2008,tx2009,salesrep,today,personal,business,retainer,payrep,bday2,bmonth2,byear2,ssnum1,ssnum2,
		M1,M2,chg2009,chg2008)
            VALUES (".sql_safe($firstname).",".sql_safe($lastname).",".sql_safe($firstname2).",".sql_safe($lastname2).",
            ".sql_safe($clientID).",".sql_safe($boss).",".sql_safe($address).",".sql_safe($home).",".sql_safe($mobile).",
            ".sql_safe($work).",".sql_safe($email,true).",".sql_safe($email2,true).",".sql_safe($bday).",
            ".sql_safe($bmonth).",".sql_safe($byear).",".sql_safe($address2).",".sql_safe($phone2).",
            ".sql_safe($mobile2).",".sql_safe($work2).",".sql_safe($ext2).",".sql_safe($accnt).",".sql_safe($fax).",
            ".sql_safe($ext).",CONCAT(CURDATE(),'$display',".sql_safe($newnotes)."),".sql_safe($status1).",".sql_safe($status2).",
            ".sql_safe($payroll).",".sql_safe($status4).",".sql_safe($qb).",".sql_safe($comment).",".sql_safe($city).",
            ".sql_safe($state).",".sql_safe($zip).",".sql_safe($city2).",".sql_safe($state2).",".sql_safe($zip2).",".sql_safe($ein).",
            ".sql_safe($bustype).",".sql_safe($qbserv).",".sql_safe($fstats).",".sql_safe($stax).",".sql_safe($tx2008).",".sql_safe($tx2009).",".sql_safe($salesrep).",CURDATE(),
            ".sql_safe($status1).",".sql_safe($status2).",".sql_safe($retainer).",".sql_safe($payrep).",".sql_safe($bday2).",".sql_safe($bmonth2).",
            ".sql_safe($byear2).",".sql_safe($ssnum1).",".sql_safe($ssnum2).",".sql_safe($M1).",".sql_safe($M2).",".sql_safe($chg2009).",".sql_safe($chg2008).")";
       $result = mysql_query($sql);

       //echo $sql."<br><br>";

       //Adds user to group list
       $sql = "INSERT INTO address_in_groups SELECT LAST_INSERT_ID() id, group_id FROM group_list WHERE group_name = '".$group_name."'";
       $result = mysql_query($sql);
   
   //Begin Update Table
	  //======================================================
	  $sql="SELECT * FROM $table ORDER BY id DESC LIMIT 1";
	  $result = mysql_query($sql);
	  $myrow = mysql_fetch_array($result);
	  $c_id = $myrow["id"];
	  $ip = $_SERVER['REMOTE_ADDR'];
	  $browser = $_SERVER['HTTP_USER_AGENT'];

	  if ($display!="")
	  {
		$sql = "INSERT INTO update_table (id,firstname,lastname,boss,notes,date,time,accnt,personal,business,retainer,ip,browser) 
		VALUES (".$c_id.",".sql_safe($firstname).",".sql_safe($lastname).",".sql_safe($boss).",
		CONCAT(CURDATE(),'$display',".sql_safe($newnotes)."),CURDATE(),CURTIME(),".sql_safe($accnt).",".sql_safe($status1).",
		".sql_safe($status2).",".sql_safe($retainer).",'".$ip."','".$browser."')";
	  
		$result = mysql_query($sql);
	  }
	  //echo $sql."<br><br>";
	  //=======================================================
	  //End Update Table


       //Success dispaly page when information is stored.
       echo "<br><br>Information entered into address book,\n";
       echo "<br><a href='edit$page_ext'>add next</a> or return to ";
       echo "<a href='index$page_ext'>Home Page</a> or ";
   //Code moved to Update table for $id
   //
       echo "<a href=edit${page_ext_qry}id=$c_id>Make Changes</a><br>";
  }
  else{
       echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"15; URL=edit.php?id=".$id."\">
            <b>ERROR 612: </b>Required information missing.<br><br>
            Check <b>First Name</b> or <b>Last Name</b> may have been <b>left blank</b>.<br>
		The <b>Middle Initials</b> may have been <b>too long</b>.<br>
            The <b>birth year</b> or a <b>phone number</b> may <b>NOT</b> have been <b>numeric</b>.<br>
		The <b>e-mail</b> may not have been valid. Check for <b>@ (AT)</b> and the <b>. (DOT)</b> in the address.<br><br>";
	echo "<A HREF=\"javascript:javascript:history.go(-1)\">Go Back.</A>";
  }
} else
  echo "<br><br>Editing is disabled.\n";

}
else if($update)
{
  if(! $read_only)
  {
$sql="SELECT * FROM $base_from_where AND $table.id=$id";
$result = mysql_query($sql);
$resultsnumber = mysql_numrows($result);

if($resultsnumber > 0)
{
        //Strip characters from numbers
        $home = phn_strip($home);
        $phone2 = phn_strip($phone2);
        $work = phn_strip($work);
        $work2 = phn_strip($work2);
        $mobile = phn_strip($mobile);
        $mobile2 = phn_strip($mobile2);
        $fax = phn_strip($fax);
        $ssnum1 = phn_strip($ssnum1);
        $ssnum2 = phn_strip($ssnum2);
        //Change CASE in strings
        $firstname = first_caps($firstname);
        $firstname2 = first_caps($firstname2);
	$M1 = first_caps($M1);
        $M2 = first_caps($M2);
        $lastname = first_caps($lastname);
        $lastname2 = first_caps($lastname2);
        $boss = first_caps($boss);
        $city = first_caps($city);
        $city2 = first_caps($city2);
        $address = first_caps($address);
        $address2 = first_caps($address2);
        $salesrep = first_caps($salesrep);
        $accnt = first_caps($accnt);
        $clientID = upper_all($clientID);
        $email = lower_all($email);
        $email2 = lower_all($email2);

        if(($newnotes != NULL OR $status1!='-' OR $status2!='-' OR $status4!='-') AND
          ($firstname!=NULL AND $lastname!=NULL AND strlen($M1)<=1 AND strlen($M2)<=1) AND (is_numeric($home.$phone2.$mobile.$mobile2.$work.$work2.$fax.$byear) == true
          OR $home.$phone2.$mobile.$mobile2.$work.$work2.$fax.$byear == NULL) AND (Verify_Email_Address($email)==TRUE AND Verify_Email_Address($email2)==TRUE))
	{
	  $sql = "UPDATE $table SET status1=".sql_safe($status1).", status2=".sql_safe($status2).", status4=".sql_safe($status4).",
          newnotes=".sql_safe($newnotes).", personal=".sql_safe($status1).", business=".sql_safe($status2).",
          retainer=".sql_safe($retainer).", today=CURDATE() WHERE id=$id";
	  $result = mysql_query($sql);
	  
          $result = mysql_query("SELECT * FROM $table WHERE id=$id");
	  $myrow = mysql_fetch_array($result);

          $display=' - ';
	  $disTest = $display;

          for($i=1; $i<=4; $i=$i+1)
          {
            if ($myrow["status".$i] != NULL AND $myrow["status".$i] != '-'){
               if ($i==1){
                  $tat='Personal: ';}
               else if ($i==2){
                    $tat='Business: ';}
               else if ($i==3){
                    $tat='Payroll: ';}
               else if ($i==4){
                    $tat='Retainer: ';}
               else{
                   $tat='';}
               $display=$display.$tat.$myrow["status".$i].' - ';
            }
          }

	if ($myrow["home"]!=$home)
	{
		$display = $display."Primary home phone changed.\n";
		$display =$display."From ".$myrow["home"]." to ".$home."\n";
	}
	if ($myrow["phone2"]!=$phone2)
	{
		$display = $display."Secondary home phone changed.\n";
		$display =$display."From ".$myrow["phone2"]." to ".$phone2."\n";
	}
	if ($myrow["work"]!=$work)
	{
		$display = $display."Primary work phone changed.\n";
		$display =$display."From ".$myrow["work"]." to ".$work."\n";
	}
	if ($myrow["work2"]!=$work2)
	{
		$display = $display."Secondary work phone changed.\n";
		$display =$display."From ".$myrow["work2"]." to ".$work2."\n";
	}
	if ($myrow["mobile"]!=$mobile)
	{
		$display = $display."Primary mobile phone changed.\n";
		$display =$display."From ".$myrow["mobile"]." to ".$mobile."\n";
	}
	if ($myrow["mobile2"]!=$mobile2)
	{
		$display = $display."Secondary mobile phone changed.\n";
		$display =$display."From ".$myrow["mobile2"]." to ".$mobile2."\n";
	}
	if ($myrow["fax"]!=$fax)
	{
		$display = $display."Primary fax number changed.\n";
		$display =$display."From ".$myrow["fax"]." to ".$fax."\n";
	}
	if ($myrow["ssnum1"]!=$ssnum1)
	{
		$display = $display."Primary Social Security number changed.\n";
		$display =$display."From ".$myrow["ssnum1"]." to ".$ssnum1."\n";
	}
	if ($myrow["ssnum2"]!=$ssnum2)
	{
		$display = $display."Secondary Social Security number changed.\n";
		$display =$display."From ".$myrow["ssnum2"]." to ".$ssnum2."\n";
	}
	if ($myrow["firstname"]!=$firstname)
	{
		$display = $display."Primary first name changed.\n";
		$display =$display."From ".$myrow["firstname"]." to ".$firstname."\n";
	}
	if ($myrow["firstname2"]!=$firstname2)
	{
		$display = $display."Secondary first name changed.\n";
		$display =$display."From ".$myrow["firstname2"]." to ".$firstname2."\n";
	}
	if ($myrow["M1"]!=$M1)
	{
		$display = $display."Primary middle initial changed.\n";
		$display =$display."From ".$myrow["M1"]." to ".$M1."\n";
	}
	if ($myrow["M2"]!=$M2)
	{
		$display = $display."Secondary middle initial changed.\n";
		$display =$display."From ".$myrow["M2"]." to ".$M2."\n";
	}
	if ($myrow["lastname"]!=$lastname)
	{
		$display = $display."Primary last name changed.\n";
		$display =$display."From ".$myrow["lastname"]." to ".$lastname."\n";
	}
	if ($myrow["lastname2"]!=$lastname2)
	{
		$display = $display."Secondary last name changed.\n";
		$display =$display."From ".$myrow["lastname2"]." to ".$lastname2."\n";
	}
	if ($myrow["boss"]!=$boss)
	{
		$display = $display."Business name changed.\n";
		$display =$display."From ".$myrow["boss"]." to ".$boss."\n";
	}
	if ($myrow["city"]!=$city)
	{
		$display = $display."Primary city changed.\n";
		$display =$display."From ".$myrow["city"]." to ".$city."\n";
	}
	if ($myrow["city2"]!=$city2)
	{
		$display = $display."Secondary city changed.\n";
		$display =$display."From ".$myrow["city2"]." to ".$city2."\n";
	}
	if ($myrow["address"]!=$address)
	{
		$display = $display."Primary address changed.\n";
		$display =$display."From ".$myrow["address"]." to ".$address."\n";
	}
	if ($myrow["address2"]!=$address2)
	{
		$display = $display."Secondary address changed.\n";
		$display =$display."From ".$myrow["address2"]." to ".$address2."\n";
	}
	if ($myrow["salesrep"]!=$salesrep)
	{
		$display = $display."Sales Rep changed.\n";
		$display =$display."From ".$myrow["salesrep"]." to ".$salesrep."\n";
	}
	if ($myrow["accnt"]!=$accnt)
	{
		$display = $display."Accountant changed.\n";
		$display =$display."From ".$myrow["accnt"]." to ".$accnt."\n";
	}
	if ($myrow["clientID"]!=$clientID)
	{
		$display = $display."clientID changed.\n";
		$display =$display."From ".$myrow["clientID"]." to ".clientID."\n";
	}
	if ($myrow["email"]!=$email)
	{
		$display = $display."Primary e-mail changed.\n";
		$display =$display."From ".$myrow["email"]." to ".$email."\n";
	}
	if ($myrow["email2"]!=$email2)
	{
		$display = $display."Secondary e-mail changed.\n";
		$display =$display."From ".$myrow["email2"]." to ".$email2."\n";
	}
	if ($myrow["qb"]!=$qb)
	{
		$display = $display."Quickbooks password changed.\n";
		$display =$display."From ".$myrow["qb"]." to ".$qb."\n";
	}
	if ($myrow["qbserv"]!=$qbserv)
	{
		$display = $display."Bookkeeping services changed.\n";
		$display =$display."From ".$myrow["qbserv"]." to ".$qbserv."\n";
	}
	if ($myrow["zip"]!=$zip)
	{
		$display = $display."Primary zip code changed.\n";
		$display =$display."From ".$myrow["zip"]." to ".$zip."\n";
	}
	if ($myrow["zip2"]!=$zip2)
	{
		$display = $display."Secondary zip code changed.\n";
		$display =$display."From ".$myrow["zip2"]." to ".$zip2."\n";
	}
	if ($myrow["ein"]!=$ein)
	{
		$display = $display."EIN number changed.\n";
		$display =$display."From ".$myrow["ein"]." to ".$ein."\n";
	}
	if ($myrow["fstats"]!=$fstats)
	{
		$display = $display."Financial statements changed.\n";
		$display =$display."From ".$myrow["fstats"]." to ".$fstats."\n";
	}
	if ($myrow["bday"]!=$bday OR $myrow["bmonth"]!=$bmonth OR $myrow["byear"]!=$byear)
	{
		$display = $display."Primary birthday changed.\n";
		$display =$display."From ".$myrow["bmonth"]." ".$myrow["bday"].", ".$myrow["byear"]." to "
		.$bmonth." ".$bday.", ".$byear."\n";
	}
	if ($myrow["bday2"]!=$bday2 OR $myrow["bmonth2"]!=$bmonth2 OR $myrow["byear2"]!=$byear2)
	{
		$display = $display."Secondary birthday changed.\n";
		$display =$display."From ".$myrow["bmonth2"]." ".$myrow["bday2"].", ".$myrow["byear2"]." to "
		.$bmonth2." ".$bday2.", ".$byear2."\n";
	}
	if ($myrow["stax"]!=$stax)
	{
		if($stax=="on")
		{
			$display =$display."Became a sales tax client.\n";
		}
		else 
		{
			$display =$display."Cancelled as a sales tax client.\n";
		}
	}
	if ($myrow["payroll"]!=$payroll)
	{
		if($payroll=="on")
		{
			$display =$display."Became a payroll client.\n";
		}
		else 
		{
			$display =$display."Cancelled as a payroll client.\n";
		}
	}
	if ($myrow["retainer"]!=$retainer)
	{
		if($retainer!="")
		{
			$display =$display."Became a retainer client.\n";
		}
		else 
		{
			$display =$display."Cancelled as a retainer client.\n";
		}
	}

	if (strpbrk($firstname, " ")!="")
	{
		$nameARR = explode(" ", $firstname);
		$firstname = $nameARR[0];
		$M1 = $nameARR[1];
		$M1 = truncate($M1, 1);

	}
	if (strpbrk($firstname2, " ")!="")
	{
		$nameARR = explode(" ", $firstname2);
		$firstname2 = $nameARR[0];
		$M2 = $nameARR[1];
		$M2 = truncate($M2, 1);

	}

	if ($display==$disTest AND $newnotes=="")
	{
		$dist="";
	}
	else
	{
		$dist = ", notes=CONCAT(today,'".$display."',newnotes,CHAR(13),CHAR(13),notes)";
	}

          		  $sql = "UPDATE $table SET firstname=".sql_safe($firstname).",lastname=".sql_safe($lastname).",state2=".sql_safe($state2).",
          firstname2=".sql_safe($firstname2).",lastname2=".sql_safe($lastname2).",clientID=".sql_safe($clientID).",ext2=".sql_safe($ext2).",
          boss=".sql_safe($boss).",address=".sql_safe($address).",home=".sql_safe($home).",mobile=".sql_safe($mobile).",work2=".sql_safe($work2).",
          work=".sql_safe($work).",email=".sql_safe($email,true).",email2=".sql_safe($email2,true).",bday=".sql_safe($bday).",mobile2=".sql_safe($mobile2).",
          bmonth=".sql_safe($bmonth).",byear=".sql_safe($byear).",address2=".sql_safe($address2).",phone2=".sql_safe($phone2).",
          accnt=".sql_safe($accnt).",fax=".sql_safe($fax).",ext=".sql_safe($ext).",status1=".sql_safe($status1).",city2=".sql_safe($city2).",
          status2=".sql_safe($status2).",payroll=".sql_safe($payroll).",status4=".sql_safe($status4).",zip2=".sql_safe($zip2).",
          city=".sql_safe($city).",state=".sql_safe($state).",zip=".sql_safe($zip).",ein=".sql_safe($ein).", payrep=".sql_safe($payrep).",
          bustype=".sql_safe($bustype).",qbserv=".sql_safe($qbserv).",fstats=".sql_safe($fstats).",stax=".sql_safe($stax).",salesrep=".sql_safe($salesrep)."
          $dist,qb=".sql_safe($qb).",comment=".sql_safe($comment).",tx2009=".sql_safe($tx2009).",tx2008=".sql_safe($tx2008).",
          bmonth2=".sql_safe($bmonth2).",byear2=".sql_safe($byear2).",bday2=".sql_safe($bday2).",M1=".sql_safe($M1).",M2=".sql_safe($M2).",
          ssnum1=".sql_safe($ssnum1).",ssnum2=".sql_safe($ssnum2).",chg2009=".sql_safe($chg2009).",chg2008=".sql_safe($chg2008)." WHERE id=$id";
          
          //echo $sql;
          
	  $result = mysql_query($sql);
          //echo $sql."<br><br>";
	  //
	  //Begin Update Table
	  //======================================================
	  $sql="SELECT * FROM $table ORDER BY id DESC LIMIT 1";
	  $result = mysql_query($sql);
	  $myrow = mysql_fetch_array($result);
	  $c_id = $myrow["id"];
	  $ip = $_SERVER['REMOTE_ADDR'];
	  $browser = $_SERVER['HTTP_USER_AGENT'];

	  if ($dist!="")
	  {
		$sql = "INSERT INTO update_table (id,firstname,lastname,boss,notes,date,time,accnt,personal,business,retainer,ip,browser) 
		VALUES (".$id.",".sql_safe($firstname).",".sql_safe($lastname).",".sql_safe($boss).",
		CONCAT(CURDATE(),'$display',".sql_safe($newnotes)."),CURDATE(),CURTIME(),".sql_safe($accnt).",".sql_safe($status1).",
		".sql_safe($status2).",".sql_safe($retainer).",'".$ip."','".$browser."')";
	  
		$result = mysql_query($sql);
	  }
	  //echo $sql."<br><br>";
	  //=======================================================
	  //End Update Table
	  //
	  // header("Location: view?id=$id");

	  echo "<br>Address book updated.\n";
	  echo "<br><a href='index$page_ext'>Home Page</a> or ";
          echo "<a href=edit${page_ext_qry}id=$id>Make Changes</a><br>";
	}

	else if (($firstname!=NULL AND $lastname!=NULL) AND (is_numeric($home.$phone2.$mobile.$mobile2.$work.$work2.$fax.$byear) == true
        OR $home.$phone2.$mobile.$mobile2.$work.$work2.$fax.$byear == NULL) AND (Verify_Email_Address($email)==TRUE AND Verify_Email_Address($email2)==TRUE))
	{

	$result = mysql_query("SELECT * FROM $table WHERE id=$id");
	$myrow = mysql_fetch_array($result);

	$display=' - ';
	$disTest=$display;

	if ($myrow["home"]!=$home)
	{
		$display = $display."Primary home phone changed.\n";
		$display =$display."From ".$myrow["home"]." to ".$home."\n";
	}
	if ($myrow["phone2"]!=$phone2)
	{
		$display = $display."Secondary home phone changed.\n";
		$display =$display."From ".$myrow["phone2"]." to ".$phone2."\n";
	}
	if ($myrow["work"]!=$work)
	{
		$display = $display."Primary work phone changed.\n";
		$display =$display."From ".$myrow["work"]." to ".$work."\n";
	}
	if ($myrow["work2"]!=$work2)
	{
		$display = $display."Secondary work phone changed.\n";
		$display =$display."From ".$myrow["work2"]." to ".$work2."\n";
	}
	if ($myrow["mobile"]!=$mobile)
	{
		$display = $display."Primary mobile phone changed.\n";
		$display =$display."From ".$myrow["mobile"]." to ".$mobile."\n";
	}
	if ($myrow["mobile2"]!=$mobile2)
	{
		$display = $display."Secondary mobile phone changed.\n";
		$display =$display."From ".$myrow["moblie2"]." to ".$mobile2."\n";
	}
	if ($myrow["fax"]!=$fax)
	{
		$display = $display."Primary fax number changed.\n";
		$display =$display."From ".$myrow["fax"]." to ".$fax."\n";
	}
	if ($myrow["ssnum1"]!=$ssnum1)
	{
		$display = $display."Primary Social Security number changed.\n";
		$display =$display."From ".$myrow["ssnum1"]." to ".$ssnum1."\n";
	}
	if ($myrow["ssnum2"]!=$ssnum2)
	{
		$display = $display."Secondary Social Security number changed.\n";
		$display =$display."From ".$myrow["ssnum2"]." to ".$ssnum2."\n";
	}
	if ($myrow["firstname"]!=$firstname)
	{
		$display = $display."Primary first name changed.\n";
		$display =$display."From ".$myrow["firstname"]." to ".$firstname."\n";
	}
	if ($myrow["firstname2"]!=$firstname2)
	{
		$display = $display."Secondary first name changed.\n";
		$display =$display."From ".$myrow["firstname2"]." to ".$firstname2."\n";
	}
	if ($myrow["M1"]!=$M1)
	{
		$display = $display."Primary middle initial changed.\n";
		$display =$display."From ".$myrow["M1"]." to ".$M1."\n";
	}
	if ($myrow["M2"]!=$M2)
	{
		$display = $display."Secondary middle initial changed.\n";
		$display =$display."From ".$myrow["M2"]." to ".$M2."\n";
	}
	if ($myrow["lastname"]!=$lastname)
	{
		$display = $display."Primary last name changed.\n";
		$display =$display."From ".$myrow["lastname"]." to ".$lastname."\n";
	}
	if ($myrow["lastname2"]!=$lastname2)
	{
		$display = $display."Secondary last name changed.\n";
		$display =$display."From ".$myrow["lastname2"]." to ".$lastname2."\n";
	}
	if ($myrow["boss"]!=$boss)
	{
		$display = $display."Business name changed.\n";
		$display =$display."From ".$myrow["boss"]." to ".$boss."\n";
	}
	if ($myrow["city"]!=$city)
	{
		$display = $display."Primary city changed.\n";
		$display =$display."From ".$myrow["city"]." to ".$city."\n";
	}
	if ($myrow["city2"]!=$city2)
	{
		$display = $display."Secondary city changed.\n";
		$display =$display."From ".$myrow["city2"]." to ".$city2."\n";
	}
	if ($myrow["address"]!=$address)
	{
		$display = $display."Primary address changed.\n";
		$display =$display."From ".$myrow["address"]." to ".$address."\n";
	}
	if ($myrow["address2"]!=$address2)
	{
		$display = $display."Secondary address changed.\n";
		$display =$display."From ".$myrow["address2"]." to ".$address2."\n";
	}
	if ($myrow["salesrep"]!=$salesrep)
	{
		$display = $display."Sales Rep changed.\n";
		$display =$display."From ".$myrow["salesrep"]." to ".$salesrep."\n";
	}
	if ($myrow["accnt"]!=$accnt)
	{
		$display = $display."Accountant changed.\n";
		$display =$display."From ".$myrow["accnt"]." to ".$accnt."\n";
	}
	if ($myrow["clientID"]!=$clientID)
	{
		$display = $display."clientID changed.\n";
		$display =$display."From ".$myrow["clientID"]." to ".clientID."\n";
	}
	if ($myrow["email"]!=$email)
	{
		$display = $display."Primary e-mail changed.\n";
		$display =$display."From ".$myrow["email"]." to ".$email."\n";
	}
	if ($myrow["email2"]!=$email2)
	{
		$display = $display."Secondary e-mail changed.\n";
		$display =$display."From ".$myrow["email2"]." to ".$email2."\n";
	}
	if ($myrow["qb"]!=$qb)
	{
		$display = $display."Quickbooks password changed.\n";
		$display =$display."From ".$myrow["qb"]." to ".$qb."\n";
	}
	if ($myrow["qbserv"]!=$qbserv)
	{
		$display = $display."Bookkeeping services changed.\n";
		$display =$display."From ".$myrow["qbserv"]." to ".$qbserv."\n";
	}
	if ($myrow["zip"]!=$zip)
	{
		$display = $display."Primary zip code changed.\n";
		$display =$display."From ".$myrow["zip"]." to ".$zip."\n";
	}
	if ($myrow["zip2"]!=$zip2)
	{
		$display = $display."Secondary zip code changed.\n";
		$display =$display."From ".$myrow["zip2"]." to ".$zip2."\n";
	}
	if ($myrow["ein"]!=$ein)
	{
		$display = $display."EIN number changed.\n";
		$display =$display."From ".$myrow["ein"]." to ".$ein."\n";
	}
	if ($myrow["fstats"]!=$fstats)
	{
		$display = $display."Financial statements changed.\n";
		$display =$display."From ".$myrow["fstats"]." to ".$fstats."\n";
	}
	if ($myrow["bday"]!=$bday OR $myrow["bmonth"]!=$bmonth OR $myrow["byear"]!=$byear)
	{
		$display = $display."Primary birthday changed.\n";
		$display =$display."From ".$myrow["bmonth"]." ".$myrow["bday"].", ".$myrow["byear"]." to "
		.$bmonth." ".$bday.", ".$byear."\n";
	}
	if ($myrow["bday2"]!=$bday2 OR $myrow["bmonth2"]!=$bmonth2 OR $myrow["byear2"]!=$byear2)
	{
		$display = $display."Secondary birthday changed.\n";
		$display =$display."From ".$myrow["bmonth2"]." ".$myrow["bday2"].", ".$myrow["byear2"]." to "
		.$bmonth2." ".$bday2.", ".$byear2."\n";
	}
	if ($myrow["stax"]!=$stax)
	{
		$display = $display."\n";
		if($stax=="on")
		{
			$display =$display."Became a sales tax client.\n";
		}
		else 
		{
			$display =$display."Cancelled as a sales tax client.\n";
		}
	}
	if ($myrow["payroll"]!=$payroll)
	{
		$display = $display."\n";
		if($payroll=="on")
		{
			$display =$display."Became a payroll client.\n";
		}
		else 
		{
			$display =$display."Cancelled as a payroll client.\n";
		}
	}
	if ($myrow["retainer"]!=$retainer)
	{
		$display = $display."\n";
		if($retainer!="")
		{
			$display =$display."Became a retainer client.\n";
		}
		else 
		{
			$display =$display."Cancelled as a retainer client.\n";
		}
	}

	if (strpbrk($firstname, " ")!="")
	{
		$nameARR = explode(" ", $firstname);
		$firstname = $nameARR[0];
		$M1 = $nameARR[1];
		$M1 = truncate($M1, 1);

	}
	if (strpbrk($firstname2, " ")!="")
	{
		$nameARR = explode(" ", $firstname2);
		$firstname2 = $nameARR[0];
		$M2 = $nameARR[1];
		$M2 = truncate($M2, 1);

	}

	if ($display==$disTest)
	{
		$dist="";
	}
	else
	{
		$dist = ", notes=CONCAT(today,'".$display."',CHAR(13),CHAR(13),notes)";
	}

	//echo "M1: ".$M1."<br>M2: ".$M2."<br>";

	  $sql = "UPDATE $table SET firstname=".sql_safe($firstname).",lastname=".sql_safe($lastname).",state2=".sql_safe($state2).",
          firstname2=".sql_safe($firstname2).",lastname2=".sql_safe($lastname2).",clientID=".sql_safe($clientID).",ext2=".sql_safe($ext2).",
          boss=".sql_safe($boss).",address=".sql_safe($address).",home=".sql_safe($home).",mobile=".sql_safe($mobile).",work2=".sql_safe($work2).",
          work=".sql_safe($work).",email=".sql_safe($email,true).",email2=".sql_safe($email2,true).",bday=".sql_safe($bday).",mobile2=".sql_safe($mobile2).",
          bmonth=".sql_safe($bmonth).",byear=".sql_safe($byear).",address2=".sql_safe($address2).",phone2=".sql_safe($phone2).", payrep=".sql_safe($payrep).",
          accnt=".sql_safe($accnt).",fax=".sql_safe($fax).",ext=".sql_safe($ext).",status1=".sql_safe($status1).",city2=".sql_safe($city2).",
          status2=".sql_safe($status2).",payroll=".sql_safe($payroll).",status4=".sql_safe($status4).",qb=".sql_safe($qb).",zip2=".sql_safe($zip2).",
          comment=".sql_safe($comment).",city=".sql_safe($city).",state=".sql_safe($state).",zip=".sql_safe($zip).",ein=".sql_safe($ein).",retainer=".sql_safe($retainer).",
          bustype=".sql_safe($bustype).",qbserv=".sql_safe($qbserv).",fstats=".sql_safe($fstats).",stax=".sql_safe($stax).",salesrep=".sql_safe($salesrep).",
          bmonth2=".sql_safe($bmonth2).",byear2=".sql_safe($byear2).",bday2=".sql_safe($bday2).",M1=".sql_safe($M1).",M2=".sql_safe($M2)."$dist,ssnum1=".sql_safe($ssnum1).",
	  ssnum2=".sql_safe($ssnum2).",tx2009=".sql_safe($tx2009).",tx2008=".sql_safe($tx2008).",chg2009=".sql_safe($chg2009).",chg2008=".sql_safe($chg2008)." WHERE id=$id";
	  $result = mysql_query($sql);
	  
          //echo $sql."<br><br>";
	  //echo $chg2009." || ".sql_safe($chg2009);

	  // header("Location: view?id=$id");
	  //Begin Update Table
	  //======================================================
	  $sql="SELECT * FROM $table ORDER BY id DESC LIMIT 1";
	  $result = mysql_query($sql);
	  $myrow = mysql_fetch_array($result);
	  $c_id = $myrow["id"];
	  $ip = $_SERVER['REMOTE_ADDR'];
	  $browser = $_SERVER['HTTP_USER_AGENT'];

	  if ($dist!="")
	  {
		$sql = "INSERT INTO update_table (id,firstname,lastname,boss,notes,date,time,accnt,personal,business,retainer,ip,browser) 
		VALUES (".$id.",".sql_safe($firstname).",".sql_safe($lastname).",".sql_safe($boss).",
		CONCAT(CURDATE(),'$display',".sql_safe($newnotes)."),CURDATE(),CURTIME(),".sql_safe($accnt).",".sql_safe($status1).",
		".sql_safe($status2).",".sql_safe($retainer).",'".$ip."','".$browser."')";
	  
		$result = mysql_query($sql);
	  }
	  //echo $sql."<br><br>";
	  //=======================================================
	  //End Update Table
	  //
	  //echo "dist = ".$dist." display = ".$display." disTest = ".$disTest."<br><br>";
	  //=======================================================

	  echo "<br>Address book updated.\n";
	  echo "<br><a href='index$page_ext'>Home Page</a> or ";
          echo "<a href=edit${page_ext_qry}id=$id>Make Changes</a><br>";
	}
       else{
            echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"15; URL=edit.php?id=".$id."\">
            <b>ERROR 612: </b>Required information missing.<br><br>
            Check <b>First Name</b> or <b>Last Name</b> may have been <b>left blank</b>.<br>
		The <b>Middle Initials</b> may have been <b>too long</b>.<br>
            The <b>birth year</b> or a <b>phone number</b> may <b>NOT</b> have been <b>numeric</b>.<br>
		The <b>e-mail</b> may not have been valid. Check for <b>@ (AT)</b> and the <b>. (DOT)</b> in the address.<br><br>";
		echo "<A HREF=\"javascript:javascript:history.go(-1)\">Go Back.</A>";
       }
} else {
	echo "<br>Invalid ID.\n";
	echo "<br><a href='index$page_ext'>Home Page</a>";
}
  } else
    echo "<br><br>Editing is disabled.\n";
}

GreenSmurf · March 5, 2009

else if($id)
{
  if(! $read_only)
  {
$result = mysql_query("SELECT * FROM $base_from_where AND $table.id=$id",$db);
$myrow = mysql_fetch_array($result);
?>
  <form method="post" action="edit<? echo $page_ext; ?>">

  <table width="380" border="0" cellspacing="1" cellpadding="1">
    <tr>
      <td>
        <input type="hidden" name="id" value="<?php echo $myrow["id"]?>">
        Firstname: </td>
      <td colspan=2>
        <input type="Text" name="firstname" size="35" value="<?php echo $myrow["firstname"]?>">
      </td>
  <td>MI: </td>
      <td>
        <input type="Text" name="M1" size="1" value="<?php echo $myrow["M1"]?>">
      </td>
      <td>Client ID: </td>
      <td colspan=2>
        <input type="Text" name="clientID" size="12" value="<?php echo $myrow["clientID"]?>">
      </td>
    </tr>
    <tr>
      <td>Lastname: </td>
      <td colspan=2>
        <input type="Text" name="lastname" size="35" value="<?php echo $myrow["lastname"]?>">
      </td>
      <td>SS #: </td>
      <td>
        <input type="Text" name="ssnum1" size="9" value="<?php echo $myrow["ssnum1"]?>">
      </td>
  <td>EIN: </td>
      <td>
      <input type="Text" name="ein" size="14" value="<?php echo $myrow["ein"]?>">
      </td>
      </tr>
      <tr>
      <td>Client Type: </td>
      <td>
      <select name="bustype">
          <option value="<?php echo $myrow["bustype"]; ?>" selected><?php echo $myrow["bustype"]; ?></option>
          <option value="Personal">Personal</option>
          <option value="C Corporation">C Corporation</option>
          <option value="Partnership, LLC">Partnership, LLC</option>
          <option value="S Corp">S Corp</option>
          <option value="LLC">LLC</option>
          <option value="Estate & Trust">Estate & Trust</option>
          <option value="Non-Profit">Non-Profit</option>
          <option value="Sole Proprietor">Sole Proprietor</option>
          <option value="Single Member LLC">Single Member LLC</option>
          <option value="">N/A</option>
        </select>
      </td>
      <td>Business: </td>
      <td colspan=5>
        <input type="Text" name="boss" size="35" value="<?php echo $myrow["boss"]?>">
      </td>
    </tr>
    <tr>
      <td><b><u>Attention</b></u></td>
      <td colspan=6>
        <textarea rows="2" cols="65" name="comment"><?php echo $myrow["comment"]; ?></textarea>
      </td>
    </tr>
    </table>
    <table>
    <tr>
    <td> </td>
    </tr>
    <tr>
      <td rowspan=4>Address: </td>
          <td rowspan=4>
              <textarea name="address" rows="5" cols="35"><?php echo $myrow["address"]; ?></textarea>
          </td>
    </tr>
      <tr>
          <td> </td>
          <td>City: </td>
          <td><input type="text" name="city" size="31" value="<?php echo $myrow["city"]; ?>"></td>
      </tr>
      <tr>
          <td> </td>
          <td>State: </td>
          <td>
              <select name="state" size="1">
              <option value="<?php echo $myrow["state"] ?>" selected><?php echo $myrow["state"]; ?></option>
              <option value="-">-</option>
          <option value="AK">AK</option>
          <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="AZ">AZ</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="CT">CT</option>
          <option value="DC">DC</option>
          <option value="DE">DE</option>
          <option value="FL">FL</option>
          <option value="GA">GA</option>
          <option value="HI">HI</option>
          <option value="IA">IA</option>
          <option value="ID">ID</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MA">MA</option>
          <option value="MD">MD</option>
          <option value="ME">ME</option>
          <option value="MI">MI</option>
          <option value="MN">MN</option>
          <option value="MO">MO</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="NC">NC</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NH">NH</option>
          <option value="NJ">NJ</option>
          <option value="NM">NM</option>
          <option value="NV">NV</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OR">OR</option>
          <option value="PA">PA</option>
          <option value="RI">RI</option>
          <option value="SC">SC</option>
          <option value="SD">SD</option>
          <option value="TN">TN</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="VA">VA</option>
          <option value="VT">VT</option>
          <option value="WA">WA</option>
          <option value="WI">WI</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option></select>
        </td>
       </tr>
       <tr>
          <td> </td>
          <td>ZIP: </td>
          <td><input type="text" name="zip" size="9" value="<?php echo $myrow["zip"]; ?>"></td>
      </tr>
  </table>
  <table>
    <tr>
      <td><b>Telephone: </b></td>
      <td colspan=3 align="center"><small>Please enter a valid contact number (must contain numbers only)</small></td>
    </tr>
    <tr>
      <td>Home:</td>
      <td>
        <input type="Text" name="home" value="<?php echo $myrow["home"]; ?>">
      </td>
      <td>Mobile:</td>
      <td>
        <input type="Text" name="mobile" value="<?php echo $myrow["mobile"]; ?>">
      </td>
    </tr>
    <tr>
      <td>Work: </td>
      <td>
        <input type="Text" name="work" value="<?php echo $myrow["work"]; ?>">
      </td>
      <td>Ext:</td>
      <td><input type="Text" name="ext" size="6" value="<?php echo $myrow["ext"]; ?>"></td>
    </tr>
    <tr>
      <td>Fax:</td>
      <td><input type="Text" name="fax" value="<?php echo $myrow["fax"]; ?>"></td>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
      <td>Email:</td>
      <td>
        <input type="Text" name="email" size="35" value="<?php echo email_slash($myrow["email"]); ?>">
      </td>
    </tr>
    <tr>
      <td>Birthday:</td>
      <td>
        <select name="bday">
          <option value="<?php echo $myrow["bday"]; ?>" selected><?php echo ($myrow["bday"] == 0?"-":$myrow["bday"]) ?></option>
          <option value="0">-</option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="24">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
        <select name="bmonth">
          <option value="<?php echo $myrow["bmonth"] ?>" selected><?php echo $myrow["bmonth"]; ?></option>
          <option value="-">-</option>
          <option value="January">January</option>
          <option value="February">February</option>
          <option value="March">March</option>
          <option value="April">April</option>
          <option value="May">May</option>
          <option value="June">June</option>
          <option value="July">July</option>
          <option value="August">August</option>
          <option value="September">September</option>
          <option value="October">October</option>
          <option value="November">November</option>
          <option value="December">December</option>
        </select>
        <input type="text" name="byear" size="4" maxlength="4" value="<?php echo $myrow["byear"]; ?>">
      </td>
    </tr>
  </table>
  <table>
    <tr>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
      <td colspan=3><b>Secondary: </b></td>
    </tr>
    <tr>
      <td>
        <input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
        Firstname: </td>
      <td>
        <input type="Text" name="firstname2" size="35" value="<?php echo $myrow["firstname2"]; ?>">
      </td>
  <td>MI: </td>
      <td colspan=2>
        <input type="Text" name="M2" size="1" value="<?php echo $myrow["M2"]?>">
      </td>
    </tr>
    <tr>
      <td>Lastname:</td>
      <td>
        <input type="Text" name="lastname2" size="35" value="<?php echo $myrow["lastname2"]; ?>">
      </td>
        <td>SS #: </td>
      <td colspan=3>
        <input type="Text" name="ssnum2" size="9" value="<?php echo $myrow["ssnum2"]?>">
      </td>
    </tr>
    </table>
    <table>
    <tr>
      <td rowspan=4>Address: </td>
          <td rowspan=4>
              <textarea name="address2" rows="5" cols="35"><?php echo $myrow["address2"]; ?></textarea>
          </td>
    </tr>
      <tr>
          <td> </td>
          <td>City: </td>
          <td><input type="text" name="city2" size="31" value="<?php echo $myrow["city2"]; ?>"></td>
      </tr>
      <tr>
          <td> </td>
          <td>State: </td>
          <td>
              <select name="state2" size="1">
              <option value="<?php echo $myrow["state2"] ?>" selected><?php echo $myrow["state2"]; ?></option>
              <option value="-">-</option>
          <option value="AK">AK</option>
          <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="AZ">AZ</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="CT">CT</option>
          <option value="DC">DC</option>
          <option value="DE">DE</option>
          <option value="FL">FL</option>
          <option value="GA">GA</option>
          <option value="HI">HI</option>
          <option value="IA">IA</option>
          <option value="ID">ID</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MA">MA</option>
          <option value="MD">MD</option>
          <option value="ME">ME</option>
          <option value="MI">MI</option>
          <option value="MN">MN</option>
          <option value="MO">MO</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="NC">NC</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NH">NH</option>
          <option value="NJ">NJ</option>
          <option value="NM">NM</option>
          <option value="NV">NV</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OR">OR</option>
          <option value="PA">PA</option>
          <option value="RI">RI</option>
          <option value="SC">SC</option>
          <option value="SD">SD</option>
          <option value="TN">TN</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="VA">VA</option>
          <option value="VT">VT</option>
          <option value="WA">WA</option>
          <option value="WI">WI</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option></select>
        </td>
       </tr>
       <tr>
          <td> </td>
          <td>ZIP: </td>
          <td><input type="text" name="zip2" size="9" value="<?php echo $myrow["zip2"]; ?>"></td>
      </tr>
  </table>
  <table>
    <tr>
      <td>Home:</td>
      <td>
        <input type="Text" name="phone2" value="<?php echo $myrow["phone2"]; ?>">
      </td>
      <td>Mobile:</td>
      <td>
        <input type="Text" name="mobile2" value="<?php echo $myrow["mobile2"]; ?>">
      </td>
    </tr>
    <tr>
      <td>Work: </td>
      <td>
        <input type="Text" name="work2" value="<?php echo $myrow["work2"]; ?>">
      </td>
      <td>Ext:</td>
      <td><input type="Text" name="ext2" size="6" value="<?php echo $myrow["ext2"]; ?>"></td>
    </tr>
    <tr>
<td>Email:</td>
      <td>
        <input type="Text" name="email2" size="35" value="<?php echo email_slash($myrow["email2"]); ?>">
      </td>
    </tr>
    <tr>
      <td>Birthday:</td>
      <td>
        <select name="bday2">
          <option value="<?php echo $myrow["bday2"]; ?>" selected><?php echo ($myrow["bday2"] == 0?"-":$myrow["bday2"]) ?></option>
          <option value="0">-</option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="24">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
        <select name="bmonth2">
          <option value="<?php echo $myrow["bmonth2"] ?>" selected><?php echo ($myrow["bmonth2"] == ""?"-":$myrow["bmonth2"]); ?></option>
          <option value="-">-</option>
          <option value="January">January</option>
          <option value="February">February</option>
          <option value="March">March</option>
          <option value="April">April</option>
          <option value="May">May</option>
          <option value="June">June</option>
          <option value="July">July</option>
          <option value="August">August</option>
          <option value="September">September</option>
          <option value="October">October</option>
          <option value="November">November</option>
          <option value="December">December</option>
        </select>
        <input type="text" name="byear2" size="4" maxlength="4" value="<?php echo $myrow["byear2"]; ?>">
      </td>
    </tr>
</table>
  <table>
    <tr>
      <td colspan=4><b><br><br>Account Info</b></td>
    </tr>
     <tr>
      <td>History: </td>
      <td colspan=3>
  <textarea name="notesdisplay" rows="10" cols="47"><?php echo $myrow["notes"]; ?></textarea><br><br>
</td>
    </tr>
   <tr>
      <td align="right">Sales Rep: </td>
      <td>
      <input type="text" name="salesrep" size="35" value="<?php echo $myrow["salesrep"]; ?>">
      </td>
      <td> </td>
      <td> </td>
    </tr>
       <tr>
      <td align="right">Payroll Rep: </td>
      <td>
      <input type="text" name="payrep" size="35" value="<?php echo $myrow["payrep"]; ?>">
      </td>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
        <td align="right">Accountant: </td>
      <td>
        <input type="Text" name="accnt" size="35" value="<?php echo $myrow["accnt"]; ?>">
      </td>
    </tr>
    <tr><td/></tr>
    <tr><td/></tr>
    <tr>
<td><b>Bookkeepsing Services: </b></td>
<td><select name="qbserv">
          <option value="<?php echo $myrow["qbserv"] ?>" selected><?php echo $myrow["qbserv"]; ?></option>
          <option value="-">-</option>
          <option value="QB Supplied to Accountant">QB Supplied to Accountant</option>
          <option value="QB Data Entry by Accountant">QB data entry by Accountant</option>
          <option value="QB Training">QB Training</option>
	  <option value="QB Online">QB Online</option>
          <option value="Creative Solutions">Creative Solutions</option>
          <option value="Tax Return">Tax Return</option>
          <option value="">N/A</option>
        </select>
</td>
	<td>Financial Statements: </td>
    <td><select name="fstats">
          <option value="<?php echo $myrow["fstats"] ?>" selected><?php echo $myrow["fstats"]; ?></option>
          <option value="-">-</option>
          <option value="Monthly">Monthly</option>
          <option value="Quarterly">Quarterly</option>
          <option value="Annually">Annually</option>
          <option value="">N/A</option>
        </select>
</td>
</tr>
<tr>
      <td align=right>QB Password:</td>
  <td>
    <input type="text" name="qb" size="10" value="<?php echo $myrow["qb"]; ?>"></td>
      <td align="right">Sales Tax:  </td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="stax"  value="on" <?php if($myrow["stax"]=="on"){echo "checked";} ?>></td>
    </tr>
    <tr>
      <td colspan=2> </td>
      <td align="right">Payroll:  </td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="payroll"  value="on" <?php if($myrow["payroll"]=="on"){echo "checked";} ?>></td>
</tr>
  <tr>
      <td colspan=2> </td>
      <td align="right">Retainer:  </td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="retainer"  value="on" <?php if($myrow["retainer"]!=""){echo "checked";} ?>></td>
</tr>
<table>
<table cellspacing="8">
<tr><td><b>Completed Tax Years:  </b></td>
      <td align="right">2009</td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="tx2009"  value="on" <?php if($myrow["tx2009"]=="on"){echo "checked";} ?>></td>
  <td align="right">Amount Charged:</td>
  <td><input type="text" name="chg2009" value="<?php echo $myrow["chg2009"]; ?>" size="8" maxlength="8" onKeyPress="return(currencyFormat(this,',','.',event))"></td>
      <td align="right">2008</td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="tx2008"  value="on" <?php if($myrow["tx2008"]=="on"){echo "checked";} ?>></td>
  <td align="right">Amount Charged:</td>
  <td><input type="text" name="chg2008" value="<?php echo $myrow["chg2008"]; ?>" size="8" maxlength="8" onKeyPress="return(currencyFormat(this,',','.',event))"></td>
</tr>
</table>
<table>
  <tr>
</tr>
<tr>
<td colspan=2> </td>
<td><b>Status Update</b></td>
    </tr>
    <tr>
      <td> </td>
<td>Personal</td>
      <td colspan=2>
        <select name="status1">
          <option value="-" selected>-</option>
          <option value="Completed">Completed</option>
          <option value="In Review">In Review</option>
          <option value="In Process">In Process</option>
          <option value="Back From GKM">Back From GKM</option>
          <option value="Sent to GKM">Sent to GKM</option>
          <option value="Files Recieved">Files Recieved</option>
          <option value="Awaiting Source Docs">Awaiting Source Docs</option>
          <option value="Extension Filed">Extension Filed</option>
          <option value="On Hold/Past Due">On Hold/Past Due</option>
          <option value="Cancelled">Cancelled</option>
          <option value="-">N/A</option>
        </select>
      </td>
    </tr>
    <tr>
      <td> </td>
<td>Business</td>
      <td colspan=2>
        <select name="status2">
          <option value="-" selected>-</option>
          <option value="Completed">Completed</option>
          <option value="In Review">In Review</option>
          <option value="In Process">In Process</option>
          <option value="Back From GKM">Back From GKM</option>
          <option value="Sent to GKM">Sent to GKM</option>
          <option value="Awaiting Source Docs">Awaiting Source Docs</option>
          <option value="Extension Filed">Extension Filed</option>
          <option value="On Hold/Past Due">On Hold/Past Due</option>
          <option value="Cancelled">Cancelled</option>
          <option value="-">N/A</option>
        </select>
      </td>
    </tr>
    <tr>
      <td> </td>
<td>Retainer</td>
      <td colspan=2>
        <select name="status4">
          <<option value="-" selected>-</option>
          <option value="Completed">Completed</option>
          <option value="In Review">In Review</option>
          <option value="In Process">In Process</option>
          <option value="Back from GKM">Back from GKM</option>
          <option value="Sent to GKM">Sent to GKM</option>
          <option value="Files Recieved">Files Recieved</option>
          <option value="Awaiting Source Docs">Awaiting Source Docs</option>
          <option value="On Hold/Past Due">On Hold/Past Due</option>
          <option value="Cancelled">Cancelled</option>
          <option value="-">N/A</option>
        </select>
      </td>
    </tr>
    <tr>
<td>Notes: </td>
      <td colspan=3>
        <textarea name="newnotes" rows="5" cols="47"></textarea>
      </td>
    </tr>
  </table>
    <br>
    <input type="Submit" name="update" value="Update information">
  </form>
    <br>
    <input type="button" onclick="if(confirm('Are you sure you want to delete a record')) document,location.href='delete<?php echo $page_ext; ?>?id=<?php echo $myrow["id"]; ?>';" name="id" value="Delete information">
  <?php

  } else
    echo "<br><br>Editing is disabled.\n";
}

GreenSmurf · March 5, 2009

else
{
  if(! $read_only)
  {
?>
  <form method="post" action="edit<?php echo $page_ext; ?>">

  <table width="380" border="0" cellspacing="1" cellpadding="1">
    <tr>
      <td>
        <input type="hidden" name="id">
        Firstname: </td>
      <td colspan=2>
        <input type="Text" name="firstname" size="35">
      </td>
  <td>MI: </td>
      <td>
        <input type="Text" name="M1" size="1" value="<?php echo $myrow["M1"]?>">
      </td>
      <td>Client ID: </td>
      <td colspan=2>
        <input type="Text" name="clientID" size="12">
      </td>
    </tr>
    <tr>
      <td>Lastname: </td>
      <td colspan=2>
        <input type="Text" name="lastname" size="35">
      </td>
      <td>SS #: </td>
      <td>
        <input type="Text" name="ssnum1" size="9">
      </td>
  <td>EIN: </td>
      <td>
      <input type="Text" name="ein" size="14">
      </td>
      <tr>
      <td>Client Type: </td>
      <td>
      <select name="bustype">
          <option value="-" selected>-</option>
          <option value="Personal">Personal</option>
          <option value="C Corporation">C Corporation</option>
          <option value="Partnership, LLC">Partnership, LLC</option>
          <option value="S Corp">S Corp</option>
          <option value="LLC">LLC</option>
          <option value="Estate & Trust">Estate & Trust</option>
          <option value="Non-Profit">Non-Profit</option>
          <option value="Sole Proprietor">Sole Proprietor</option>
          <option value="Single Member LLC">Single Member LLC</option>
          <option value="">N/A</option>
        </select>
      </td>
      <td>Business: </td>
      <td colspan=5>
        <input type="Text" name="boss" size="35">
      </td>
    </tr>
    <tr>
      <td><b><u>Attention</b></u></td>
      <td colspan=6>
        <textarea rows="2" cols="65" name="comment"></textarea>
      </td>
    </tr>
    </table>
    <table>
    <tr>
      <td rowspan=4>Address: </td>
      <td rowspan=4>
          <textarea name="address" rows="5" cols="35"></textarea>
      </td>
    </tr>
      <tr>
          <td> </td>
          <td>City: </td>
          <td><input type="text" name="city" size="31"></td>
      </tr>
      <tr>
          <td> </td>
          <td>State: </td>
          <td><select name="state" size="1">
          <option value="-" selected>-</option>
          <option value="AK">AK</option>
          <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="AZ">AZ</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="CT">CT</option>
          <option value="DC">DC</option>
          <option value="DE">DE</option>
          <option value="FL">FL</option>
          <option value="GA">GA</option>
          <option value="HI">HI</option>
          <option value="IA">IA</option>
          <option value="ID">ID</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MA">MA</option>
          <option value="MD">MD</option>
          <option value="ME">ME</option>
          <option value="MI">MI</option>
          <option value="MN">MN</option>
          <option value="MO">MO</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="NC">NC</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NH">NH</option>
          <option value="NJ">NJ</option>
          <option value="NM">NM</option>
          <option value="NV">NV</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OR">OR</option>
          <option value="PA">PA</option>
          <option value="RI">RI</option>
          <option value="SC">SC</option>
          <option value="SD">SD</option>
          <option value="TN">TN</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="VA">VA</option>
          <option value="VT">VT</option>
          <option value="WA">WA</option>
          <option value="WI">WI</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option></select>
        </td>
       </tr>
       <tr>
          <td> </td>
          <td>ZIP: </td>
          <td><input type="text" name="zip" size="9"></td>
      </tr>
  </table>
  <table>
    <tr>
      <td><b>Telephone: </b></td>
      <td colspan=3 align="center"><small>Please enter a valid contact number (must contain numbers only)</small></td>
    </tr>
    <tr>
      <td>Home:</td>
      <td>
        <input type="Text" name="home">
      </td>
      <td>Mobile:</td>
      <td>
        <input type="Text" name="mobile">
      </td>
    </tr>
    <tr>
      <td>Work: </td>
      <td>
        <input type="Text" name="work">
      </td>
      <td>Ext:</td>
      <td>
        <input type="Text" name="ext" size="6">
      </td>
    </tr>
    <tr>
      <td>Fax:</td>
      <td>
        <input type="Text" name="fax">
      </td>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
      <td>Email: </td>
      <td>
        <input type="Text" name="email" size="35">
      </td>
    </tr>
  </table>
  <table>
    <tr>
      <td>Birthday:</td>
      <td>
        <select name="bday">
          <option value="0" selected>-</option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="24">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
        <select name="bmonth">
          <option value="-" selected>-</option>
          <option value="January">January</option>
          <option value="February">February</option>
          <option value="March">March</option>
          <option value="April">April</option>
          <option value="May">May</option>
          <option value="June">June</option>
          <option value="July">July</option>
          <option value="August">August</option>
          <option value="September">September</option>
          <option value="October">October</option>
          <option value="November">November</option>
          <option value="December">December</option>
        </select>
        <input type="Text" name="byear" size="4" maxlength="4">
      </td>
    </tr>
  </table>
  <table>
    <tr>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
      <td colspan=3><b>Secondary:</b></td>
    </tr>
    <tr>
      <td>Firstname: </td>
      <td>
        <input type="Text" name="firstname2" size="35">
      </td>
  <td>MI: </td>
      <td>
        <input type="Text" name="M2" size="1" value="<?php echo $myrow["M2"]?>">
      </td>
    </tr>
    <tr>
      <td>Lastname: </td>
      <td>
        <input type="Text" name="lastname2" size="35">
      </td>
  <td>SS #: </td>
      <td colspan=3>
        <input type="Text" name="ssnum2" size="9">
      </td>
    </tr>
</table>
    <table>
    <tr>
      <td rowspan=4>Address: </td>
          <td rowspan=4>
              <textarea name="address2" rows="5" cols="35"></textarea>
          </td>
    </tr>
      <tr>
          <td> </td>
          <td>City: </td>
          <td><input type="text" name="city2" size="31"></td>
      </tr>
      <tr>
          <td> </td>
          <td>State: </td>
          <td>
              <select name="state2" size="1">
              <option value="-" selected>-</option>
          <option value="AK">AK</option>
          <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="AZ">AZ</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="CT">CT</option>
          <option value="DC">DC</option>
          <option value="DE">DE</option>
          <option value="FL">FL</option>
          <option value="GA">GA</option>
          <option value="HI">HI</option>
          <option value="IA">IA</option>
          <option value="ID">ID</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MA">MA</option>
          <option value="MD">MD</option>
          <option value="ME">ME</option>
          <option value="MI">MI</option>
          <option value="MN">MN</option>
          <option value="MO">MO</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="NC">NC</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NH">NH</option>
          <option value="NJ">NJ</option>
          <option value="NM">NM</option>
          <option value="NV">NV</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OR">OR</option>
          <option value="PA">PA</option>
          <option value="RI">RI</option>
          <option value="SC">SC</option>
          <option value="SD">SD</option>
          <option value="TN">TN</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="VA">VA</option>
          <option value="VT">VT</option>
          <option value="WA">WA</option>
          <option value="WI">WI</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option></select>
        </td>
       </tr>
       <tr>
          <td> </td>
          <td>ZIP: </td>
          <td><input type="text" name="zip2" size="9"></td>
      </tr>
  </table>
  <table>
    <tr>
      <td>Home:</td>
      <td>
        <input type="Text" name="phone2">
      </td>
      <td>Mobile:</td>
      <td>
        <input type="Text" name="mobile2">
      </td>
    </tr>
    <tr>
      <td>Work: </td>
      <td>
        <input type="Text" name="work2">
      </td>
      <td>Ext:</td>
      <td>
        <input type="Text" name="ext2" size="6">
      </td>
    </tr>
    <tr>
      <td>Email: </td>
      <td>
        <input type="Text" name="email2" size="35">
      </td>
    </tr>
  </table>
  <table>
    <tr>
      <td>Birthday:</td>
      <td>
        <select name="bday2">
          <option value="0" selected>-</option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="24">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
        <select name="bmonth2">
          <option value="-" selected>-</option>
          <option value="January">January</option>
          <option value="February">February</option>
          <option value="March">March</option>
          <option value="April">April</option>
          <option value="May">May</option>
          <option value="June">June</option>
          <option value="July">July</option>
          <option value="August">August</option>
          <option value="September">September</option>
          <option value="October">October</option>
          <option value="November">November</option>
          <option value="December">December</option>
        </select>
        <input type="Text" name="byear2" size="4" maxlength="4">
      </td>
    </tr>
  </table>
  <table>
    <tr>
      <td colspan=4><b><br><br>Account Info</b></td>
    </tr>
   <tr>
      <td align="right">Sales Rep: </td>
      <td>
      <input type="text" name="salesrep" size="35">
      </td>
      <td> </td>
      <td> </td>
    </tr>
       <tr>
      <td align="right">Payroll Rep: </td>
      <td>
      <input type="text" name="payrep" size="35">
      </td>
      <td> </td>
      <td> </td>
    </tr>
    <tr>
        <td align="right">Accountant: </td>
      <td>
        <input type="Text" name="accnt" size="35">
      </td>
    </tr>
    <tr><td/></tr>
    <tr><td/></tr>
    <tr>
<td><b>Bookkeepsing Services: </b></td>
<td><select name="qbserv">
          <option value="-" selected>-</option>
          <option value="QB Supplied to Accountant">QB Supplied to Accountant</option>
          <option value="QB Data Entry by Accountant">QB data entry by Accountant</option>
          <option value="QB Training">QB Training</option>
	  <option value="QB Online">QB Online</option>
          <option value="Creative Solutions">Creative Solutions</option>
          <option value="Tax Return">Tax Return</option>
          <option value="">N/A</option>
        </select>
</td>
	<td>Financial Statements: </td>
    <td><select name="fstats">
          <option value="-" selected>-</option>
          <option value="Monthly">Monthly</option>
          <option value="Quarterly">Quarterly</option>
          <option value="Annually">Annually</option>
          <option value="">N/A</option>
        </select>
</td>
</tr>
<tr>
      <td align=right>QB Password:</td>
  <td>
    <input type="text" name="qb" size="10"></td>
      <td align="right">Sales Tax:  </td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="stax"  value="on"></td>
</tr>
<tr>
      <td colspan=2> </td>
      <td align="right">Payroll:  </td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="payroll"  value="on"></td>
</tr>
  <tr>
      <td colspan=2> </td>
      <td align="right">Retainer:  </td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="retainer"  value="on"></td>
</tr>
	<table>
<table cellspacing="8">
<tr><td><b>Completed Tax Years:  </b></td>
      <td align="right">2009</td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="tx2009"  value="on"></td>
  <td align="right">Amount Charged:</td>
  <td><input type="text" name="chg2009" size="8" maxlength="8" onKeyPress="return(currencyFormat(this,',','.',event))"></td>
      <td align="right">2008</td>
      <td><!-- <input type="checkbox" name="stax"></td> -->
      <input type="checkbox" name="tx2008"  value="on"></td>
  <td align="right">Amount Charged:</td>
  <td><input type="text" name="chg2008" size="8" maxlength="8" onKeyPress="return(currencyFormat(this,',','.',event))"></td>
</form>
</tr>
</table>
<table>
<tr>
<td colspan=2> </td>
<td><b>Status Update</b></td>
    </tr>
    <tr>
      <td> </td>
<td>Personal</td>
      <td colspan=2>
        <select name="status1">
          <option value="-" selected>-</option>
          <option value="Completed">Completed</option>
          <option value="In Review">In Review</option>
          <option value="In Process">In Process</option>
          <option value="Back From GKM">Back From GKM</option>
          <option value="Sent to GKM">Sent to GKM</option>
          <option value="Files Recieved">Files Recieved</option>
          <option value="Awaiting Source Docs">Awaiting Source Docs</option>
          <option value="Extension Filed">Extension Filed</option>
          <option value="On Hold/Past Due">On Hold/Past Due</option>
          <option value="Cancelled">Cancelled</option>
          <option value="">N/A</option>
        </select>
      </td>
    </tr>
    <tr>
      <td> </td>
<td>Business</td>
      <td colspan=2>
        <select name="status2">
          <option value="-" selected>-</option>
          <option value="Completed">Completed</option>
          <option value="In Review">In Review</option>
          <option value="In Process">In Process</option>
          <option value="Back From GKM">Back From GKM</option>
          <option value="Sent to GKM">Sent to GKM</option>
          <option value="Files Recieved">Files Recieved</option>
          <option value="Awaiting Source Docs">Awaiting Source Docs</option>
          <option value="Extension Filed">Extension Filed</option>
          <option value="On Hold/Past Due">On Hold/Past Due</option>
          <option value="Cancelled">Cancelled</option>
          <option value="">N/A</option>
        </select>
      </td>
    </tr>
    <tr>
      <td> </td>
<td>Retainer</td>
      <td colspan=2>
        <select name="status4">
          <<option value="-" selected>-</option>
          <option value="Completed">Completed</option>
          <option value="In Review">In Review</option>
          <option value="In Process">In Process</option>
          <option value="Sent to GKM">Sent to GKM</option>
          <option value="Files Recieved">Files Recieved</option>
          <option value="Awaiting Source Docs">Awaiting Source Docs</option>
          <option value="On Hold/Past Due">On Hold/Past Due</option>
          <option value="Cancelled">Cancelled</option>
          <option value="">N/A</option>
        </select>
      </td>
    </tr>
    <tr>
<td>Notes: </td>
      <td colspan=3>
        <textarea name="newnotes" rows="5" cols="47"></textarea>
      </td>
    </tr>
  </table>
    <br>
    <input type="Submit" name="submit" value="Enter information">
  </form>
<?php
  } else
    echo "<br><br>Editing is disabled.\n";
}

include ("include/footer.inc.php");
?>

GreenSmurf · March 5, 2009

That is the rest of the code that is in that particular PHP file. The other files should not matter too much- the only one I can see being an issue is the Javascript. Let me know where to look thanks!

-Brandon

trq · March 5, 2009

Note I said 'the relevent processing code'?

You need to at least attempt to narrow the problem down to a reasonable amount of code.

GreenSmurf · March 5, 2009

The problem is I had to slap together a bunch of new things into the code to meet a deadline and am unsure what changes/code I made that could have caused the error. I will post more tomorrow when I track down the old code to compare.

-Brandon

GreenSmurf · March 17, 2009

Found the error. Turns out I accidentally added an extra

</form>

in the code making the 'Enter Information' button void. Thanks to anyone who replied and helped. Asking me to go back and find relevant code is how I found the error. I simply looked at the changes made between the working and nonworking versions of the script.

-B

Sign In

[SOLVED] Need help with submit button! labeled 'Enter Information'

Recommended Posts

GreenSmurf

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

GreenSmurf

Link to comment

Share on other sites

GreenSmurf

Link to comment

Share on other sites

GreenSmurf

Link to comment

Share on other sites

GreenSmurf

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

GreenSmurf

Link to comment

Share on other sites

GreenSmurf

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information