My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Mar 9th, 2010 | Syntax: PHP | Size: 0.23 KB | Hits: 150 | Expires: Never
Download | Raw | Embed | Report abuse
This paste has a previous version, view the difference. Copy text to clipboard
  1. <?php
  2.  
  3. $q = mysql_query("SELECT COUNT(*) FROM messages WHERE `to` = '1'");
  4. $total = mysql_result($q, 0);
  5.  
  6. $q = mysql_query("SELECT COUNT(*) FROM messages WHERE `to` = '1' AND `read` = '0'");
  7. $unread = mysql_result($q, 0);
  8.  
  9. ?>
create new paste | create new version of this paste RAW Paste Data