Troublesome Code.

["Chris Knipe" <savage@xxxxxxxxxxxxx>]

Lo everyone,

Can someone please perhaps just indicate to me what is wrong with the below 
code?  I am getting SQL Result errors, but all the queries executes 
successfully.

Errors in browser:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result 
resource in 
/usr/local/www/v-webs/O/OUR001/management.ournet.co.za/htdocs/dialupadmin/index.php 
on line 11

Warning: Cannot modify header information - headers already sent by (output 
started at 
/usr/local/www/v-webs/O/OUR001/management.ournet.co.za/htdocs/dialupadmin/index.php:11) 
in 
/usr/local/www/v-webs/O/OUR001/management.ournet.co.za/htdocs/dialupadmin/index.php 
on line 28

Warning: Cannot modify header information - headers already sent by (output 
started at 
/usr/local/www/v-webs/O/OUR001/management.ournet.co.za/htdocs/dialupadmin/index.php:11) 
in 
/usr/local/www/v-webs/O/OUR001/management.ournet.co.za/htdocs/dialupadmin/index.php 
on line 29

Authentication Required.



Below is the code with explanations...

<?
 if (!isset($_SERVER['PHP_AUTH_USER'])) {
   header('WWW-Authenticate: Basic realm="Cenergy Dialup Admin"');
   header('HTTP/1.0 401 Unauthorized');
   WritePageStart("Error - Authentication Required", "", "");
   echo "<p>Authentication Required.</p>";
   WritePageEnd();
   exit;
 } else {
   $SQL = mysql_query("SELECT RadiusAdmin.isWIFI AS isWIFI, 
RadiusAdmin.isPPTP AS isPPTP, RadiusAdmin.isDIAL AS isDIAL, 
RadiusAdmin.MinTokens AS MinTokens, RadiusAdmin.TokenCost AS TokenCost, 
RadiusAdmin.CustID AS CustID, RadiusAdmin.Realm AS Realm, SMTPZones.EntryID 
AS ZoneID, RadiusAdmin.Username AS AccountName, RadiusAdmin.Tokens AS 
Tokens, RadiusAdmin.Balance AS Balance FROM RadiusAdmin LEFT JOIN SMTPZones 
ON RadiusAdmin.Realm=SMTPZones.Zonename  WHERE RadiusAdmin.Username='" . 
$_SERVER['PHP_AUTH_USER'] . "' AND RadiusAdmin.Password=MD5('" . 
$_SERVER['PHP_AUTH_PW'] . "') LIMIT 1");

^^^ Line 10.  Query does execute successfully, and returns 1 Row.


   if (mysql_num_rows($SQL) == 1) {
^^^^^^ Line 11 (I also tried == "1" to no avail).

     while ($Data = mysql_fetch_array($SQL)) {
       $_SESSION['Username'] = $_SERVER['PHP_AUTH_USER'];
       $_SESSION['CustID'] = $Data['CustID'];
       $_SESSION['ZoneID'] = $Data['ZoneID'];
       $_SESSION['Realm'] = $Data['Realm'];
       $_SESSION['AccountName'] = $Data['AccountName'];
       $_SESSION['Tokens'] = $Data['Tokens'];
       $_SESSION['TokenCost'] = $Data['TokenCost'];
       $_SESSION['MinTokens'] = $Data['MinTokens'];
       $_SESSION['isDIAL'] = $Data['isDIAL'];
       $_SESSION['isPPTP'] = $Data['isPPTP'];
       $_SESSION['isWIFI'] = $Data['isWIFI'];
       $_SESSION['Balance'] = $Data['Balance'];
     }
     $SQL = mysql_query("UPDATE RadiusAdmin SET LastAccess=NOW() WHERE 
Username='" . $_SERVER['PHP_AUTH_USER'] . "'");
   } else {
     header('WWW-Authenticate: Basic realm="Cenergy Dialup Admin"');
     header('HTTP/1.0 401 Unauthorized');
^^^^^^^^ This generates the last two errors - hence, my problem is at line 
10 & 11?
     WritePageStart("Error", "", "");
     echo "<p>Authentication Required.</p>";
     WritePageEnd();
     exit;
   }
 }


Thanks,
Chris. 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php