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:

<?php
require_once("admin/db.php");
$result = @mysql_query("SELECT * FROM users");
if($row['financealert']=='Yes'){
?>
<script type="text/javascript">
windows.alert('ATTENTION');
</script>
<?php
}
?>

Your help is welcome.

Regards.

[Nile]

You aren't defining $row in that code - what error did you receive?

[batowiise]

It just escaped me, i have modified the previous code to the following:

require_once("admin/db.php");
$result = @mysql_query("SELECT * FROM users where username='$uname'");
$row = mysql_fetch_array($result);
if($row['financealert']=='Yes'){
?>
<script type="text/javascript">
windows.alert('ATTENTION');
</script>
<?php
}
?>

Am still not getting the alert after defining the $row.

Regards

[Nile]

Put or die(mysql_error()) after you're mysql functions. Is financealert 'Yes' in the first row returns by your query?

[batowiise]

After placing the die(mysql_error()), the alert still did not come up. financealert 'Yes' is return by query in the database.

require_once("admin/db.php");
$result = @mysql_query("SELECT * FROM users");
$row = mysql_fetch_array($result);
die(mysql_error());
if($row['financealert']=='Yes'){
?>
<script type="text/javascript">
windows.alert('ATTENTION');
</script>
<?php
}
?>

Regards.

[Nile]

<?php
require_once("admin/db.php");
$result = mysql_query("SELECT * FROM users where username='$uname'") or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());    
if($row['financealert'] == "Yes"){
?>
<script type="text/javascript">
  alert('ATTENTION');
</script>
<?php
}
?>

[bluewalrus]

Try

<?php
require_once("admin/db.php");
$result = @mysql_query("SELECT * FROM users");
$row = mysql_fetch_array($result);
die(mysql_error());
if($row['financealert']=='Yes'){
?>
<script type="text/javascript">
alert('ATTENTION');
</script>
<?php
echo "Got in the IF?";
}
?>

[Nile]

Any updates?

[batowiise]

Hi all,

I need the PHP code for the following scenario and this is the logic:

If user_session = username
and financealert == 'yes'
pop up an alert.

Your help is much needed.

Regards.

[djr33]

You'll need to explain the details a lot more. If you have some code already, please post it. If not, how do you plan to determine those values? Where are they stored? What software are you using?
If you don't have anything (and you don't know how to do it) you may want to ask for paid help for someone to build a whole system for you.