PHP - Error Check - Driving Me Crazy

Ok, so the error I get is Parse error: syntax error, unexpected $end in /home/a3868616/public_html/skin_files/skin_manager.php on line 168.  In dreamweaver, it tells me there is an error on line 141, which is the first line to be returned ( Code: [Select]
<table cellspacing="0" class="tableborder" width="85%" align="center">) in the contract function.  I've looked at this over and over, and I can't find any brackets that aren't closed.  All of the lines of code seem to be in their correct syntax.  I was thinking maybe the EOF in the else after the while was causing it, but same errors different line numbers when I removed that.  What the hell can it be!? The whole php file is below.

<?php

class skin_manager{

function show(){

global $DB, $projectx, $func, $game;

return <<<EOF

<table cellspacing="0" cellpadding="0" width="100%">

<tr>

<td width="40%" valign="top">

<table cellspacing="0" class="tableborder" width="100%">

<tr>

<td class="mainrow">Manager Page</td>

</tr>

<tr>

<td>

<div class="tablepad">

<table cellspacing="0" cellpadding="3" width="100%">

<tr>

<td class="row1"><a href="#">Finances</a></td>

</tr>

<tr>

<td class="row2"><a href="manager.php?act=contracts">Contracts</a></td>

</tr>

<tr>

<td class="row1"><a href="#">Holiday Mode</a></td>

</tr>

</table>

</div>

</td>

</tr>

</table>

</td>

<td width="2%"></td>

<td width="40%">

<table cellspacing="0" class="tableborder" width="100%">

<tr>

<td class="mainrow">Manager Releases</td>

</tr>

<tr>

<td>

<div class="tablepad">

<table cellspacing="0" cellpadding="3" width="100%">

<tr>

<td class="rowheader" colspan="2">Singles</td>

</tr>

<tr>

<td class="row2" width="25%">Gold:</td>

<td class="row2" width="75%">{$band_name}</td>

</tr>

<tr>

<td class="row1" width="25%">Platinum:</td>

<td class="row1" width="75%">{$band_genre}</td>

</tr>

<tr>

<td class="row2" width="25%">Multi-Platinum:</td>

<td class="row2" width="75%">{$band_status}</td>

</tr>

<tr>

<td class="row1" width="25%">Number 1:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

<tr>

<td class="row1" width="25%">Total:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

<tr>

<td class="rowheader" colspan="2">Albums</td>

</tr>

<tr>

<td class="row2" width="25%">Gold:</td>

<td class="row2" width="75%">{$band_name}</td>

</tr>

<tr>

<td class="row1" width="25%">Platinum:</td>

<td class="row1" width="75%">{$band_genre}</td>

</tr>

<tr>

<td class="row2" width="25%">Multi-Platinum:</td>

<td class="row2" width="75%">{$band_status}</td>

</tr>

<tr>

<td class="row1" width="25%">Number 1:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

<tr>

<td class="row1" width="25%">Total:</td>

<td class="row1" width="75%">{$band_created}</td>

</tr>

</table>

</div>

</td>

</tr>

</table>

</td>

<td width="18%"></td>

</tr>

</table>
EOF;

} // end function show

function contract(){

global $DB, $projectx, $func;

$contracts_q = $DB->query("SELECT * FROM `contracts` RIGHT JOIN `bands` ON (contracts.contract_band = bands.band_id) LEFT JOIN `labels` ON (contracts.contract_from = labels.label_id) WHERE contracts.contract_manager='{$projectx->member['id']}'");

if($DB->get_num_rows()){

while($row = $DB->fetch_array($contracts_q)){

$pcontracts .= "<tr>";

if($style != 2){

$class = "row2";

$style = 1;

}else{

$class = "row1";

$style = 2;

}

$pcontracts .= "<td class=\"{$class}\" width=\"20%\">{$row['band_name']}</td>";

$pcontracts .= "<td class=\"{$class}\" width=\"20%\">{$row['label_name']}</td>";

$clength = explode(",", $row['contract_length']);

$csingles = explode("|", $clength[0]);

$calbums = explode("|", $clength[1]);

$pcontracts .= "<td class=\"{$class}\" width=\"30%\">{$csingles[0]} singles ({$csingles[1]}% cut), {$calbums[0]} albums ({$calbums[1]}% cut)</td>";

$pcontracts .= "<td class=\"{$class}\" width=\"10%\">{$row['contract_amount']}</td>";

$pcontracts .= "<td class=\"{$class}\" width=\"20%\">Accept / Reject</td>";

$pcontracts .= "</tr>";

}

}else{

$pcontracts = <<<EOF

<tr>

<td class="row2" colspan="5">You have no contracts.</td>

</tr>
EOF;

}

return <<<EOF

<table cellspacing="0" class="tableborder" width="85%" align="center">

<tr>

<td class="mainrow">Contracts</td>

</tr>

<tr>

<td>

<div class="tablepad">

<table cellspacing="0" cellpadding="3" width="100%">

<tr>

<td class="rowheader" width="20%">Band</td>

<td class="rowheader" width="20%">From</td>

<td class="rowheader" width="30%">Terms</td>

<td class="rowheader" width="10%">Amount</td>

<td class="rowheader" width="20%">Decision</td>

</tr>

</table>

</div>

</td>

</tr>

</table>
EOF;

} // end function contract

} // end class skin_manager

?>

Hi,

The code below is not yet finished but i left it today and went to do something came back and forgot where i left off half way through code. It says Parse error: syntax error, unexpected $end in C:\wamp\www\member\login.php on line 305. Not on line 305 thou as that is the last line. I think i have missed a parentheses or curly bracelet. My eyes are watering now i have looked over and over. Please someone help.

Like i say it's not yet finished or formatted to it's best but hopefully one of you people on here can help me

Thanks


<?php
//ob_start();

// Include config.php
require_once("".$_SERVER['DOCUMENT_ROOT']."/lib/config.php");

// top.inc.php
require_once($top_inc);
?>

<!-- Meta start -->
<title><?php echo $websitename; ?> - Member Login</title>
<meta name="description" content="<?php echo $websitename; ?> - Member Login" />
<meta name="keywords" content="<?php echo $websitename; ?>, login, signup, register, sign in, signin, sign up" />
<!-- Meta end -->

<?php
// main.inc.php
require_once($main_inc);
?>

<!-- CONTENT HERE -->


<?php
    // Check if form has been submitted
    if(isset($_POST['submit']) && $_SERVER['REQUEST_METHOD'] == 'POST'){

        # Connect to databse
        sql_con();

        # Get form data and cleanse
        $username = msqls(trim($_POST['username']));
        $password = msqls(trim($_POST['password']));
        $ip = msqls($_SERVER['REMOTE_ADDR']);

        # Validate form data
        if (utfstrlen($username) < 1) {
            $error .= "Please enter your username <br />";
        }
        if (utfstrlen($username) > 0 && !preg_match(constant("USERNAME_REGEX"), $username)) {
            $error .= "Username invalid format <br />";
        }
        if (utfstrlen($password) < 1) {
            $error .= "Please enter your password <br />";
        }
        if (utfstrlen($password) > 0 && !preg_match(constant('PASSWORD_REGEX'), $password)) {
            $error .= "Password invalid format<br />";
        }

        # If error founds display them
        if(isset($error)){
        $SiteErrorMessages = "$error";
        SiteErrorMessages();
        } # else no errors found continue processing
        else {
            # Check if user has activated there account
            $status_check = mysql_query("SELECT username FROM ".constant("TBL_USERS")."
            WHERE username = '$username' AND status = '".constant("USER_STATUS_VERIFY")."' LIMIT 1");

            # Check if user has requested account to be deleted
            $delete_check = mysql_query("SELECT username FROM ".constant("TBL_USERS")."
            WHERE username = '$username' AND status = '".constant("USER_STATUS_DELETE")."'
            AND password = '".sha1($password)."' LIMIT 1");

            # Check if user has been suspended
            $username_status_check = mysql_query("SELECT username, suspended_note FROM ".constant("TBL_USERS")."
            WHERE username = '$username' AND status = '".constant("USER_STATUS_SUSPENDED")."'
            AND password = '".sha1($password)."' LIMIT 1");

            # Check above queries if error occurs notify user
            if(!$delete_check || !$status_check || !$username_status_check){
            echo '<h1>Oops something went wrong :(</h1>';

            $SiteErrorMessages =
            "Something went wrong while processing your request. Please try again later.
            <br /> $websitename has been notified of this error and will investigate further.";

            SiteErrorMessages();

            # This variable will be passed to the site_errors_email_notification function
            $site_error_email_message_notification = "User Login Failure <br />
            A user tried to login but the verify, suspended or delete query check failed.
            <br /><br /><b>".mysql_error()."</b><br /><br />
            There details are below. <br /><br />
            Username: <b>$username</b> <br />";
            # This function will pass the above variable (message) to the admin error notify function
            # to send admin an email to notify them of an error
            site_errors_email_notification();

            include("$footer_inc");
            exit;
            } # else queries ok continue processing
            else {
                 # Check delete query
                 if (mysql_num_rows($delete_check) == 1) {
                 echo '<h1>Account Deletion In Process</h1>';
                 echo "<p><b>Sorry, you cannot login to your account as you requested your account to be deleted.</b>
                      <b>Your account is queued for deletion from the $websitename database and will be deleted within 24 hours.</b></p>";

                 echo "<p><b>$websitename sent you a confirmation email when you requested your account to be removed.</b>
                      <b>If you did not make this request via your account please <a href=\"../contactus.php\">contact us</a> immediately.</b></p>";

                 echo "<p><b>Please note that it may not be possible to recover your account as the process is automated.</b></p>";
                 header( 'refresh: 60; url=$websiteaddress' );
                 include ("$footer_inc");
                 exit;
                 }
                 # Check status query
                 elseif (mysql_num_rows($status_check) == 1) {
                 echo "<h1>Account Activation Required</h1>";
                 echo "<p><b>You must activate your account via email before you can login.</b></p>";
                 header( 'refresh: 10; url=resendactivationemail.php' );
                 include ("$footer_inc");
                 exit;
                }
                 # Check username status query
                 elseif (mysql_num_rows($username_status_check) == 1) {
                 $row = mysql_fetch_row($username_status_check);
                 echo "<h1>Account Suspended</h1>";
                 echo "<p>Dear <b>" . $row[0] . "</b>, <br />
                      Your account has been suspended. The administrator has left the
                      following message:</p>";

                 $no_suspended_note =
                 "The administrator has not left a message. <br />
                 If you feel your account has been suspended in error please contact $websitename <a href=\"/contactus.php\">here</a>.";

                 if (utfstrlen($row[1]) < 1) {
                    $SiteWarningMessages = "$no_suspended_note";
                    SiteWarningMessages();
                    include ("$footer_inc");
                    exit;
                 } else {
                    $SiteWarningMessages = " . $row[1] . ";
                    SiteWarningMessages();
                    echo '<p>If you feel your account has been suspended in error please contact ' . $websitename . ' <a href="/contactus.php">here</a>.<br />
                    <b>Please include your username when contacting ' . $websitename . '.</b></p>';
                    include ("$footer_inc");
                    exit;
                }
            } # else user must be ok to login so continue ...
            else {
                # Login Query
                $query = mysql_query("SELECT id, admin, username, first_name, last_name, email, last_visited,
                date_time, websiteurl, msn, aim, yim, twitter, gender
                FROM ".constant("TBL_USERS")." WHERE username = '$username' AND
                password = '".sha1($password)."' LIMIT 1");

                # Check login query
                if(!$query){
                    echo '<h1>Oops something went wrong</h1>';

                    $SiteErrorMessages =
                    "Something went wrong while trying to log you in. Please try again later.
                    <br /> $websitename has been notified of this error and will investigate further.";

                    SiteErrorMessages();

                    // This variable will be passed to the site_errors_email_notification function
                    $site_error_email_message_notification = "User Login Failure <br />
                    A user tried to login but the Login Verification Check failed.
                    <br /><br /><b>".mysql_error()."</b><br /><br />
                    There details are below. <br /><br />
                    Username: <b>$username</b> <br />";
                    # This function will pass the above variable (message) to the admin error notify function
                    # to send admin an email to notify them of an error
                    site_errors_email_notification();

                    include("$footer_inc");
                    exit;
            } # else login query ok so continue
            else {
                # Validate credentials against DB
                if (mysql_num_rows($query) == 1) {
                    $found_user = mysql_fetch_array($query);

                    # Tell them they are being logged in
                    echo '<h1>Your now being logged in ...</h1>';
                    $SiteSuccessMessages = '<a href=\"/member/cp.php\">Click here if you
                    do not automatically redirect</a>';

                    SiteSuccessMessages();

                    # User logged in succesfully reset failed login number to 0
                    $failed_login_reset = mysql_query("UPDATE ".constant("TBL_USERS")." SET
                    `failed_login_count` = '0', `ip` = '" . $ip . "'
                    WHERE `username` = '" . $username . "' LIMIT 1");

                    # check failed login query
                    if(!$failed_login_reset){
                    // This variable will be passed to the site_errors_email_notification function
                    $site_error_email_message_notification = "User Login Failure <br />
                    A user logged in but the failed login reset counter query failed.
                    <br /><br /><b>".mysql_error()."</b><br /><br />
                    There details are below. <br /><br />
                    Username: <b>$username</b> <br />";
                    # This function will pass the above variable (message) to the admin error notify function
                    # to send admin an email to notify them of an error
                    site_errors_email_notification();
                    }

                    # Store all member data into session to use for later on other areas of the website
                    $_SESSION['username'] = $found_user['username'];
                    $_SESSION['id'] = $found_user['id'];
                    $_SESSION['admin'] = $found_user['admin'];
                    $_SESSION['last_visited'] = date('l dS F Y, g:i:s A', $found_user['last_visited']);
                    $_SESSION['first_name'] = $found_user['first_name'];
                    $_SESSION['last_name'] = $found_user['last_name'];
                    $_SESSION['email'] = $found_user['email'];
                    $_SESSION['websiteurl'] = $found_user['websiteurl'];
                    $_SESSION['msn'] = $found_user['msn'];
                    $_SESSION['aim'] = $found_user['aim'];
                    $_SESSION['yim'] = $found_user['yim'];
                    $_SESSION['twitter'] = $found_user['twitter'];
                    $_SESSION['gender'] = $found_user['gender'];
                    $_SESSION['date_time'] = date('l dS F Y, g:i:s A', $found_user['date_time']);
                    $_SESSION['date_time_for_profile'] = $found_user['date_time'];
                    $_SESSION['time'] = time();
                    if (isset($_GET['redirect'])) {
                        redirect($websiteaddress . $_GET['redirect'], 2);
                    } else {
                        redirect("cp.php", "0");
                    }
                    include ("$footer_inc");
                    exit;
            } # else login details invalid
            else {
                # Login Details Invalid Error
                echo 'Login Details Invalid';

                # If user fails 3 logins lock there account
                $login_failure_query = mysql_query("SELECT username, email, failed_login_count,
                status FROM ".constant("TBL_USERS")." WHERE username = '$username' AND
                status = '".constant("USER_STATUS_ACTIVATED")."' LIMIT 1");

                # Check if query ok
                if(!$login_failure_query){

                    # This variable will be passed to the site_errors_email_notification function
                    $site_error_email_message_notification = "Login Failure Query <br />
                    A user tried to login but the Login Failure Query Check failed.
                    <br /><br /><b>".mysql_error()."</b><br /><br />
                    There details are below. <br /><br />
                    Username: <b>$username</b> <br />";
                    # This function will pass the above variable (message) to the admin error notify function
                    # to send admin an email to notify them of an error
                    site_errors_email_notification();

                    include("$footer_inc");
                    exit;

                } # else login_failure_query ok so continue ...
                else {
                    # Check
                    if (mysql_num_rows($login_failure_query) == 1) {
                        # Fetch user row
                        $row = mysql_fetch_row($login_failure_query);
                        # Store data in variables
                        $username_ = $row[0];
                        $email = $row[1];
                        # Increment failed login row by 1 on each failed login
                        $login_count = $row[2] + 1;
                        # Update failed_login_count row each time login fails
                        $update_login_number = mysql_query("UPDATE ".constant("TBL_USERS")." SET `failed_login_count`
                        = '" . $login_count . "' WHERE `username` = '" . $username . "'");
                        # Fetch total failed logins
                        $login_count_total = $row[2];
                }
            }
        }
    }
?>

<h1>Login</h1>

<form action="login.php<?php if (isset($_GET['redirect']))
{ echo "?redirect=" . $_GET['redirect']; } ?>" method="post"
id="frmcontact">

    <label for="username">Username</label>
    <input type="text" name="username" id="username"
    value="<?php if (isset($username)) { echo $username; } ?>" class="textboxcontact" />

    <label for="password">Password</label>
    <input type="password" name="password" id="password" class="textboxcontact" />

    <label for="submit">&nbsp;</label>
    <input type="submit" name="submit" id="submit" value="Sign In" class="submitcontact" />

</form>

<!-- CONTENT FINISH -->

<?php
// footer.inc.php
require_once($footer_inc);

//ob_end_flush();
?>

I'm trying to setup my database class so that by default it will create all of the tables and triggers required for my application to run. I've got everything working except for it adding the trigger. Here's the relevant code (slightly obfuscated for security reasons):

    private function check_consistency()
    {

        $database_query = <<<QUERY
CREATE TABLE IF NOT EXISTS d2b_users (

    id INT NOT NULL AUTO_INCREMENT,
    obfuscated INT NOT NULL,
    obfuscated VARCHAR(50) NOT NULL,
    obfuscated VARCHAR(32) NOT NULL,
    obfuscated VARCHAR(32) NOT NULL,
    obfuscated VARCHAR(32) NOT NULL,
    obfuscated BOOL NOT NULL DEFAULT '1',
    UNIQUE KEY(id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS d2b_statistics (

    id INT NOT NULL,
    obfuscated BIGINT NOT NULL DEFAULT '0',
    UNIQUE KEY(id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

delimiter |

CREATE TRIGGER d2b_auto_statistics AFTER INSERT ON d2b_users
  FOR EACH ROW BEGIN
    INSERT INTO d2b_statistics SET id = NEW.id;
END;

|

delimiter ;

QUERY;
        
        if(!$consistency = $this->link->multi_query($database_query))
        {

            die("Failed to create/verify the default database tables.");

        }

        return true;

    }

I've also tried removing the delimiter and the colon after the INSERT line in the trigger and I still can't get it to add properly. What's annoying is that I'm able to take the code for the trigger from above and go into phpmyadmin and paste it into the SQL and it will add and work correctly. However, I'm trying to get my class to do that automatically so the php application automatically installs itself on other servers.

What am I doing wrong?

Hello,
   If anyone can help please let me know. The 2 files below are what's used to render the "Frickster's ListRave Posts" at the following URL http://www.listrave.com/member/profile.php?id=24. You can see that under Antiques it lists the same ads under both York and Altoona. The script is identifying all ads posted by User ID 24 but I don't know why it is duplicating those ads in the 2 different cities. There should actually be 2 ads for York and one for Altoona. The code is below. Again, please help

Here's the code to pull the info from the data base (called memberall_listings.php)

$conn = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die ('Error connecting to mysql');
   mysql_select_db($dbname1) or die('Could not connect: ' . mysql_error());

   $tables = mysql_list_tables($dbname1);
       
   while (list($table) = mysql_fetch_row($tables)) {
      $site["tablename"][] = $table;
      
   }

   
   if($_REQUEST["id"]!='')
      $getmemberId  = $_REQUEST["id"];
   else
      $getmemberId  = $_SESSION["memberid"];
   //$x = getTableDetailsByTableName1("");
//   echo count($site["tablename"]);
   $zz=-1;
   for($ww=0;$ww<count($site["tablename"]);$ww++) {
      
      $ValidTable = array("baltperm4w", "balt_yellowpages","boats");

      if(!in_array($site["tablename"][$ww],$ValidTable)) {

         if (count(getTableDetailsByTableName2($site["tablename"][$ww])) >0)
               $zz++;
               
         for($kk=0;$kk<count(getTableDetailsByTableName2($site["tablename"][$ww]));$kk++) {
               //   echo $site["tablename"][$zz]."<br></br>";
                  
         $getTableDetails   = getTableDetailsByTableName($site["tablename"][$ww],$kk);
         //echo $getTableDetails["city"];
         if ($kk > 0)
         if ($getTableDetails['city']==$lastcity && $getTableDetails['state']==$laststate) {

            continue;
         }
            
            
         $getAllArray[$zz][$kk]["Titlename"]      = "<a href='http://www.listrave.com'>ListRave</a> --> <a href=".$getTableDetails["stateurl"].">".$getTableDetails["state"]."</a> --> <a href=".$getTableDetails["cityurl"].">".mysql_real_escape_string($getTableDetails["city"])."</a> --> <a href=".$getTableDetails["maincaturl"].">".$getTableDetails["maincat"]."</a> --> <a href=".$getTableDetails["caturl"].">".$getTableDetails["cat"]."</a>";
         $getAllArray[$zz][$kk]["PostURL"]        = $getTableDetails["SitePostUrl"];
         $getAllArray[$zz][$kk]["AgeFormat"]        = $getTableDetails["DisplayFormat"];
         $getAllArray[$zz][$kk]["TableName"]        = $site["tablename"][$ww];
         $getAllArray[$zz][$kk]["SiteRealPath"]   = $getTableDetails["SiteRealPath"];
         
      $lastcity =  $getTableDetails["city"];
         $laststate =  $getTableDetails["state"];
         
         $GetAdlists[$zz]["MainArray"] = GetMemberAdLists($site["tablename"][$ww],$getmemberId);
         
         if($GetAdlists[$zz]["MainArray"]!=""){
            $getAllArray[$zz][$kk]["ArrayExist"]     = "Yes";
         }else{
            $getAllArray[$zz][$kk]["ArrayExist"]     = "No";
         }
         
         for($k=0;$k<count($GetAdlists[$zz]["MainArray"]);$k++) {
            $getdate               = explode(",",$GetAdlists[$zz]["MainArray"][$k]["Posted_date"]);
            $getAllArray[$zz][$kk][$k]['day']     = date("l",strtotime($getdate[0]));
            $getAllArray[$zz][$kk][$k]['month']   = date("F",strtotime($getdate[0]));
            $getAllArray[$zz][$kk][$k]['date']    = date("d",strtotime($getdate[0]));
            $getAllArray[$zz][$kk][$k]['ListArray']  = getMemberAddetails($getdate[0],$site["tablename"][$ww],$getmemberId, $getTableDetails["city"], $getTableDetails["state"]);

                for($mn=0;$mn<count($getAllArray[$zz][$kk][$k]['ListArray']);$mn++) {
               if($getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture0"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture1"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture2"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture3"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture4"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture5"]!='')
                  $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["ImageArray"]  = 'Yes';
               else
                  $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["ImageArray"]  = 'No';
           }
         }   
   
            }
          }
   }
   
      
   /* if($_SERVER['REMOTE_ADDR'] = '122.165.56.46') {
      printArray($getAllArray);
      exit;   
   }     */
   
   
   
   
   function SelectQry1($Qry) {
      $result = mysql_query($Qry) or die ("QUERY Error:".$Qry."<br>".mysql_error());
      $numrows = mysql_num_rows($result);      
      if ($numrows == 0){         
         return;
      } else {
         $row = array();
         $record = array();
         while ($row = mysql_fetch_array($result)){
         $record[] = $row;
         }      
      }      
      return $record;
   }
   
   function getTableDetailsByTableName($tablename, $kk) {
      global $global_config;
         $Qry = "select * FROM ".$tablename."";
         $getListingdetail = SelectQry1($Qry);
         return $getListingdetail[$kk];
   }
   
   
   function getTableDetailsByTableName2($tablename) {
      global $global_config;
         $Qry = "select * FROM ".$tablename."";
         $getListingdetail = SelectQry1($Qry);
         return $getListingdetail;
   }
   
       

   function GetMemberAdLists($tablename,$getmemberId) {
      global $global_config;
         $Qry = "select Posted_date FROM ".$tablename." where memberid='".$getmemberId."' group by SUBSTRING_INDEX(Posted_date,',',1) Order by Posted_date DESC";
         $getimagedetail = SelectQry1($Qry);
         return $getimagedetail;
   }
   
   function getMemberAddetails($date,$tablename,$getmemberId) {
      global $global_config;
         $Qry = "select *  from ".$tablename." WHERE `Posted_date` like '%".$date."%' AND ActivationStatus = 'Active' AND PublishedStatus='Active' AND memberid='".$getmemberId."'  group by Posted_date Order by Ident DESC";
         $getimagedetail = SelectQry1($Qry);
         return $getimagedetail;
   }

     
?>



Here's the code to display it. Remember, this is just for "Frickster's ListRave Posts"

<?php
// start session
ob_start();
session_start();
include "../includes/config.php";

//include('incsec/inccheckifadmin.php');
include ('incsec/incconn.php');
include ('incsec/incsettings.php');
include ('incfunctions.php');



   if($_REQUEST["id"]!='')
      $ActiveMemberID = $_REQUEST["id"];
   else
      $ActiveMemberID = $_SESSION["memberid"];
      

   $query="SELECT * FROM tblmembers where memberid = '".$ActiveMemberID."'";
   $result11 = mysql_query($query,$dbconnection);
   $members = mysql_fetch_array($result11);   
        $pagetitle = 'ListRave - '.$members["username"]." 's".' Profile Page';


   include("memberall_business.php");
 
        include('memberall_listings.php');

       

       
   //printArray($getAllArray);
   //exit;

 ?>


<?php include('header_member2.php') ?>
<div style="height:50px;"> </div>
<table border="0" cellpadding="2" cellspacing="0" width="80%" align="center">
   <tr>
      <td valign="top" width="30%" align="left">
         <table border="0" cellpadding="0" cellspacing="0" width="100%">
            <tr>
               <td valign="top" align="left">
                  <table width="100%">

<tr>
<td valign = "top" style="text-align: center;">
<?php
include ('incsec/incconn.php');
$dbconnection = mysql_connect($dbhost,$dbusername,$dbpassword);
mysql_select_db($database,$dbconnection);

$query="SELECT * FROM tblmembers where memberid = '".$ActiveMemberID."'";
$result = mysql_query($query,$dbconnection);
$numrecs=mysql_num_rows($result);
$myrow = mysql_fetch_array($result);
$currentmemberid = $myrow['memberid'];

$qry="SELECT * FROM tbl_listrave_ad where memberid = '".$ActiveMemberID."' and PublishedStatus='Active'";
$result1 = mysql_query($qry,$dbconnection);
$getcnt =mysql_num_rows($result1);


?>
<?php if($numrecs!=0) { ?>
<table height="100" width="90%" border="0" cellpadding="6" cellspacing="0" align="center">
   <tr>
      <td valign="top">
         <table width="100%" border="0" cellpadding="0" cellspacing="0" style="border:1px solid #0166FF;">
   <tr>
   <td align="left" class="profilefheader" width="100%" colspan="2" style="padding-left:5px; padding-top:0px; height:20px; line-height:20px;" valign="middle"><?php echo $myrow["username"];  ?>'s Profile</td>
   </tr>
   <tr>
      <td align="left" valign="top">
         <table width="100%" border="0" cellpadding="10" cellspacing="0" id="profilecontainer" align="left" style="margin-left: 10%">
            <tr>
               <td valign = "top" width="10%">
                  <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
                        <tr>
                           <td width="20%" align="left" valign="top" style="padding-right:35px">
                           <?php if($myrow["memberphoto"]!='') { ?>
                              <a target="_blank" href="imageview.php?id=<?php echo $myrow["memberid"]; ?>">
                                 <img width="180" height="180" class="Imageborder" src="<?php echo $config["sitepath"]."memberphotos/".$myrow["memberphoto"].""; ?>">
                              </a>
                              <?php } else { ?>   
                                 <img src="no-image.gif" border="0" width="180" height="180" class="Imageborder"  />          
                              <?php } ?>   
                           </td>
                        </tr>
                        <tr>
                           <td height="30">
                           </td>
                        </tr>
                        <?php /*?><tr>   
                           <td width="80%" align="center" valign="top">
                           <?php if($myrow["memberphoto"]!='') { ?>
                              <img src="upload.gif" border="0" />    
                           <?php } else { ?>      
                              <img src="change-photo.gif" border="0" />    
                           <?php } ?>   
                          </td>
                        </tr><?php */?><tr valign="bottom"><td>&nbsp;</td></tr><tr><td align="left"><img src="addcontact.gif" alt="Add This Member To Your Contacts" /></td></tr></table>
               </td>   
               <td valign = "top">
                  <table width="90%" border="0" cellpadding="6" cellspacing="0" align="left">
                        <tr>
                           <td align="left" valign="top" colspan="2">
                              <table width="90%" border="0" cellpadding="0" cellspacing="0">
                                 <tr>
                                    <td valign="top" width="15%" nowrap="nowrap">
                                       <span id="profilecontainer">Personal Information&nbsp;&nbsp;&nbsp;</span>
                                    </td>
                                    <td width="88%" valign="top">
                                       <div style="border-top: #CCCCCC  solid 1px; position:relative; top:7px;">&nbsp;</div>
                                   </td>
                                 </tr>
                              </table>
                              
                           </td>
                        </tr>
                        <?php if($myrow["firstname"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                                 <strong>First Name</strong>
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["firstname"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["othernames"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Last Name</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["othernames"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["gender"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Gender</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["gender"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["age"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Age</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["age"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                                                               
                                                                <?php if($myrow["pobox"]!='') { ?>
                                                <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Location</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["pobox"];  ?>
                           </td>
                        </tr>
                     <?php } ?>
                        
                        <?php if($myrow["relationship_status"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Relationship Status</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["relationship_status"];  ?>
                           </td>
                        </tr>   
                        <?php } ?>
                        
                                                                <?php if($myrow["registrationdate"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Member Since</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo date('M d, Y', strtotime($myrow["registrationdate"]));  ?>
                           </td>
                        </tr>
                        <?php } ?>

                        <?php if($myrow["username"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>User Name</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["username"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["about_me"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>About me</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["about_me"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["hobbies"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Hobbies</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["hobbies"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                                                                <?php if($myrow["movies"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Favorite Movies</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["movies"];  ?>
                           </td>
                        </tr>
                        <?php } ?>

                                                                <?php if($myrow["music"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Favorite Music</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["music"];  ?>
                           </td>
                        </tr>
                        <?php } ?>

                                                                <?php if($myrow["books"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Favorite Books</strong>      
                           </td>
                           <td align="left" valign="top" style="padding-right:80px">
                              <?php echo $myrow["books"];  ?>
                           </td>
                        </tr>
                        <?php } ?>

                        <tr>
                           <td height="15">
                           </td>
                        </tr>
                        <tr>
                           <td align="left" valign="top" colspan="2">
                              <table width="90%" border="0" cellpadding="0" cellspacing="0" >
                                 <tr>
                                    <td valign="top" width="15%" nowrap="nowrap" >
                                       <span id="profilecontainer">Contact Information&nbsp;&nbsp;&nbsp;</span>
                                    </td>
                                    <td width="88%" valign="top">
                                       <div style="border-top: #CCCCCC  solid 1px; position:relative; top:7px;">&nbsp;</div>
                                   </td>
                                 </tr>
                              </table>
                              
                           </td>
                        </tr>
                        <?php if($myrow["emailaddress"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                                 <strong>Email</strong>
                           </td>
                           <td align="left" valign="top">
                                    <?php echo $myrow["emailaddress"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
                        
                        <?php if($myrow["phonenumber"]!='') { ?>
                        <tr>
                           <td width="20%" align="left" valign="top">
                              <strong>Mobile Number</strong>      
                           </td>
                           <td align="left" valign="top">
                              <?php echo $myrow["phonenumber"];  ?>
                           </td>
                        </tr>
                        <?php } ?>
           &

hi guys

when a match is over, two result fields have to be edited

the first update goes well
but the second one is failing, not allways, sometimes it gives the loser xp, but not the winner (with two players)

the script should give the winner 100 xp
second 95, third 90,...

only the first two controls at the end are working
the thirth one is not, and its being used to make the first two
so it is doing its job there ...

<?php

include("./includes/egl_inc.php");
$secure = new secure();
$secure->secureGlobals();
page_protect();

global $config;

$matchidcheck = $_SESSION['matchid'];
$maks = '100';

$players=mysql_query("SELECT playerid FROM ffa_points WHERE matchid='$matchidcheck' order by killsdeaths DESC");
         while(list($playerid)=mysql_fetch_array($players))
         {
         
            $playerspoints=mysql_query("SELECT points FROM members WHERE id='$playerid'");
            while(list($points)=mysql_fetch_row($playerspoints))
            {
            $userpoints = $points;
            }
            $newpoints = $userpoints + $maks;
            mysql_query("UPDATE members SET points = $newpoints
            WHERE id='$playerid'");
            mysql_query("UPDATE ffa_points SET xppoints = $maks
            WHERE id='$playerid' and matchid='$matchidcheck'");
            if ($totalxp > 51)
            {
            $maks = $maks - 5;
            }
            
         }

                             $mes="$newpoints $points $maks All Results have been stored succesfully !! Thank You !";
               return success($mes,'./ffamatchesarchive.php');

include("$config");
?>

any help would be greatly appreciated

thanks