[Resolved] need help creating javascript alert

jacksonpt

this may be more of an html/javascript question, but...

I've got a javascript function defined that displays an alert box notifying the user how many records have been found based on a given query.

<SCRIPT LANGUAGE="JavaScript">
<!--
   function DisplayRecordCount(count) {
      alert("Number of scholarships found: " + count);
   }
-->
</SCRIPT>

Pretty straight forward, right?

Then I get into php. Here's the abridged version of what I'm doing:

     $result = mysql_query("SELECT * FROM Scholarships 
	                   WHERE School LIKE '$School' OR School LIKE 'All'",$db);
    $record = mysql_fetch_array($result);

if ($record) {
  ...
  ...
  ...
  do {
     ...
     ...
     ...
     $Count = $Count + 1;
  }
  while
  ...
  ...
  ...
   }

Now that $Count has been incremented, I need to call the javascript function. How do I do make this call automatically (i.e. as the page loads)? The kicker is it has to be after $Count is incremented, so it can't go in the body tag as an onLoad() call.

jacksonpt

never mind, I got it. Incase anyone else every has the same question, here's the code (I put it at the end of my page):

     echo "  <SCRIPT LANGUAGE=\"JavaScript\">\n";
     echo "<!--\n";
     echo "  DisplayRecordCount($Count)\n";
	 echo "-->\n";
     echo "</SCRIPT>\n";

petitduc

Simply put in the appropriate place

echo "<script>DisplayRecordCount($Count);</script>";

jacksonpt

Yea, I got my brain tangled up and overthought things... basically trying to make things more complicated than they should be. In essense, my problem was that I had forgotten the <script> tags.