Re: Why does this SQL Insert Fail

[Timothy P Clark <timclark@xxxxxxxxxx>]

> date: Tue, 24 Nov 2009 10:24:58 -0600
> from: "Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx>
> subject: [WEB400] Why does this SQL Insert Fail
>
> Hi,
>
>
>
> Trying to do a simple PHP SQL to insert a row into a MySQL database and 
it
> keeps failing.
>
>
>
> I've tried it with hard coded values and also with variables.
>
>
>
> The DB was created fine, and I was able to connect to it fine.
>
>
>
> Also, the user profile has all rights to the DB.
>
>
>
> But it keep failing. 
>
>
>
> Is there a way to get more diagnostic info maybe so that I can see WHY 
it
> fails or barring that, can someone see any reason why this would fail 
(coded
> incorrectly maybe?)
You can get the error text by using the mysqli_error function.

So, something like:
$result = mysqli_query($cxn, $query)

           or die("Unable to insert record: \n"."Transmittal Batch Num:
".$XmittalBatchNum . " -- Error was:" . mysqli_error($cxn));

http://us2.php.net/manual/en/mysqli.error.php


Tim Clark