Re: MYSQL insert problems

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

 



On Sat, Oct 18, 2008 at 3:22 AM, Frank Stanovcak
<blindspotpro@xxxxxxxxxxx> wrote:
> I'm using the following code to try and do a simple insert query.  However
> it won't insert the data into the table, and I get no error messages.  What
> have I done wrong this time?

You will be getting an error.

echo mysql_error();


> DateShipped,Quantity, Cases, Pallets, Weight, FKUSShippedBy, BillofLading,)

Extra comma at the end of BillofLading.

Also you should really use mysql_real_escape_string for non-numeric
values, and at least check stuff like $_SESSION['quantity'] is a
number.

-- 
Postgresql & php tutorials
http://www.designmagick.com/

-- 
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