Your SQL is correct in code level, so can you post the code there.
Btw, did you check the connection to the database? do you set auto commit = false? The record is exist or not? did you try to pinrt the sql in the screen and check is it what you expect?
[!--quoteo(post=327327:date=Dec 14 2005, 02:57 AM:name=angel_cowgirl)--][div class=\'quotetop\']QUOTE(angel_cowgirl @ Dec 14 2005, 02:57 AM) 327327[/snapback][/div][div class=\'quotemain\'][!--quotec--]
*sigh* seems like I can't find answers to anything on my own...sorry for asking so many questions..
I'm not getting any errors but its not updating the datbase either.
//Create an update query string with the updated horse data
$strUpdateQuery = "UPDATE horses SET horse_name = '".$strHorseName."', horse_dob = '".$intHorseDOB."', horse_sex = '".$strHorseSex."', horse_height = '".$intHorseHeight."', horse_color = '".$strHorseColor."', horse_sire = '".$strHorseSire."', horse_dam = '".$strHorseDam."' WHERE pk_horse_id = ".$intHorseID;
The variables are being passed from a form on the previous page, and I have checked the spelling and I've tried using only ' instead of " and ive tried using the query with out . around the variables but nothing.
Sometimes its actually not fun not getting errors...