Untitled

Split column via query to insert extract into another column. Not working

<?

 $host     = "XXXXXXX";

 $username = "XXXXXXX";

 $password = "XXXXXXX";

 $db_name  = "XXXXXXX";

 $tbl_name = "cartons_current";

 

 mysql_connect("$host", "$username", "$password") or die("cannot connect");

 mysql_select_db("$db_name") or die("cannot select DB");

 

 date_default_timezone_set('America/Los_Angeles');

 $date = date("m/d/y g:i A");

 $order = "INSERT INTO cartons_current (orig_time, type, part_no, description, artwork, min, max, qty)

        VALUES

        ('$date','$_POST[type]', '$_POST[part_no]', '$_POST[description]',       '$_POST[artwork]', '$_POST[min]', '$_POST[max]', '$_POST[qty]')";

 

 

 

 

 $result = mysql_query($order);

 

 $query2 = "select part_no from cartons_current";

 $sel = mysql_query($query2);

 while($row = mysql_fetch_row($sel)) {

 $core_digits = explode('-',$row[0]);

 $core =$core_digits[1];

 $query3 = "insert  into cartons_current(core) values('$core')";

 $sel2 = mysql_query($query3);

 }

 

 

 

 if ($result) {

 

 

 $part_no = $_REQUEST['part_no'] ;

 

 header("location: inv_fc_new_success.php?part_no=" . urlencode($part_no));

 }

 else {

  header("location: inv_fc_new_fail.php");

 }

 ?>

       

UPDATE cartons_current

SET core = SUBSTR(part_no, 5, 5)

       

$core = substr($_POST['part_no'], 5, 5);

$type = mysql_real_escape_string($_POST['type']);

$part_no = mysql_real_escape_string($_POST['part_no']);

$description = mysql_real_escape_string($_POST['description']);

$artwork = mysql_real_escape_string($_POST['artwork']);

$min = mysql_real_escape_string($_POST['min']);

$max = mysql_real_escape_string($_POST['max']);

$qty = mysql_real_escape_string($_POST['qty']);

$order = "

    INSERT INTO cartons_current

    (

        orig_time,

        type,

        part_no,

        description,

        artwork,

        min,

        max,

        qty,

        core

    )

    VALUES

    (

        '$date',

        '$type',

        '$part_no',

        '$description',

        '$artwork',

        $min,

        $max,

        $qty,

        '$core'

    )";

 

$result = mysql_query($order);

       

$query2 = "select part_no from cartons_current";

$sel = mysql_query($query2);

while($row = mysql_fetch_row($sel)) {

 $core_digits = explode('-',$row[0]);

 $core =$core_digits[1];

 $query3 = "insert  into cartons_current(core) values('$core')";

 $sel2 = mysql_query($query3);

}