Re: MYSQL insert problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Just incase the problem was refrencing an array in an SQL statement I tried 
this too with the same result.

<?php
session_start();
$connection = mysql_connect('localhost','FrankS','rastane');
mysql_select_db('envelope1',$connection);
$filtered = $_SESSION['filtered'];
$salesorder = $filtered['SalesOrder'];
$user = 1;
$date = date('m/d/Y', time());
$shipdate = $filtered['ShipDate'];
$quantity = $_SESSION['quantity'];
$cases = $_SESSION['cases'];
$pallets = $filtered['FullPallets'];
$weight = $filtered['Weight'];
$shippedby = $filtered['ShippedBy'];
$billoflading = $filtered['BillofLading'];
mysql_query("INSERT INTO shipped
(FKOESalesOrder,
FKUSUsers,
DateEntered,
DateShipped,
Quantity,
Cases,
Pallets,
Weight,
FKUSShippedBy,
BillofLading,)
VALUES
('$salesorder',
'$user',
'$date',
'$shipdate',
'$quantity',
'$cases',
'$pallets',
'$weight',
'$shippedby',
'$billoflading')", $connection);

$that = mysql_query('SELECT * FROM shipped',$connection);

$i = 0;
while($result_row = mysql_fetch_array($that,MYSQL_ASSOC)) {
 echo ++$i;
 foreach($result_row as $key => $value) {
  echo $key . ' : ' . $value . '<br>';
 };
 echo '<br>';
};
mysql_close($connection);
include('..\VariableReveal.php');
?> 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux