PHP - Breaking Down A Table

Hey all

I'm working on an auction website. I've added a new column to the 'Auctions' table, however the 'sell.php' page now does not work with this new column (I've deleted the column and tested again and it works, so that's definitely the cause). The new column can not be in a separate table as it needs to pull 'id' values from the 'Auctions' table for various functions.

My question to you is, is there any PHP snippet I can use to tell sell.php to stop reading the 'Auctions' table once it reaches the column I've added? The new column is called 'shipped' if that's of any relevance.

Below is some of  the PHP I'm working on on the sell.php page.


  #//Populate arrays
                $UPLOADED_PICTURES[] = $file;
                $UPLOADED_PICTURES_SIZE[] = filesize($image_upload_path.session_id()."/".$file);
              }
            }
          }
          $_SESSION["UPLOADED_PICTURES"] = $UPLOADED_PICTURES;
          $_SESSION["UPLOADED_PICTURES_SIZE"] = $UPLOADED_PICTURES_SIZE;
          $_SESSION["GALLERY_UPDATED"]=true;
          if($sessionVars['SELL_action']=='edit') {
            $sessionVars["OLD_GALLERYFEE"] = $SETTINGS["picturesgalleryvalue"] * count($UPLOADED_PICTURES);
          } else {
            $sessionVars["OLD_GALLERYFEE"] = 0;
          }
        }
      }
    }
    $with_reserve = $sessionVars["SELL_with_reserve"];
    $reserve_price = $sessionVars["SELL_reserve_price"];
    $minimum_bid = $sessionVars["SELL_minimum_bid"];
    
    $duration_hours = $sessionVars["SELL_duration_hours"];
    $duration_minutes = $sessionVars["SELL_duration_minutes"];
    
    $pict_url=$sessionVars["SELL_pict_url"];
    $imgtype = $sessionVars["SELL_file_uploaded"];
    $title = $sessionVars["SELL_title"];
    $description = stripslashes($sessionVars["SELL_description"]);
    $pict_url = $sessionVars["SELL_pict_url"];
    $atype = $sessionVars["SELL_atype"];
    $adultonly = $sessionVars["SELL_adultonly"];
    $TPL_item_value = $item_value = $sessionVars["SELL_item_value"];
    $TPL_number_of_bids =$number_of_bids=$sessionVars["SELL_number_of_bids"];
    $TPL_bid_value = $bid_value = $sessionVars["SELL_bid_value"];
    $iquantity = $sessionVars["SELL_iquantity"];
    $buy_now = $sessionVars["SELL_with_buy_now"];
    $buy_now_price = $sessionVars["SELL_buy_now_price"];
    $duration = $sessionVars["SELL_duration"];
    $duration_second = $sessionVars["SELL_duration_second"];
    $minimum_users = $sessionVars["SELL_minimum_users"];
    $relist = $sessionVars["SELL_relist"];
    $increments = $sessionVars["SELL_increments"];
    $customincrement = $sessionVars["SELL_customincrement"];
    $international = ($sessionVars["SELL_international"])?"on":"";
    $sellcat = $_SESSION['sellcat'];
    $private = $sessionVars["SELL_private"];
    if($private != 'y') $private = 'n';
    $sendemail = $sessionVars["SELL_sendemail"];
    $txt = $sessionVars["SELL_txt"];
    $num = $sessionVars["SELL_num"];
    $buy_now_only = $sessionVars["SELL_buy_now_only"];


and...


$auction_id=$sessionVars['SELL_auction_id'];
  } elseif ($sessionVars["SELL_action"] == "reopen") {
    $query =
    "UPDATE BPLA_auctions set
       title = '".addslashes($sessionVars["SELL_title"])."',
       starts = '".$a_starts."',
       starts_second = '".$a_starts_second."',
       description = '".addslashes($sessionVars["SELL_description"])."',
       pict_url = '".addslashes($sessionVars["SELL_pict_url"])."',
       category = ".$sessionVars["SELL_sellcat"].",
       minimum_bid = '".$sessionVars["SELL_minimum_bid"]."',
       reserve_price = '".(($sessionVars["SELL_with_reserve"]=="yes")?$sessionVars["SELL_reserve_price"]:"0")."',
       buy_now = '".(($sessionVars["SELL_with_buy_now"]=="yes")?$sessionVars["SELL_buy_now_price"]:"0")."',
       bn_only = '".$sessionVars["SELL_buy_now_only"]."',
       auction_type = '".$sessionVars["SELL_atype"]."',
       adultonly = '".$sessionVars["SELL_adultonly"]."',
       duration = '".$sessionVars["SELL_duration"]."',
       duration_second = '".$sessionVars["SELL_duration_second"]."',
       minimum_users = ".intval($sessionVars["SELL_minimum_users"]).",
       increment = ".doubleval($sessionVars["SELL_customincrement"]).",

       
       
       international = '".(($sessionVars["SELL_international"])?"1":"0")."',
       ends = '".$a_ends."',
       ends_second = '".$a_ends_second."',
       photo_uploaded = ".(($sessionVars["SELL_file_uploaded"])?"1":"0").",
       quantity = ".$sessionVars["SELL_iquantity"].",
         relist=".intval($sessionVars["SELL_relist"]).",
         relisted=0,
         closed='0',
       private='n',
       item_value = '".$sessionVars["SELL_item_value"]."',
       number_of_bids = '".$sessionVars["SELL_number_of_bids"]."',
       bid_value = '".$sessionVars["SELL_bid_value"]."',       
       suspended='".$SUSPENDED."',";
       $query .= "current_bid=0,
       num_bids=0,
       
       WHERE id = '".$sessionVars["SELL_auction_id"]."'";
    $backtoclosed=true;
    

if($BPLowbidAuction_TESTMODE == 'yes'){

echo $ERR = $ERR_9999;

}else{
    $res=mysql_query($query);
    if (!$res) {
      MySQLError($query);
      exit;
    }

    $auction_id=$sessionVars['SELL_auction_id'];
    $sessionVars["SELL_auction_id_old"]=$auction_id;
    $query = "DELETE FROM BPLA_bids WHERE auction='$auction_id'";
    $res = @mysql_query($query);
    if(!$res) {
      
      MySQLError($query);
      exit;
    }


Thanks in advance for any help and replies! 

I'm experimenting with a basic CRUD App.  The table created by the code below renders, however when I view source, the last tag is the closing </tr> after the while loop finishes.  There's nothing after that.  No closing table, html, or body tags.  I can't see what I've done wrong.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Eric's PHP CRUD App</title>
<style type="text/css">
table {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 10px;
    text-align: center;
    margin: 0 auto;
}
table td {
     text-align:center;
    border: 1px solid #dfdfdf;
}
tr:nth-child(odd) {
    background: #fdfdfd;
}
tr:nth-child(even) {
    background: #B8D3FF;
}
th {
    background-color:#ccc;
}
.center {
    width: 1050px;
    margin:0px auto;
}
h1 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 14px;
    padding-bottom: 15px;
    text-align: center;
    margin: 0 auto;
    color: white;
}
</style>
</head>

<body bgcolor="#999">
<?php

   require_once("db_connect.php");
   
   echo "<h1>Update Student Records</h1>";
   echo "<table cellpadding='10'>";
   echo "<tr bgcolor='#cccccc'>";       
   echo "<th>First Name</th>";
   echo "<th>Last Name</th>";
   echo "<th>Test 1 Grade</th>";
   echo "<th>Test 2 Grade</th>";
   echo "<th>Test 3 Grade</th>";
   echo "<th>Test 4 Grade</th>";
   echo "<th>Final Exam Grade</th>";
   echo "<th>Average Grade</th>";
   echo "<th>Final Grade</th>";
   echo "<th>delete</th>";
   echo "<th>edit</th>";
   echo "</tr>";
 
  $sql = "SELECT * FROM students";
  $result = mysqli_query($link, $sql) or die(mysql_error());
 
 
   while($row = mysqli_fetch_array($result, MYSQLI_ASSOC) or die(mysql_error())) {
       $final = "";
       $average = (($row["test1Grade"]) + ($row["test2Grade"]) + ($row["test3Grade"]) + ($row["test4Grade"]) + ($row["finalExamGrade"])) / 5;
       if ($average >= 90)
       {
          $final = "A";  
       } else if ($average >= 80)
       {
          $final = "B";   
       } else if ($average >= 70)
       {
          $final = "C";   
       } else if ($average >= 60)
       {
          $final = "D";   
       } else if ($average < 60)
       {
          $final = "F";   
       }
       echo "<tr>";       
       echo "<td>" . $row["firstName"] . "</td>";
       echo "<td>" . $row["lastName"] . "</td>";
       echo "<td>" . $row["test1Grade"] . "</td>";
       echo "<td>" . $row["test2Grade"] . "</td>";
       echo "<td>" . $row["test3Grade"] . "</td>";
       echo "<td>" . $row["test4Grade"] . "</td>";
       echo "<td>" . $row["finalExamGrade"] . "</td>";
       echo "<td>" . round($average) . "</td>";
       echo "<td>" . $final . "</td>";
       echo "<td><a href='delete.php?id=" . $row['studentID'] . "'>&rsaquo;</a></td>";
       echo "<td><a href='update.php?id=" . $row['studentID'] . "'>&rsaquo;</a></td>";
       echo "</tr>";
   }
   echo "</table>";
?>
   <a href='insert.php'>Add new student</a>
</body>
</html>

Edited by Ch0cu3r, 13 November 2014 - 01:07 PM.
Added code tags

I have a site that everything was typed manually, but I want to get all this info off so I can put all info into a database for easier editing and so forth.   I'm trying this code, which works to a point.

function curl($Url){
  
    if (!function_exists('curl_init')){
        die('cURL is not installed. Install and try again.');
    }
  
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $Url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
curl_close($ch); 
 
$start = strpos($output, '<h2 style="text-align: center;"><span style="text-decoration: underline;">Alabama Tattoo Shops</span></h2>');
$end = strpos($output, '<p>', $start);
$length = $end-$start;
$site = substr($output, $start, $length);
 
$site = explode("<p>", $site);
 
foreach ($site AS $line) {
 
    print_r($line);
  }
 
    return $output; 
}
$site = curl('http://www.tattooshopusa.com/alabama/');

 

What is the best way to break up repeating code?

Make each page from a standard template (e.g. Header, Columns, Footer) and include the variable content using PHP??

Or make each page a stripped down PHP page which creates the variable content and then Includes the static parts (e.g. Header, Columns, Footer)??

Hope you follow me?!  :-/


Debbie