This is the update script
Code: Select all
<?php /*?>Select a row from database for one event<?php */?>
<?
$db=mysql_connect ("localhost") or die(mysql_error());
mysql_select_db("uptodatalinks") or die(mysql_error());
$query = "SELECT website, title, description, priority, categoryID FROM ArticlesHelpTips WHERE ArticlesHelpTipsID=$ArticlesHelpTipsID";
$result=mysql_query($query) or die(mysql_error());
while ($record=mysql_fetch_array($result)) {
/*echo $record['EventID'].", ".$record['date'].", ".$record['therapy'].", ".$record['location'].", ".$record['course_details'];
echo"<br><br>"; */
$setwebsite=trim($record['website']);
$settitle=$record['title'];
$setdescription=$record['description'];
$setpriority=trim($record['priority']);
$setcategoryID=trim($record['categoryID']);
}
echo "setcategoryID is ".$setcategoryID;
?>
<!--Create Form-->
<form id="form1" name="form1" method="post" action="ReplaceArticles.php?ArticlesHelpTipsID=<? echo $ArticlesHelpTipsID ?>">
<br />
Select Category
<select name="CategoriesID" >
<?php require_once('../Connections/uptodatalinks.php'); ?>
<?php
$db=mysql_connect ("localhost") or die(mysql_error());
mysql_select_db("uptodatalinks") or die(mysql_error());
$query2 = "SELECT * FROM categories";
$result2=mysql_query($query2);
while ($record2=mysql_fetch_assoc($result2)) {
if ($setcategoryID != $record2["CategoriesID"]) {
echo "<OPTION VALUE = '".$record2["CategoriesID"]."'>".$record2["Categories"];
}
else{
echo "<OPTION VALUE selected = '".$record2["CategoriesID"]."'>".$record2["Categories"];
}
}Code: Select all
<?php
$website = $_POST['Website'];
$description = addslashes($_POST['Description']);
$title = $_POST['Title'];
$ArticlesHelpTipsID = $_GET['ArticlesHelpTipsID'];
$CategoriesID = $_POST['CategoriesID'];
echo "</br>"."The CategoriesID is ".$CategoriesID;
$link="<br><br><a href='ShowAllArticles.php'>Show All Articles";
/*Validate input*/
$Description=trim($Description);
if (!$Title or !$Description) {echo "You must complete all entries";
echo $link;
exit;
}
$db=mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("uptodatalinks") or die(mysql_error());
$adddata = "UPDATE ArticlesHelpTips SET
Website='$Website',
Title='$Title',
Description='$Description',
CategoryID='$CategoriesID'
WHERE ArticlesHelpTipsID=$ArticlesHelpTipsID";
$result = mysql_query($adddata) or die(mysql_error());
echo "You have successfully replaced the article";
echo $link;
?>