PHP alert help needed

[batowiise]

Hi All,

I need help on implementing an alert using PHP and MySQL. The following is the plan:

1. User makes a requisition and the manager approves of it.

2. I want the manager to be alerted/notified of an impending requisition in the form of an alert.

The following is what i have done but it's not working:

$result = @("SELECT * FROM users");
$sendAlert = mysql_result($result,0,'financealert');
if($sendAlert =='Yes'){
?>
<script type="text/javascript">
windows.alert('ATTENTION');
</script>
<?php
}
?>

Your help is welcome.

Regards.

[dalecosp]

Well, the first step to debugging is to remove the @ and see if the query is failing.

Now, that said, there's nothing in your post about your database content. If you have a field that would contain the text "financealert", why not just put that in the query?

<?php

db_conn(); // whatever your connection setup code is....

$query="select $alertfieldname from users where $alertfieldname='financealert'";

$result=mysql_query($result);

if ($result) {
   // Javascript alert code here

}