[SOLVED] Help to save nothing!

[Bullet]

Well I'm trying to make a notepad & everytime I clear it and save it dosen't let me if there isn't a word or space there. Abit of the script:

 

if (($_POST['change_notes']) && ($_POST['notes'])){

$notes=strip_tags($_POST['notes']);

 

mysql_query("UPDATE members SET notes='$notes' WHERE username='$username'");

echo "Your notepad has been updated.";

}

?>

 

Any help? Please? 

[Fadion]

Are you getting any errors? Try this code to check if the query fails and what errors it shows:

 

mysql_query("UPDATE members SET notes='$notes' WHERE username='$username'") or die(mysql_error());

[Bullet]

There is no error, it just refreshes

[budimir]

Maybe, you could use:

 

if (isset($_POST[])){  mysql_query("UPDATE members SET notes='$notes' WHERE username='$username'");
echo "Your notepad has been updated."; } else {
do nothing }

 

I'm not quite sure what you're problem is, but maybe this can help

[r-it]

if it has to do with your sql statement, change this:

mysql_query("UPDATE members SET notes='$notes' WHERE username='$username'");
echo "Your notepad has been updated.";
}
?>

to

mysql_query("UPDATE members SET notes='".$notes."' WHERE username='$username'");
echo "Your notepad has been updated.";
}
?>

and also check that the syntax is correct

[Bullet]

I changed to what budimir said it came up with a error saying:

Fatal error: Cannot use [] for reading in /home/public_html/editnotepad.php on line 15

 

PHP:

if (($_POST['change_notes']) && ($_POST['notes'])){

$notes=strip_tags($_POST['notes']);

 

if (isset($_POST[])){  mysql_query("UPDATE users SET notes='$notes' WHERE username='$username'");

echo "Your notepad has been updated."; } else {

do nothing }

 

 

[budimir]

That's right you need to do this:

if (($_POST['change_notes']) && ($_POST['notes'])){
$notes=strip_tags($_POST['notes']);

if (isset($_POST['notes'])) { mysql_query("UPDATE users SET notes='$notes' WHERE username='$username'");
echo "Your notepad has been updated."; } else {
do nothing }

 

I thought you are going to notice that! Sorry...

[PFMaBiSmAd]

The first line is back to the original logic and won't execute anything when $_POST['notes'] has been cleared.

 

If you want your query to execute when you have cleared the 'notes' form field, just use -

 

if ($_POST['change_notes']){

[Bullet]

Thanks so much all!