Stuart, you need to define $link if you're going to use it ;)
>
> 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:
[snip]
> mysql_connect("myserver","myusername", "mypassword") or
die(mysql_error());
$link = mysql_connect(...
>
> mysql_select_db("mydatabase") or die(mysql_error());
mysql_select_db("mydatabase", $link)...
>
> $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);
^^^^^ see above
>
> if(!$result)
> {
> rollback(); // transaction rolls back
> echo "You rolled back ".mysql_error($link);
^^^^^ see above
> 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
