|
Current Text:
hzi_mysql_connect();
$ID = $_GET['ID'];
$sql = "Select * FROM `text` WHERE `ID` = " . $ID . " LIMIT 1";
$result = mysql_query($sql)
or die("Quary failed: " . mysql_error());
$text = mysql_fetch_array($result);
echo $text['text'];
?>
if($_POST)
{
$sql = 'UPDATE `text` SET `text` = \'' . $_POST['desc'] . '\', `time_added` = \'' . time() . '\' WHERE `ID` = ' . $ID . ' LIMIT 1';
$result = mysql_query($sql)
or die("MySQL error: " . mysql_error());
echo " Text updated.";
hzi_mysql_close();
}
else
{
?>
hzi_mysql_connect();
$imageID = $_GET['ID'];
$sql = 'SELECT `desc` FROM `photos` WHERE ID = ' . $imageID;
$result = mysql_query($sql)
or die("MySQL error: " . mysql_error());
$imagedata = mysql_fetch_array($result);
?>
hzi_mysql_close();
}
?>
|
|