mySQL Not Updating?

Hypertext · 09-03-2008, 12:51 AM

Still, you shouldn't use in it development. put that same statement on your mysql connection eg

mysql_connect($x, $y, $z) or die(mysql_error());

loserWILL · 09-03-2008, 01:26 AM

***.
Why isn't this working. ;l

Hypertext · 09-03-2008, 01:50 AM

post your new code, also why do you have spaces between all ( and ) don't it might be the problem, i doubt it but maybe.

try this

Code:

 <?php

include("site_config.php");
if($_GET["action"] == "update_settings")
{
    $title = $_POST["title"];
    $status = $_POST["status"];
    $logo = $_POST["main_logo"];
    $offline = $_POST["offline"];
    $left = $_POST["left_logo"];
    mysql_query("UPDATE `settings` SET `title` = '$title', `main_logo` = '$logo', `offline_text` = '$offline', `status` = '$status', `logo_left` = '$left'");
}
else 
{
    $fetch = mysql_fetch_array(mysql_query("SELECT * FROM `settings`"));
    $title = $fetch["title"];
    $status = $fetch["statust"];
    $logo = $fetch["main_logo"];
    $offline = $fetch["offline_text"];
    $left_logo = $fetch["logo_left"];
?>
<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="main_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>
<?php } ?>

loserWILL · 09-03-2008, 01:53 AM

Here:

PHP Code:


<?php

include( "site_config.php" );
if( $_GET["action"] == "update_settings" )
{

    $title = $_POST["title"];
    $status = $_POST["status"];
    $logo = $_POST["logo"];
    $offline = $_POST["offline"];
    $left = $_POST["left_logo"];
    mysql_query( "UPDATE `settings` SET `title` = '$title', `status` = '$status', `main_logo` = '$logo', `offline_text` = '$offline', `logo_left` = '$left_logo' " ) 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 );

?>

Hypertext · 09-03-2008, 01:54 AM

try my above

loserWILL · 09-03-2008, 01:55 AM

That doesn't fix it.

loserWILL · 09-03-2008, 02:09 AM

I've determined the problem - it updates when I'm using IE, but it doesn't update in FF.

That's ****** up.

Hypertext · 09-03-2008, 02:11 AM

Ouch, sorry my friend, IE sucks, it's probably that your doing something wrong and IE is lucky, whereas firefox is sticking to its proper standards and not letting it happen.

loserWILL · 09-03-2008, 03:05 PM

Does anybody know why it's doing that?

Agnostic Bear · 09-03-2008, 04:42 PM

Originally Posted by Navicat

No, I am pretty sure it doesn't.

It does, action="" will submit the form to the page you're currently on.

Thread: mySQL Not Updating?

Thread Tools

Posting Permissions