title: PHP SQL on click update number
body: <p>I have a notifications system and after many late nighters and dr peppers I finally have it working.  My only issue is that the notifications "bell" has the number of new notifications in the middle of it.  When I click the button it will show me my unread notifications and when I close it the number of unread notifications stays the same.  I'm using a sql statement to get the number of unread posts on load but when I click the button I'd like it to update the number of unread posts.</p>
  
  <p>Here's some code I have:</p>
  
  <pre><code>//GETS THE NUMBER OF UNREAD POSTS
  $readquery = mysql_query("SELECT * FROM notifications WHERE (needs='$username' AND needsread='0' AND type='workneed') OR (worker='$username' AND workerread='0')");
  $number = mysql_num_rows($readquery);
  
  
  
  //GETS THE NOTIFICATIONS
  function toggleDiv(divId) {
     $("#"+divId).show();
  
  $(document).ready(function(){
     $("#myContent").load("getnotes.php");
  });
  }
  
  
  //BUTTON TO PRESS TO SHOW THE NOTIFICATIONS PANEL
  &lt;a data-ajax="false" href="#myContent" onclick="toggleDiv('myContent');" data-role="button" data-iconpos="notext" class="icon-bell-alt icon-2x" style="background: none; margin-right: 20px;"&gt;&lt;/a&gt;
  
  
  //SHOWS THE NUMBER OF UNREAD POSTS
  &lt;div id='notes_number'&gt;&lt;? if ($number == "0") { echo $number; } else { echo "&lt;a style='color: #FF0000;'&gt;$number&lt;/a&gt;"; }?&gt;&lt;/div&gt;
  </code></pre>
  
  <p>What can I do to update the number?</p>