Hello,
I have been using this code to update my news section for quite a long time; however, since the upgrade I have noticed strange things happening.
I can only add new news, and update a few news pages... Not sure why this is, UH has looked into it, and can not see where the issue is coming from - they suggested the code.
The following code is what I have been using:
PHP Code:
<?
$ud_id=$_POST['ud_id'];
$ud_mtitle=$_POST['ud_mtitle'];
$ud_mkey=$_POST['ud_mkey'];
$ud_mdesc=$_POST['ud_mdesc'];
$ud_header=$_POST['ud_header'];
$ud_content=$_POST['ud_content'];
$ud_oneliner=$_POST['ud_oneliner'];
$ud_cat=$_POST['ud_cat'];
$ud_img=$_POST['ud_img'];
$ud_navlink=$_POST['ud_navlink'];
$ud_nav=$_POST['ud_nav'];
$db="site_com_-_tbl_news";
$link = mysql_connect("127.0.0.1","username", "password");
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());
mysql_query("UPDATE tbl_Hpages SET HpagesMTitle='$ud_mtitle' ,HpagesMKey='$ud_mkey' ,HpagesMDesc='$ud_mdesc' ,HpagesHeader='$ud_header' ,HpagesContent='$ud_content' ,HpagesOne_liner='$ud_oneliner', HpagesCat='$ud_cat' ,HpagesImg='$ud_img' ,HpagesNavLink='$ud_navlink' ,HpagesNav='$ud_nav' WHERE HpagesID='$ud_id'");
echo "Record Updated";
mysql_close($link);
?>
Any suggestions?
