PHP unexpected EOF

Hi I have been working on this for a while, it's not a complicated script, but I've been looking at it for ages and I'm sure I'm missing something really simple.

I think a pair of fresh eyes will greatly help.

Thank for your help.

<?php 
session_start();
//main.php
require_once('connection.php');
if(isset($_SESSION['user']))
{

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
$id = $_GET['ID'];
$sql="SELECT * FROM harvest WHERE ID='$ID'";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);

$title=$row[title];
$fname = $row[f_name];
$sname = $row[s_name];
$dob = explode("/",$row[DOB]);
$dob_d = $dob[0];
$dob_m = $dob[1];
$dob_y = $dob[2];

$marital = $row[marital];

$add1 = $row[house];
$add2 = $row[street];
$add3 = $row[city];
$postcode = $row[postcode];

$tel1 = $row[m_tel];
$tel2 = $row[h_tel];

$email = $row[email];

$appt = explode("-",$row[ApptDate]);

$appt_d = $appt[2];
$appt_m = $appt[1]; 
$appt_y = $appt[0];

$apptT = explode(":",$row[ApptTime]);

$appt_h = $apptT[0];
$appt_m = $apptT[1];

$status = $row[Status];

$accepted = explode("-",$row['AcceptedDate']);
$acc_D = $accepted[2];
$acc_M = $accepted[1];
$acc_Y = $accepted[0]; 

$rejRea = $row[RejectionReason];

$solution = $row[Solution];

$solVal = $row[Value];

$firstVal = $row[FirstPaymentValue];

$addedCost = $row[AddedCost];

$compOwed = $row[CompaniesOwed];

$debtAmount = $row[DebtAmmount];

$partnerDebt = $row[PartnerDebt];

$partnerWork = $row[PartnerWork];

$partnerBenefits = $row[PartnerBenefits];

$firstPaymentDate = explode("-",$row[FirstPaymentDate]);

$fp_day = $firstPaymentDate[2];
$fp_month = $firstPaymentDate[1];
$fp_year = $firstPaymentDate[0];


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit page OBFTS</title>
</head>

<body>

<div id="edit_container">
 

<strong>Name</strong>
<br />
<form id="edit_customer" action="update.php">
<input name="title"/>


<input name="first_name"/>


<input name="last_name"/>

<br  class="clearfix"/>
<strong>Date of Birth </strong>
<br  />
<input name="day" value="<?php echo $dob_d; ?>" />
<input name="month" value="<?php echo $dob_m; ?>" />
<input name="year" value="<?php echo $dob_y; ?>" />

<br  class="clearfix"/>
<strong>Marital:</strong> <br  />
<select name="marital">
<option value="single" <?php if($marital=='single'){?> selected="selected"<?php } ?>>Single</option>
<option value="divorced" <?php if($marital=='divorced'){?> selected="selected"<?php } ?> >Divorced</option>
<option value="married" <?php if($marital=='married'){?> selected="selected"<?php } ?> >Married</option>
<option value="together" <?php if($marital=='together'){?> selected="selected"<?php } ?> >Living together</option>
<option value="Widowed" <?php if($marital=='widowed'){?> selected="selected"<?php } ?> >Widowed</option>
<option value="Separated" <?php if($marital=='Seperated'){?> selected="selected"<?php } ?> >Separated</option>
 </select>
 <br  class="clearfix"/>
 
<strong>Address:</strong> <br  />
<input  name="add1" value="<?php echo $add1; ?>"/><br  />
<input  name="add2" value="<?php echo $add2; ?>"/><br  />
<input  name="add3" value="<?php echo $add3; ?>"/> <br />
<input  name="postcode" value="<?php echo $postcode; ?>" />
<br class="clearfix" />

<strong>Telephone Numbers</strong> <br  />
<input name="tel1" value="<?php echo $tel1; ?>"/>
<input name="tel2" value="<?php echo $tel2; ?>"/>

<br  class="clearfix"/>
<strong>Email</strong><br />
<input name="email"  value="<?php echo $email; ?>"/> />
<br  />
<textarea name="notes" cols="50" rows="15" >Notes</textarea>

<br class="clearfix" />
<h2>Callback/Appointment Details</h2>
<strong>Appointment Date</strong><br />
<select name="appt_day">


<option value="">dd</option>
<?php
					$i =01;
					while ($i <= 31) {
						echo "<option  value=\" $i \"";  if($i == $appt_d) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 
					}

?>
 </select>
<select name="appt_month"><option  value=""></option>
<?php
					$i =01;
					while ($i <= 12) {
						echo "<option  value=\" $i \"";  if($i == $appt_m) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 

					}
?>

 </select>
<select name="appt_year"><option value="" selected="selected"></option>

<?php
					$i =2011;
					while ($i <= 2014) {
						echo "<option  value=\" $i \"";  if($i == $appt_y) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 

					}
?>

 </select>
<br class="clearfix" />


<strong>Appointment Time</strong><br />
<select name="appt_hours"><option value=""> </option>
<?php
					
					$i =00;
					while ($i <= 23) {
						echo "<option  value=\" $i \"";  if($i == $appt_h) { echo "selected=\"selected\""; }  echo ">$i</option>";
						$i++; 

					}
?>

 </select>
<select name="appt_mins"><option value=""></option>


<?php
					
					$i =00;
					while ($i <= 59) {
						echo "<option  value=\" $i \"";  if($i == $appt_m) { echo "selected=\"selected\""; }  echo ">$i</option>";
						$i++; 

					}
?>

 </select>

<br class="clearfix">

<textarea name="appt_notes" cols="50" rows="15"> </textarea>

<br class="clearfix" />

<h2>Call Details</h2>
<strong>Call Status </strong> <br />
<select name="callStatus"> 
<option value=""></option>
<option <?php if($status == signed ) {?> selected="selected"<?php } ?>  value="signed">Signed</option>
<option value="cf" <?php if($status == 'cf' ) {?> selected="selected"<?php } ?> >CF</option>
<option value="pbo" <?php if($status == 'pbo' ) {?> selected="selected"<?php } ?> >PBO</option>
</select>
<br class="clearfix">

<strong>Accepted Date</strong> <br />
<input name="acc_day" value="<?php echo $acc_D; ?>" />
<input name="acc_month" value="<?php echo $acc_M; ?>" />
<input name="acc_year" value="<?php echo $acc_Y; ?>">

<br class="clearfix" />

<strong>Rejection reason</strong> <br />
<select name="rejReason"><option value=""></option>
<option value="1c" <?php if($rejRea == "1c" ) {?> selected="selected"<?php } ?>>Only one creditor</option>
<option value="ni" <?php if($rejRea == "ni" ) {?> selected="selected"<?php } ?>>Not interested</option>
<option value="ca" <?php if($rejRea == "ca" ) {?> selected="selected"<?php } ?>>Can't afford min</option>
<option value="fees" <?php if($rejRea == "fees" ) {?> selected="selected"<?php } ?>>fees</option>
<option value="wcb" <?php if($rejRea == "wcb" ) {?> selected="selected"<?php } ?>>Won't change bank</option>
<option value="nc" <?php if($rejRea == "nc" ) {?> selected="selected"<?php } ?>>No Contact</option>
<option value="bos" <?php if($rejRea == "bos" ) {?> selected="selected"<?php } ?>>bos</option>
</select>

<br class="clearfix" />

<strong>Solution</strong> <br />
<select name="solution">
<option value=""></option>
<option value="dmp" <?php if($Solution == "dmp" ) {?> selected="selected"<?php } ?> >DMP</option>
<option value="ppi" <?php if($Solution == "ppi" ) {?> selected="selected"<?php } ?> >PPI</option>
<option value="lf" <?php if($Solution == "lf" ) {?> selected="selected"<?php } ?> >Loan Referral</option>
</select>

<br class="clearfix" />

<strong>Solution Value</strong> <br />
<input type="text" name="solutionValue" value="<?php echo $solVal; ?>" />

<br class="clearfix"/>


<strong>First Payment Value</strong> <br />
<input type="text" name="firstPaymentValue" value="<?php echo $firstVal; ?>" />

<br class="clearfix"/>

<strong>Added Cost</strong> <br />
<input type="text" name="addedCost" value="<?php echo $addedCost; ?>" />

<br class="clearfix"/>


<strong>First Payment Date</strong> <br />  
<input type="text" name="fp_day"  <?php if ($fp_day != "")  {?> value="dd" <?php } else {?> value="<?php echo $fp_day; ?>"  />
<input type="text" name="fp_month" <?php if ($fp_month != "")  {?> value="mm" <?php } else {?> value="<?php echo $fp_month; ?>" />
<input type="text" name="fp_month" <?php if ($fp_year != "")  {?> value="yyyy" <?php } else {?> value="<?php echo $fp_year; ?>" />

<br class="clearfix"/>

<h2>Debts </h2>

<strong>Debt Amount </strong><br />
<select name="debtAmount">
<option value="">Not Set</option>
<option value="1" <?php if($debtAmount == "1" ) {?> selected="selected"<?php } ?>>under &pound;2,000</option>
<option value="2"<?php if($debtAmount == "2" ) {?> selected="selected"<?php } ?>> &pound;2,000 - &pound;5,000</option>
<option value="3" <?php if($debtAmount == "3" ) {?> selected="selected"<?php } ?>>&pound;5,000 - &pound;10,000</option>
<option value="4" <?php if($debtAmount == "4" ) {?> selected="selected"<?php } ?>>&pound;10,000 - &pound;15,000</option>
<option value="5" <?php if($debtAmount == "5" ) {?> selected="selected"<?php } ?>>&pound;15,000 - &pound;25,000</option>
<option value="6" <?php if($debtAmount == "6" ) {?> selected="selected"<?php } ?>>&pound;25,000 - &pound;50,000</option>
<option value="7" <?php if($debtAmount == "7" ) {?> selected="selected"<?php } ?>>&pound;50,000 - &pound;75,000</option>
<option value="8" <?php if($debtAmount == "8" ) {?> selected="selected"<?php } ?>>&pound;75,000 - &pound;100,000</option>
<option value="9" <?php if($debtAmount == "9" ) {?> selected="selected"<?php } ?>>&pound;100,000+</option>
</select>

<strong>Companies Owed </strong><br />
<select name="companiesOwed">
<option value="">Not Set</option>
<?php
					
					$i =00;
					while ($i <= 20) {
						echo "<option  value=\" $i \"";  if($i == $compOwed) { echo "selected=\"selected\""; } echo ">$i</option>";
						$i++; 
					}

?>

</select>

<strong>Partner Debt</strong><br />
<select name="partnerDebt">
<option value="">Not Set</option>
<option value="yes" <?php if($partnerDebt == "yes") { echo "selected=\"selected\""; } ?>>yes</option>
<option value="no" <?php if($partnerDebt == "no") { echo "selected=\"selected\""; } ?>>No</option> 
</select>

<strong>Partner Work</strong><br />
<select name="partnerWork">
<option value="">Not Set</option>
<option value="yes" <?php if($partnerWork == "yes") { echo "selected=\"selected\""; } ?>>Yes</option>
<option value="no" <?php if($partnerWork == "no") { echo "selected=\"selected\""; } ?>>No</option> 
</select>

<strong>Partner Benefits</strong><br />
<select name="partnerBenefits">
<option value="">Not Set</option>
<option value="yes" <?php if($partnerBenefits == "yes") { echo "selected=\"selected\""; } ?>>Yes</option>
<option value="no" <?php if($partnerBenefits == "no") { echo "selected=\"selected\""; } ?>>No</option> 
</select>

<input type="submit" value="Update">

</form>
  
  
</div>

</body>
</html>

<?php }

else {
header("location:index.php");
}

?>

Open in new window

EverlearnerAsked:
Who is Participating?
 
Ray PaseurConnect With a Mentor Commented:
A parse error for an unexpected end of script is often caused by a missing curly brace or a HEREDOC (or NOWDOC) block that is not closed.

Line 77 has quotes:
print<<<'HTML'

Line 359 has no quotes:
HTML;

The man page is here:
http://php.net/manual/en/language.types.string.php
0
 
Marco GasiConnect With a Mentor FreelancerCommented:
When there are many php tags within a html document can happens some problem. Using Netbeans IDE (www.netbeans.org) eof problem is highlighted but analyzing your code I can't get rid of that. So I tried to use heredoc notation and now I have no errors: try to see if it work correctly. I attach the code in the snippet box.

Cheers
<?php
session_start();
//main.php
require_once('connection.php');
if (isset($_SESSION['user'])) {

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
    $id = $_GET['ID'];
    $sql = "SELECT * FROM harvest WHERE ID='$ID'";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);

    $title = $row[title];
    $fname = $row[f_name];
    $sname = $row[s_name];
    $dob = explode("/", $row[DOB]);
    $dob_d = $dob[0];
    $dob_m = $dob[1];
    $dob_y = $dob[2];

    $marital = $row[marital];

    $add1 = $row[house];
    $add2 = $row[street];
    $add3 = $row[city];
    $postcode = $row[postcode];

    $tel1 = $row[m_tel];
    $tel2 = $row[h_tel];

    $email = $row[email];

    $appt = explode("-", $row[ApptDate]);

    $appt_d = $appt[2];
    $appt_m = $appt[1];
    $appt_y = $appt[0];

    $apptT = explode(":", $row[ApptTime]);

    $appt_h = $apptT[0];
    $appt_m = $apptT[1];

    $status = $row[Status];

    $accepted = explode("-", $row['AcceptedDate']);
    $acc_D = $accepted[2];
    $acc_M = $accepted[1];
    $acc_Y = $accepted[0];

    $rejRea = $row[RejectionReason];

    $solution = $row[Solution];

    $solVal = $row[Value];

    $firstVal = $row[FirstPaymentValue];

    $addedCost = $row[AddedCost];

    $compOwed = $row[CompaniesOwed];

    $debtAmount = $row[DebtAmmount];

    $partnerDebt = $row[PartnerDebt];

    $partnerWork = $row[PartnerWork];

    $partnerBenefits = $row[PartnerBenefits];

    $firstPaymentDate = explode("-", $row[FirstPaymentDate]);

    $fp_day = $firstPaymentDate[2];
    $fp_month = $firstPaymentDate[1];
    $fp_year = $firstPaymentDate[0];
    

print<<<_HTML_
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
            <title>Edit page OBFTS</title>
        </head>

        <body>

            <div id="edit_container">


                <strong>Name</strong>
                <br />
                <form id="edit_customer" action="update.php">
                    <input name="title"/>


                    <input name="first_name"/>


                    <input name="last_name"/>

                    <br  class="clearfix"/>
                    <strong>Date of Birth </strong>
                    <br  />
                    <input name="day" value=" echo $dob_d; " />
                    <input name="month" value=" echo $dob_m; " />
                    <input name="year" value=" echo $dob_y; " />

                    <br  class="clearfix"/>
                    <strong>Marital:</strong> <br  />
                    <select name="marital">
                        <option value="single"  if ($marital == 'single') {  selected="selected" } >Single</option>
                        <option value="divorced"  if ($marital == 'divorced') {  selected="selected" }  >Divorced</option>
                        <option value="married"  if ($marital == 'married') {  selected="selected" }  >Married</option>
                        <option value="together"  if ($marital == 'together') {  selected="selected" }  >Living together</option>
                        <option value="Widowed"  if ($marital == 'widowed') {  selected="selected" }  >Widowed</option>
                        <option value="Separated"  if ($marital == 'Seperated') {  selected="selected" }  >Separated</option>
                    </select>
                    <br  class="clearfix"/>

                    <strong>Address:</strong> <br  />
                    <input  name="add1" value=" echo $add1; "/><br  />
                    <input  name="add2" value=" echo $add2; "/><br  />
                    <input  name="add3" value=" echo $add3; "/> <br />
                    <input  name="postcode" value=" echo $postcode; " />
                    <br class="clearfix" />

                    <strong>Telephone Numbers</strong> <br  />
                    <input name="tel1" value=" echo $tel1; "/>
                    <input name="tel2" value=" echo $tel2; "/>

                    <br  class="clearfix"/>
                    <strong>Email</strong><br />
                    <input name="email"  value=" echo $email; "/> />
                    <br  />
                    <textarea name="notes" cols="50" rows="15" >Notes</textarea>

                    <br class="clearfix" />
                    <h2>Callback/Appointment Details</h2>
                    <strong>Appointment Date</strong><br />
                    <select name="appt_day">


                        <option value="">dd</option>
    
    $i = 01;
    while ($i <= 31) {
        echo "<option  value=\" $i \"";
        if ($i == $appt_d) {
            echo "selected=\"selected\"";
        } echo ">$i</option>";
        $i++;
    }
    
                    </select>
                    <select name="appt_month"><option  value=""></option>
                        
                        $i = 01;
                        while ($i <= 12) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        

                    </select>
                    <select name="appt_year"><option value="" selected="selected"></option>

                        
                        $i = 2011;
                        while ($i <= 2014) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_y) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        

                    </select>
                    <br class="clearfix" />


                    <strong>Appointment Time</strong><br />
                    <select name="appt_hours"><option value=""> </option>
                        
                        $i = 00;
                        while ($i <= 23) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_h) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        

                    </select>
                    <select name="appt_mins"><option value=""></option>


                        
                        $i = 00;
                        while ($i <= 59) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        

                    </select>

                    <br class="clearfix">

                        <textarea name="appt_notes" cols="50" rows="15"> </textarea>

                        <br class="clearfix" />

                        <h2>Call Details</h2>
                        <strong>Call Status </strong> <br />
                        <select name="callStatus"> 
                            <option value=""></option>
                            <option  if ($status == signed) {  selected="selected" }   value="signed">Signed</option>
                            <option value="cf"  if ($status == 'cf') {  selected="selected" }  >CF</option>
                            <option value="pbo"  if ($status == 'pbo') {  selected="selected" }  >PBO</option>
                        </select>
                        <br class="clearfix">

                            <strong>Accepted Date</strong> <br />
                            <input name="acc_day" value=" echo $acc_D; " />
                            <input name="acc_month" value=" echo $acc_M; " />
                            <input name="acc_year" value=" echo $acc_Y; " />

                                <br class="clearfix" />

                                <strong>Rejection reason</strong> <br />
                                <select name="rejReason"><option value=""></option>
                                    <option value="1c"  if ($rejRea == "1c") {  selected="selected" } >Only one creditor</option>
                                    <option value="ni"  if ($rejRea == "ni") {  selected="selected" } >Not interested</option>
                                    <option value="ca"  if ($rejRea == "ca") {  selected="selected" } >Can't afford min</option>
                                    <option value="fees"  if ($rejRea == "fees") {  selected="selected" } >fees</option>
                                    <option value="wcb"  if ($rejRea == "wcb") {  selected="selected" } >Won't change bank</option>
                                    <option value="nc"  if ($rejRea == "nc") {  selected="selected" } >No Contact</option>
                                    <option value="bos"  if ($rejRea == "bos") {  selected="selected" } >bos</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution</strong> <br />
                                <select name="solution">
                                    <option value=""></option>
                                    <option value="dmp"  if ($Solution == "dmp") {  selected="selected" }  >DMP</option>
                                    <option value="ppi"  if ($Solution == "ppi") {  selected="selected" }  >PPI</option>
                                    <option value="lf"  if ($Solution == "lf") {  selected="selected" }  >Loan Referral</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution Value</strong> <br />
                                <input type="text" name="solutionValue" value=" echo $solVal; " />

                                <br class="clearfix"/>


                                <strong>First Payment Value</strong> <br />
                                <input type="text" name="firstPaymentValue" value=" echo $firstVal; " />

                                <br class="clearfix"/>

                                <strong>Added Cost</strong> <br />
                                <input type="text" name="addedCost" value=" echo $addedCost; " />

                                <br class="clearfix"/>


                                <strong>First Payment Date</strong> <br />  
                                <input type="text" name="fp_day"   if ($fp_day != "") {  value="dd"  } else {  value=" echo $fp_day; "  />
                                    <input type="text" name="fp_month"  if ($fp_month != "") {  value="mm"  } else {  value=" echo $fp_month; " />
                                        <input type="text" name="fp_month"  if ($fp_year != "") {  value="yyyy"  } else {  value=" echo $fp_year; " />

                                            <br class="clearfix"/>

                                            <h2>Debts </h2>

                                            <strong>Debt Amount </strong><br />
                                            <select name="debtAmount">
                                                <option value="">Not Set</option>
                                                <option value="1"  if ($debtAmount == "1") {  selected="selected" } >under &pound;2,000</option>
                                                <option value="2"  if ($debtAmount == "2") {  selected="selected" } > &pound;2,000 - &pound;5,000</option>
                                                <option value="3"  if ($debtAmount == "3") {  selected="selected" } >&pound;5,000 - &pound;10,000</option>
                                                <option value="4"  if ($debtAmount == "4") {  selected="selected" } >&pound;10,000 - &pound;15,000</option>
                                                <option value="5"  if ($debtAmount == "5") {  selected="selected" } >&pound;15,000 - &pound;25,000</option>
                                                <option value="6"  if ($debtAmount == "6") {  selected="selected" } >&pound;25,000 - &pound;50,000</option>
                                                <option value="7"  if ($debtAmount == "7") {  selected="selected" } >&pound;50,000 - &pound;75,000</option>
                                                <option value="8"  if ($debtAmount == "8") {  selected="selected" } >&pound;75,000 - &pound;100,000</option>
                                                <option value="9"  if ($debtAmount == "9") {  selected="selected" } >&pound;100,000+</option>
                                            </select>

                                            <strong>Companies Owed </strong><br />
                                            <select name="companiesOwed">
                                                <option value="">Not Set</option>
                                                
                                                $i = 00;
                                                while ($i <= 20) {
                                                    echo "<option  value=\" $i \"";
                                                    if ($i == $compOwed) {
                                                        echo "selected=\"selected\"";
                                                    } echo ">$i</option>";
                                                    $i++;
                                                }
                                                

                                            </select>

                                            <strong>Partner Debt</strong><br />
                                            <select name="partnerDebt">
                                                <option value="">Not Set</option>
                                                <option value="yes"  if ($partnerDebt == "yes") {
                                                    echo "selected=\"selected\"";
                                                } >yes</option>
                                                <option value="no"  if ($partnerDebt == "no") {
                                                    echo "selected=\"selected\"";
                                                } >No</option> 
                                            </select>

                                            <strong>Partner Work</strong><br />
                                            <select name="partnerWork">
                                                <option value="">Not Set</option>
                                                <option value="yes"  if ($partnerWork == "yes") {
                                                    echo "selected=\"selected\"";
                                                } >Yes</option>
                                                <option value="no"  if ($partnerWork == "no") {
                                                    echo "selected=\"selected\"";
                                                } >No</option> 
                                            </select>

                                            <strong>Partner Benefits</strong><br />
                                            <select name="partnerBenefits">
                                                <option value="">Not Set</option>
                                                <option value="yes"  if ($partnerBenefits == "yes") {
                                                    echo "selected=\"selected\"";
                                                } >Yes</option>
                                                <option value="no"  if ($partnerBenefits == "no") {
                                    echo "selected=\"selected\"";
                                } >No</option> 
                                            </select>

                                            <input type="submit" value="Update">

                                                </form>


                                                </div>

                                                </body>
                                                </html>

_HTML_;
    
} else {
                header("location:index.php");
            }

?>

Open in new window

0
 
Scott MadeiraCommented:
One problem I see is that you reference your array values as:

$add1 = $row[house];

when it should be:

$add1 = $row['house'];


you need quotes around your array indicies when you use strings.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Marco GasiFreelancerCommented:
Sorry, the right file is this:
<?php
session_start();
//main.php
require_once('connection.php');
if (isset($_SESSION['user'])) {

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
    $id = $_GET['ID'];
    $sql = "SELECT * FROM harvest WHERE ID='$ID'";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);

    $title = $row[title];
    $fname = $row[f_name];
    $sname = $row[s_name];
    $dob = explode("/", $row[DOB]);
    $dob_d = $dob[0];
    $dob_m = $dob[1];
    $dob_y = $dob[2];

    $marital = $row[marital];

    $add1 = $row[house];
    $add2 = $row[street];
    $add3 = $row[city];
    $postcode = $row[postcode];

    $tel1 = $row[m_tel];
    $tel2 = $row[h_tel];

    $email = $row[email];

    $appt = explode("-", $row[ApptDate]);

    $appt_d = $appt[2];
    $appt_m = $appt[1];
    $appt_y = $appt[0];

    $apptT = explode(":", $row[ApptTime]);

    $appt_h = $apptT[0];
    $appt_m = $apptT[1];

    $status = $row[Status];

    $accepted = explode("-", $row['AcceptedDate']);
    $acc_D = $accepted[2];
    $acc_M = $accepted[1];
    $acc_Y = $accepted[0];

    $rejRea = $row[RejectionReason];

    $solution = $row[Solution];

    $solVal = $row[Value];

    $firstVal = $row[FirstPaymentValue];

    $addedCost = $row[AddedCost];

    $compOwed = $row[CompaniesOwed];

    $debtAmount = $row[DebtAmmount];

    $partnerDebt = $row[PartnerDebt];

    $partnerWork = $row[PartnerWork];

    $partnerBenefits = $row[PartnerBenefits];

    $firstPaymentDate = explode("-", $row[FirstPaymentDate]);

    $fp_day = $firstPaymentDate[2];
    $fp_month = $firstPaymentDate[1];
    $fp_year = $firstPaymentDate[0];
    
print<<<_HTML_
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
            <title>Edit page OBFTS</title>
        </head>

        <body>

            <div id="edit_container">


                <strong>Name</strong>
                <br />
                <form id="edit_customer" action="update.php">
                    <input name="title"/>


                    <input name="first_name"/>


                    <input name="last_name"/>

                    <br  class="clearfix"/>
                    <strong>Date of Birth </strong>
                    <br  />
                    <input name="day" value="<?php echo $dob_d; ?>" />
                    <input name="month" value="<?php echo $dob_m; ?>" />
                    <input name="year" value="<?php echo $dob_y; ?>" />

                    <br  class="clearfix"/>
                    <strong>Marital:</strong> <br  />
                    <select name="marital">
                        <option value="single" <?php if ($marital == 'single') { ?> selected="selected"<?php } ?>>Single</option>
                        <option value="divorced" <?php if ($marital == 'divorced') { ?> selected="selected"<?php } ?> >Divorced</option>
                        <option value="married" <?php if ($marital == 'married') { ?> selected="selected"<?php } ?> >Married</option>
                        <option value="together" <?php if ($marital == 'together') { ?> selected="selected"<?php } ?> >Living together</option>
                        <option value="Widowed" <?php if ($marital == 'widowed') { ?> selected="selected"<?php } ?> >Widowed</option>
                        <option value="Separated" <?php if ($marital == 'Seperated') { ?> selected="selected"<?php } ?> >Separated</option>
                    </select>
                    <br  class="clearfix"/>

                    <strong>Address:</strong> <br  />
                    <input  name="add1" value="<?php echo $add1; ?>"/><br  />
                    <input  name="add2" value="<?php echo $add2; ?>"/><br  />
                    <input  name="add3" value="<?php echo $add3; ?>"/> <br />
                    <input  name="postcode" value="<?php echo $postcode; ?>" />
                    <br class="clearfix" />

                    <strong>Telephone Numbers</strong> <br  />
                    <input name="tel1" value="<?php echo $tel1; ?>"/>
                    <input name="tel2" value="<?php echo $tel2; ?>"/>

                    <br  class="clearfix"/>
                    <strong>Email</strong><br />
                    <input name="email"  value="<?php echo $email; ?>"/> />
                    <br  />
                    <textarea name="notes" cols="50" rows="15" >Notes</textarea>

                    <br class="clearfix" />
                    <h2>Callback/Appointment Details</h2>
                    <strong>Appointment Date</strong><br />
                    <select name="appt_day">


                        <option value="">dd</option>
    <?php
    $i = 01;
    while ($i <= 31) {
        echo "<option  value=\" $i \"";
        if ($i == $appt_d) {
            echo "selected=\"selected\"";
        } echo ">$i</option>";
        $i++;
    }
    ?>
                    </select>
                    <select name="appt_month"><option  value=""></option>
                        <?php
                        $i = 01;
                        while ($i <= 12) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_year"><option value="" selected="selected"></option>

                        <?php
                        $i = 2011;
                        while ($i <= 2014) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_y) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <br class="clearfix" />


                    <strong>Appointment Time</strong><br />
                    <select name="appt_hours"><option value=""> </option>
                        <?php
                        $i = 00;
                        while ($i <= 23) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_h) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_mins"><option value=""></option>


                        <?php
                        $i = 00;
                        while ($i <= 59) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>

                    <br class="clearfix">

                        <textarea name="appt_notes" cols="50" rows="15"> </textarea>

                        <br class="clearfix" />

                        <h2>Call Details</h2>
                        <strong>Call Status </strong> <br />
                        <select name="callStatus"> 
                            <option value=""></option>
                            <option <?php if ($status == signed) { ?> selected="selected"<?php } ?>  value="signed">Signed</option>
                            <option value="cf" <?php if ($status == 'cf') { ?> selected="selected"<?php } ?> >CF</option>
                            <option value="pbo" <?php if ($status == 'pbo') { ?> selected="selected"<?php } ?> >PBO</option>
                        </select>
                        <br class="clearfix">

                            <strong>Accepted Date</strong> <br />
                            <input name="acc_day" value="<?php echo $acc_D; ?>" />
                            <input name="acc_month" value="<?php echo $acc_M; ?>" />
                            <input name="acc_year" value="<?php echo $acc_Y; ?>">

                                <br class="clearfix" />

                                <strong>Rejection reason</strong> <br />
                                <select name="rejReason"><option value=""></option>
                                    <option value="1c" <?php if ($rejRea == "1c") { ?> selected="selected"<?php } ?>>Only one creditor</option>
                                    <option value="ni" <?php if ($rejRea == "ni") { ?> selected="selected"<?php } ?>>Not interested</option>
                                    <option value="ca" <?php if ($rejRea == "ca") { ?> selected="selected"<?php } ?>>Can't afford min</option>
                                    <option value="fees" <?php if ($rejRea == "fees") { ?> selected="selected"<?php } ?>>fees</option>
                                    <option value="wcb" <?php if ($rejRea == "wcb") { ?> selected="selected"<?php } ?>>Won't change bank</option>
                                    <option value="nc" <?php if ($rejRea == "nc") { ?> selected="selected"<?php } ?>>No Contact</option>
                                    <option value="bos" <?php if ($rejRea == "bos") { ?> selected="selected"<?php } ?>>bos</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution</strong> <br />
                                <select name="solution">
                                    <option value=""></option>
                                    <option value="dmp" <?php if ($Solution == "dmp") { ?> selected="selected"<?php } ?> >DMP</option>
                                    <option value="ppi" <?php if ($Solution == "ppi") { ?> selected="selected"<?php } ?> >PPI</option>
                                    <option value="lf" <?php if ($Solution == "lf") { ?> selected="selected"<?php } ?> >Loan Referral</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution Value</strong> <br />
                                <input type="text" name="solutionValue" value="<?php echo $solVal; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Value</strong> <br />
                                <input type="text" name="firstPaymentValue" value="<?php echo $firstVal; ?>" />

                                <br class="clearfix"/>

                                <strong>Added Cost</strong> <br />
                                <input type="text" name="addedCost" value="<?php echo $addedCost; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Date</strong> <br />  
                                <input type="text" name="fp_day"  <?php if ($fp_day != "") { ?> value="dd" <?php } else { ?> value="<?php echo $fp_day; ?>"  />
                                    <input type="text" name="fp_month" <?php if ($fp_month != "") { ?> value="mm" <?php } else { ?> value="<?php echo $fp_month; ?>" />
                                        <input type="text" name="fp_month" <?php if ($fp_year != "") { ?> value="yyyy" <?php } else { ?> value="<?php echo $fp_year; ?>" />

                                            <br class="clearfix"/>

                                            <h2>Debts </h2>

                                            <strong>Debt Amount </strong><br />
                                            <select name="debtAmount">
                                                <option value="">Not Set</option>
                                                <option value="1" <?php if ($debtAmount == "1") { ?> selected="selected"<?php } ?>>under &pound;2,000</option>
                                                <option value="2"<?php if ($debtAmount == "2") { ?> selected="selected"<?php } ?>> &pound;2,000 - &pound;5,000</option>
                                                <option value="3" <?php if ($debtAmount == "3") { ?> selected="selected"<?php } ?>>&pound;5,000 - &pound;10,000</option>
                                                <option value="4" <?php if ($debtAmount == "4") { ?> selected="selected"<?php } ?>>&pound;10,000 - &pound;15,000</option>
                                                <option value="5" <?php if ($debtAmount == "5") { ?> selected="selected"<?php } ?>>&pound;15,000 - &pound;25,000</option>
                                                <option value="6" <?php if ($debtAmount == "6") { ?> selected="selected"<?php } ?>>&pound;25,000 - &pound;50,000</option>
                                                <option value="7" <?php if ($debtAmount == "7") { ?> selected="selected"<?php } ?>>&pound;50,000 - &pound;75,000</option>
                                                <option value="8" <?php if ($debtAmount == "8") { ?> selected="selected"<?php } ?>>&pound;75,000 - &pound;100,000</option>
                                                <option value="9" <?php if ($debtAmount == "9") { ?> selected="selected"<?php } ?>>&pound;100,000+</option>
                                            </select>

                                            <strong>Companies Owed </strong><br />
                                            <select name="companiesOwed">
                                                <option value="">Not Set</option>
                                                <?php
                                                $i = 00;
                                                while ($i <= 20) {
                                                    echo "<option  value=\" $i \"";
                                                    if ($i == $compOwed) {
                                                        echo "selected=\"selected\"";
                                                    } echo ">$i</option>";
                                                    $i++;
                                                }
                                                ?>

                                            </select>

                                            <strong>Partner Debt</strong><br />
                                            <select name="partnerDebt">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerDebt == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>yes</option>
                                                <option value="no" <?php if ($partnerDebt == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Work</strong><br />
                                            <select name="partnerWork">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerWork == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerWork == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Benefits</strong><br />
                                            <select name="partnerBenefits">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerBenefits == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerBenefits == "no") {
                                    echo "selected=\"selected\"";
                                } ?>>No</option> 
                                            </select>

                                            <input type="submit" value="Update">

                                                </form>


                                                </div>

                                                </body>
                                                </html>
_HTML_;
            } else {
                header("location:index.php");
            }
            ?>

Open in new window

0
 
Scott MadeiraCommented:
My mistake...  PHP will tolerate bare strings as long as they are not also a defined constant in your script in which case the value of the constant would be substituted for the index.

Was there more of an error message or something that gave a line number?
0
 
EverlearnerAuthor Commented:
just this as an error...

Parse error: parse error in C:\wamp\www\tracking\edit2.php on line 387


I tried your Heredoc solution and although I didn't get any errors some of the inline php wasn't being executed :s

0
 
Marco GasiFreelancerCommented:
Can you tell what code is not executed?

And let me understand: I have only 363 lines...
0
 
EverlearnerAuthor Commented:
Sorry, yes I added a few conditionals at the top after the explodes in case they were blank so to stop them referencing array members that didn't exist that's why the extra lines of code.

The code not being executed is the stuff within the select elements and input elements, and the while loops that generate the options  
0
 
Ray PaseurConnect With a Mentor Commented:
What is the question here?  With 300+ lines of code and nothing more to go on than I think a pair of fresh eyes will greatly help. it is hard to know where to look first.  Did you get an error message?  If so, what line number?

I see some things that seem to involve date and/or time processing. You can learn how to do that in this article.  It is much simpler than you might think.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html

I see some things that seem to involve copying variables from the $row array into the local variables scope.  That is known as "variable proliferation" and it is almost always a red flag in programming.  There is no extra credit (but there is extra confusion) when variable proliferation is involved.

I see a lot of select and option tags.  Usually the way these are generated would be to have an array (perhaps from a data base) that matches the name of the input control to the options.  Often an array of objects is useful for generating these tags.

I think you might really enjoy this book.  It is full of good explanations and useful examples, many of them covering the kinds of things you are trying to do here.
http://www.sitepoint.com/books/phpmysql4/

Please post back with any specific questions, and we can try to help.  Best regards, ~Ray
0
 
Marco GasiFreelancerCommented:
Try to use nowdoc instead: nowdoc notation should be good for embedding php code. Please copy and paste the code below and test it.
<?php
session_start();
//main.php
require_once('connection.php');
if (isset($_SESSION['user'])) {

//$sql="SELECT * FROM $tbl_name WHERE user='$myusername'";
    $id = $_GET['ID'];
    $sql = "SELECT * FROM harvest WHERE ID='$ID'";
    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);

    $title = $row[title];
    $fname = $row[f_name];
    $sname = $row[s_name];
    $dob = explode("/", $row[DOB]);
    $dob_d = $dob[0];
    $dob_m = $dob[1];
    $dob_y = $dob[2];

    $marital = $row[marital];

    $add1 = $row[house];
    $add2 = $row[street];
    $add3 = $row[city];
    $postcode = $row[postcode];

    $tel1 = $row[m_tel];
    $tel2 = $row[h_tel];

    $email = $row[email];

    $appt = explode("-", $row[ApptDate]);

    $appt_d = $appt[2];
    $appt_m = $appt[1];
    $appt_y = $appt[0];

    $apptT = explode(":", $row[ApptTime]);

    $appt_h = $apptT[0];
    $appt_m = $apptT[1];

    $status = $row[Status];

    $accepted = explode("-", $row['AcceptedDate']);
    $acc_D = $accepted[2];
    $acc_M = $accepted[1];
    $acc_Y = $accepted[0];

    $rejRea = $row[RejectionReason];

    $solution = $row[Solution];

    $solVal = $row[Value];

    $firstVal = $row[FirstPaymentValue];

    $addedCost = $row[AddedCost];

    $compOwed = $row[CompaniesOwed];

    $debtAmount = $row[DebtAmmount];

    $partnerDebt = $row[PartnerDebt];

    $partnerWork = $row[PartnerWork];

    $partnerBenefits = $row[PartnerBenefits];

    $firstPaymentDate = explode("-", $row[FirstPaymentDate]);

    $fp_day = $firstPaymentDate[2];
    $fp_month = $firstPaymentDate[1];
    $fp_year = $firstPaymentDate[0];
    
print<<<'HTML'
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
            <title>Edit page OBFTS</title>
        </head>

        <body>

            <div id="edit_container">


                <strong>Name</strong>
                <br />
                <form id="edit_customer" action="update.php">
                    <input name="title"/>


                    <input name="first_name"/>


                    <input name="last_name"/>

                    <br  class="clearfix"/>
                    <strong>Date of Birth </strong>
                    <br  />
                    <input name="day" value="<?php echo $dob_d; ?>" />
                    <input name="month" value="<?php echo $dob_m; ?>" />
                    <input name="year" value="<?php echo $dob_y; ?>" />

                    <br  class="clearfix"/>
                    <strong>Marital:</strong> <br  />
                    <select name="marital">
                        <option value="single" <?php if ($marital == 'single') { ?> selected="selected"<?php } ?>>Single</option>
                        <option value="divorced" <?php if ($marital == 'divorced') { ?> selected="selected"<?php } ?> >Divorced</option>
                        <option value="married" <?php if ($marital == 'married') { ?> selected="selected"<?php } ?> >Married</option>
                        <option value="together" <?php if ($marital == 'together') { ?> selected="selected"<?php } ?> >Living together</option>
                        <option value="Widowed" <?php if ($marital == 'widowed') { ?> selected="selected"<?php } ?> >Widowed</option>
                        <option value="Separated" <?php if ($marital == 'Seperated') { ?> selected="selected"<?php } ?> >Separated</option>
                    </select>
                    <br  class="clearfix"/>

                    <strong>Address:</strong> <br  />
                    <input  name="add1" value="<?php echo $add1; ?>"/><br  />
                    <input  name="add2" value="<?php echo $add2; ?>"/><br  />
                    <input  name="add3" value="<?php echo $add3; ?>"/> <br />
                    <input  name="postcode" value="<?php echo $postcode; ?>" />
                    <br class="clearfix" />

                    <strong>Telephone Numbers</strong> <br  />
                    <input name="tel1" value="<?php echo $tel1; ?>"/>
                    <input name="tel2" value="<?php echo $tel2; ?>"/>

                    <br  class="clearfix"/>
                    <strong>Email</strong><br />
                    <input name="email"  value="<?php echo $email; ?>"/> />
                    <br  />
                    <textarea name="notes" cols="50" rows="15" >Notes</textarea>

                    <br class="clearfix" />
                    <h2>Callback/Appointment Details</h2>
                    <strong>Appointment Date</strong><br />
                    <select name="appt_day">


                        <option value="">dd</option>
    <?php
    $i = 01;
    while ($i <= 31) {
        echo "<option  value=\" $i \"";
        if ($i == $appt_d) {
            echo "selected=\"selected\"";
        } echo ">$i</option>";
        $i++;
    }
    ?>
                    </select>
                    <select name="appt_month"><option  value=""></option>
                        <?php
                        $i = 01;
                        while ($i <= 12) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_year"><option value="" selected="selected"></option>

                        <?php
                        $i = 2011;
                        while ($i <= 2014) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_y) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <br class="clearfix" />


                    <strong>Appointment Time</strong><br />
                    <select name="appt_hours"><option value=""> </option>
                        <?php
                        $i = 00;
                        while ($i <= 23) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_h) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>
                    <select name="appt_mins"><option value=""></option>


                        <?php
                        $i = 00;
                        while ($i <= 59) {
                            echo "<option  value=\" $i \"";
                            if ($i == $appt_m) {
                                echo "selected=\"selected\"";
                            } echo ">$i</option>";
                            $i++;
                        }
                        ?>

                    </select>

                    <br class="clearfix">

                        <textarea name="appt_notes" cols="50" rows="15"> </textarea>

                        <br class="clearfix" />

                        <h2>Call Details</h2>
                        <strong>Call Status </strong> <br />
                        <select name="callStatus"> 
                            <option value=""></option>
                            <option <?php if ($status == signed) { ?> selected="selected"<?php } ?>  value="signed">Signed</option>
                            <option value="cf" <?php if ($status == 'cf') { ?> selected="selected"<?php } ?> >CF</option>
                            <option value="pbo" <?php if ($status == 'pbo') { ?> selected="selected"<?php } ?> >PBO</option>
                        </select>
                        <br class="clearfix">

                            <strong>Accepted Date</strong> <br />
                            <input name="acc_day" value="<?php echo $acc_D; ?>" />
                            <input name="acc_month" value="<?php echo $acc_M; ?>" />
                            <input name="acc_year" value="<?php echo $acc_Y; ?>">

                                <br class="clearfix" />

                                <strong>Rejection reason</strong> <br />
                                <select name="rejReason"><option value=""></option>
                                    <option value="1c" <?php if ($rejRea == "1c") { ?> selected="selected"<?php } ?>>Only one creditor</option>
                                    <option value="ni" <?php if ($rejRea == "ni") { ?> selected="selected"<?php } ?>>Not interested</option>
                                    <option value="ca" <?php if ($rejRea == "ca") { ?> selected="selected"<?php } ?>>Can't afford min</option>
                                    <option value="fees" <?php if ($rejRea == "fees") { ?> selected="selected"<?php } ?>>fees</option>
                                    <option value="wcb" <?php if ($rejRea == "wcb") { ?> selected="selected"<?php } ?>>Won't change bank</option>
                                    <option value="nc" <?php if ($rejRea == "nc") { ?> selected="selected"<?php } ?>>No Contact</option>
                                    <option value="bos" <?php if ($rejRea == "bos") { ?> selected="selected"<?php } ?>>bos</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution</strong> <br />
                                <select name="solution">
                                    <option value=""></option>
                                    <option value="dmp" <?php if ($Solution == "dmp") { ?> selected="selected"<?php } ?> >DMP</option>
                                    <option value="ppi" <?php if ($Solution == "ppi") { ?> selected="selected"<?php } ?> >PPI</option>
                                    <option value="lf" <?php if ($Solution == "lf") { ?> selected="selected"<?php } ?> >Loan Referral</option>
                                </select>

                                <br class="clearfix" />

                                <strong>Solution Value</strong> <br />
                                <input type="text" name="solutionValue" value="<?php echo $solVal; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Value</strong> <br />
                                <input type="text" name="firstPaymentValue" value="<?php echo $firstVal; ?>" />

                                <br class="clearfix"/>

                                <strong>Added Cost</strong> <br />
                                <input type="text" name="addedCost" value="<?php echo $addedCost; ?>" />

                                <br class="clearfix"/>


                                <strong>First Payment Date</strong> <br />  
                                <input type="text" name="fp_day"  <?php if ($fp_day != "") { ?> value="dd" <?php } else { ?> value="<?php echo $fp_day; ?>"  />
                                    <input type="text" name="fp_month" <?php if ($fp_month != "") { ?> value="mm" <?php } else { ?> value="<?php echo $fp_month; ?>" />
                                        <input type="text" name="fp_month" <?php if ($fp_year != "") { ?> value="yyyy" <?php } else { ?> value="<?php echo $fp_year; ?>" />

                                            <br class="clearfix"/>

                                            <h2>Debts </h2>

                                            <strong>Debt Amount </strong><br />
                                            <select name="debtAmount">
                                                <option value="">Not Set</option>
                                                <option value="1" <?php if ($debtAmount == "1") { ?> selected="selected"<?php } ?>>under &pound;2,000</option>
                                                <option value="2"<?php if ($debtAmount == "2") { ?> selected="selected"<?php } ?>> &pound;2,000 - &pound;5,000</option>
                                                <option value="3" <?php if ($debtAmount == "3") { ?> selected="selected"<?php } ?>>&pound;5,000 - &pound;10,000</option>
                                                <option value="4" <?php if ($debtAmount == "4") { ?> selected="selected"<?php } ?>>&pound;10,000 - &pound;15,000</option>
                                                <option value="5" <?php if ($debtAmount == "5") { ?> selected="selected"<?php } ?>>&pound;15,000 - &pound;25,000</option>
                                                <option value="6" <?php if ($debtAmount == "6") { ?> selected="selected"<?php } ?>>&pound;25,000 - &pound;50,000</option>
                                                <option value="7" <?php if ($debtAmount == "7") { ?> selected="selected"<?php } ?>>&pound;50,000 - &pound;75,000</option>
                                                <option value="8" <?php if ($debtAmount == "8") { ?> selected="selected"<?php } ?>>&pound;75,000 - &pound;100,000</option>
                                                <option value="9" <?php if ($debtAmount == "9") { ?> selected="selected"<?php } ?>>&pound;100,000+</option>
                                            </select>

                                            <strong>Companies Owed </strong><br />
                                            <select name="companiesOwed">
                                                <option value="">Not Set</option>
                                                <?php
                                                $i = 00;
                                                while ($i <= 20) {
                                                    echo "<option  value=\" $i \"";
                                                    if ($i == $compOwed) {
                                                        echo "selected=\"selected\"";
                                                    } echo ">$i</option>";
                                                    $i++;
                                                }
                                                ?>

                                            </select>

                                            <strong>Partner Debt</strong><br />
                                            <select name="partnerDebt">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerDebt == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>yes</option>
                                                <option value="no" <?php if ($partnerDebt == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Work</strong><br />
                                            <select name="partnerWork">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerWork == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerWork == "no") {
                                                    echo "selected=\"selected\"";
                                                } ?>>No</option> 
                                            </select>

                                            <strong>Partner Benefits</strong><br />
                                            <select name="partnerBenefits">
                                                <option value="">Not Set</option>
                                                <option value="yes" <?php if ($partnerBenefits == "yes") {
                                                    echo "selected=\"selected\"";
                                                } ?>>Yes</option>
                                                <option value="no" <?php if ($partnerBenefits == "no") {
                                    echo "selected=\"selected\"";
                                } ?>>No</option> 
                                            </select>

                                            <input type="submit" value="Update">

                                                </form>


                                                </div>

                                                </body>
                                                </html>
HTML;
            } else {
                header("location:index.php");
            }
            ?>

Open in new window

0
 
EverlearnerAuthor Commented:
Thanks marqusG but the php Still didn't work.

Ray, you are right there is no bnefit to copying the variables over I'm just gonna use the row array directly unless I'm going to explode them, this should clean up my code...


The error message is just Parse error and the line of code is the last line. In zend framework ide it says unexpected EOF.

Thanks for the book recommendation I will definitely buy that, although is it possible to point me to tutorial about generating the select option tags as you mention or possibly a quick example? Just because it's quite urgent and I woudn't be able to get the book by next week.

Thanks again for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.