Quote as in "string" or quote as in 'string' ?
Those two confuse me.
Stuart
--- dpgirago@xxxxxxxxxxxxxx wrote:
> If any of the variables used to insert data are
> strings ($f1a, $f2a,
> etc...), you'll need to have quotes around them.
>
> dave
>
>
>
>
>
>
> Stuart Felenstein <stuart4m@xxxxxxxxx>
>
> 10/14/2004 08:26 AM
>
>
>
>
>
> To:
> Graham Cossey <graham@xxxxxxxxxxxxxxx>,
> php-db@xxxxxxxxxxxxx
> cc:
>
>
>
>
>
> Subject:
> RE: mysql error and resource ID:
>
>
>
> Not much luck here on placing the
> mysql_error($link);
> I know the server and database is reachable. So I
> imagine the error is happening in the query. I've
> moved the $link around with no luck.
>
> Stuart
>
> Revised code below:
> --- Graham Cossey <graham@xxxxxxxxxxxxxxx> wrote:
>
> <?php
>
> function begin()
> {
> mysql_query("BEGIN");
> }
> function commit()
> {
> mysql_query("COMMIT");
> }
> function rollback()
> {
> mysql_query("ROLLBACK");
> }
> mysql_connect("myserver","myusername", "mypassword")
> or die(mysql_error());
>
> mysql_select_db("mydatabase") or die(mysql_error());
>
> $query = "INSERT INTO MainTable
> (RecordID,UserID,.........)
> values
>
(null,null,$f1a,$f2a,$f2c,$f2d,$f2e,$f2g,$f5b,$f3m,$f3n,$f3e,$f3f,$f3g,$f3h,$f3i,$f3j,
> $f3k,$f3l)";
> begin(); // transaction begins
> $result = @mysql_query($query, $link);
>
> if(!$result)
> {
> rollback(); // transaction rolls back
> echo "You rolled back ".mysql_error($link);
> exit;
> }
> else
> {
> commit(); // transaction is committed
> echo "your insertion was successful";
> }
> ?>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
