I'm having a problem with updating entires in a mySQL DB table. It seems to update properly in IE, but in FF it just clears the contents, instead of adding what I entered in the form. Any help is much appreciated, thank you,.
PHP Code:
<?php
include("site_config.php");
if($_GET["action"] == "update_settings")
{
$title = addslashes(trim($_POST["title"]));
$status = addslashes(trim($_POST["status"]));
$logo = addslashes(trim($_POST["logo"]));
$offline = addslashes(trim($_POST["offline"]));
$left = addslashes(trim($_POST["left_logo"]));
mysql_query("UPDATE `settings` SET `title` = '$title', `status` = '$status', `main_logo` = '$logo', `offline_text` = '$offline', `logo_left` = '$left_logo' WHERE 1=1") or die(mysql_error());
}
else
{
$fetch = @mysql_fetch_array(mysql_query("SELECT * FROM `settings`"));
$title = $fetch["title"];
$status = $fetch["status"];
$logo = $fetch["main_logo"];
$offline = $fetch["offline_text"];
$left = $fetch["logo_left"];
}
$html = <<<HTML
<form action="?action=update_settings" method="post">
<h2>site title - <span>this is the title your browser displays for your website.</span></h2><br />
<input class="textbox" name="title" type="text" value="$title"/>
<h2>site status - <span>this declares whther your site is online or offline.</span></h2><br />
<input name="status" type="radio" value="offline">Offline</input> <input name="status" type="radio" value="online">Online</input>
<h2>offline notice - <span>this is the message users see when the website is set to offline.</span></h2>
<textarea class="textarea" name="offline" type="text">$offline</textarea>
<h2>main logo - <span>this is your sites main logo.</span></h2>
<input class="textbox" name="logo" type="text" value="$logo"/>
<h2>semi-main logo - <span>this is your sites semi-main logo. its the bigger logo seen on the left of each page.</span></h2><br />
<input class="textbox" name="left_logo" type="text" value="$left_logo"/>
<br /><br />
<input type="submit" value="edit settings" class="submit" />
</form>
HTML;
echo($html);
?>