USER NOTIFICATION...on FUNCTION EXECUTION

[gnawz]

I have a database for posting a new record.

I have a field for status.

Every time a new record is added to the table the status fro unread is 1 while that for read is 2.

 

I want a user to be notified while he/she is logged in by a sound or pop-up whenever a new record has been

added or when status has changed ie when an update takes place.

 

PLEASE HELP.

 

My update code is something like this:

 

 

$sql = 'UPDATE exportatltable SET Depot="'.$_POST["Depot"].'",

CustomerName="'.$_POST["CustomerName"].'",Address="'.$_POST["Address"].'",EmailAddress= "'.$_POST["EmailAddress"].'",

Country="'.$_POST["Country"].'",Product1="'.$_POST["Producta"].'",Product2="'.$_POST["Productb"].'",Product3="'.$_POST["Productc"].'",

TotalProductQuantity="'.$_POST["TotalQuantity"].'",

TotalPrice="'.$_POST["TotalPrice"].'",TruckDetails="'.$_POST["TruckDetails"].'",Destination= "'.$_POST["Destination"].'",

PreparedBy="'.$_POST["PreparedBy"].'",AuthorisedBy="'.$_POST["AuthorisedBy"].'",AccountBf="'.$_POST["Accountbf"].'",

AmountRecieved="'.$_POST["AmountReceived"].'",LessThisOrder="'.$_POST["LessThisOrder"].'",Balance="'.$_POST["Balance"].'",

Currency="'.$_POST["Currency"].'",Narration="'.$_POST["Narration"].'",FinanceNote="'.$_POST["FinanceNote"].'",Status = 1, Date = Now() WHERE PfiNo="'.$_POST["PfiNo"].'"';

$query = mysql_query($sql);

 

I want a pop-up or sound or any other form of notification to any user logged in whenever

this code is executed successfully!

 

AFNY IDEAS??

[micah1701]

since all the code you posted is server-side PHP and any "pop-up" or "sound" alerts would have to be triggered client side -- this looks like a job for AJAX!  check out the other forum on this board.

[ramli]

Depending on your formulation you can use somthing like this:

 

<SCRIPT LANGUAGE="JavaScript">

<!-- start

alert("Update Successfull")

// end-->

</script>

 

Put this in a echo when your code is executed successfully