Javascript and PHP-MySQL

lordgreg

Hello,..

i'm doing a project.. some sort of sending messages to registered users on my page. this is my problem:

i've got a script:

$query = "select * from messages_main where FOR='$nettech_user' and NEW=1";
$result = mysql_query($query);
$sporocil = mysql_num_rows($result);

if ($msg > 0) {
	echo "	<script>
	var stay=confirm(\"You've got new message ($msg). Do you want to read them no?\")
	if (stay) 
	window.location=\"messages.php\"
</script>\n";
}

now, i want to make a script, when you hit the cancel button, that the column NEW in mysql base would change from 1 to 0. but i don't know how to do that??

thank you for your help,

gregor

stereo

if ($msg > 0) {
echo " <script>
var stay=confirm(\"You've got new message ($msg). Do you want to read them no?\")
} else {

mysql_query("UPDATE messages_main SET NEW = 0;");

}

if (stay){
window.location=\"messages.php\"
</script>\n";
}

That might work 🙂 If it doesn't, I dunno. Hope it helps anyway.

~~Stereo

Anon

After you checked whether there are new messages or not, why don't you just set NEW = 0?
If they want to read them, fine, your javascript takes care of that - and they don't have any new messages after that.
If the don't want to read them, NEW is set to 0 so they won't be troubled the next time the script runs (not until another message arrives that is)

This is sort of what Stereo said but he just gave you the code 🙂

/Thomas

stereo

heheh, yeah! 🙂

lordgreg

yeah.. i think this is always the same. programer always takes a harder way to make some thing,..

thank you both, stereo and thomas 😉