Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,472
There are 1918 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

UPDATE Problems

Thread title: UPDATE Problems
     
    Thread tools Search this thread Display Modes  
Prev Previous Post   Next Post Next
03-10-2008, 07:01 PM
#1
Will Green is offline Will Green
Status: I'm new around here
Join date: Mar 2008
Location:
Expertise:
Software:
 
Posts: 9
iTrader: 0 / 0%
 

Will Green is on a distinguished road

  Old  UPDATE Problems

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>&nbsp;<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);

?>

     


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed