RE: [PHP-DB] mysql error and resource ID:

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"; > } > ?> > >