Dynamic redirect url on update based on column value in table

We have been redirecting according to a column value in our user table. Now I am upgrading my pages to mySLQi and I obviously do not have something right.
I am attaching my page.

The recordset is on line #16 and also pasted here:
<?php
$SecurityAssisttbldirectorylistings = new WA_MySQLi_RS("SecurityAssisttbldirectorylistings",$HotNetwork_i,1);
$SecurityAssisttbldirectorylistings->setQuery("SELECT * FROM tbl_directorylistings WHERE id = ?");
$SecurityAssisttbldirectorylistings->bindParam("i", "".($_SESSION['id']) ."", "-1"); //colname
$SecurityAssisttbldirectorylistings->execute();
?>

The update is on line#258 and here
<?php
if (isset($_POST["Update"]) || isset($_POST["Update_x"]) && ($_SESSION["SecurityAssist_id"] == 9290)) {
$UpdateQuery = new WA_MySQLi_Query($HotNetwork_i);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "horses";
$UpdateQuery->bindColumn("admin_notes", "s", "".((isset($_POST["admin_notes"]))?$_POST["admin_notes"]:"") ."", "WA_BLANK");
$UpdateQuery->addFilter("horseid", "=", "i", "".((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"") ."");
$UpdateQuery->execute();
$UpdateGoTo = "http://". ($SecurityAssisttbldirectorylistings->getColumnVal("toptable")) . "/hotpage/horse-profile.php?horseid=" ."";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>

I think you can update this:
$UpdateGoTo = "http://". ($SecurityAssisttbldirectorylistings->getColumnVal("toptable")) . "/hotpage/horse-profile.php?horseid=" ."";

to:
$UpdateGoTo = "http://". ($SecurityAssisttbldirectorylistings->getColumnVal("toptable")) . "/hotpage/horse-profile.php?horseid=[InsertID]";

I am getting an error in my SQL syntax message

Turn on Debug in the rsobj.php page and the queryobj.php page. That will give you the actual SQL error instead of this generic one.

I added the debug code per you suggestion and I am still getting a generic error.
I also added the similar redirect code to another update page (noted in private message) and on that page it allows me to submit, it just is not find the data in the database to populate the url correctly.

You still have:

$this->Debug = false;

in both the rsobj.php and queryobj.php file.

Once I updated that, I got the error:
Unknown column 'admin_notes_royalcrown' in 'field list'

That means you are missing that column in your database.

Thank you, Is that something I should change back as soon as we are done troubleshooting?
(Ref - $this->Debug = false; in both the rsobj.php and queryobj.php file)

No we are having the same error on both pages.
http://hotpage/horse-profile.php?horseid=0 It is not inserting the url prefix from the database or the horseid

You should keep it turned off because it can reveal information about your database like column names or queries you are running when an error occurs, which could potentially be used to help a hacker get information from your database if you have a security hole somewhere else.

Ok, I will check to make sure that you turned it back off and if not do that immediately. Thank you.

Now we are having the same issue on both pages.
http://hotpage/horse-profile.php?horseid=0 It is not inserting the url prefix from the database or the horseid

That url doesn't seem to work for me. Please attach the page as well so I can look at it more quickly without having to FTP in.