Changeset 249 for trunk/team.php


Ignore:
Timestamp:
Jul 15, 2009, 2:56:47 PM (15 years ago)
Author:
maron
Message:

oprava vyhledávání v týmech

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/team.php

    r248 r249  
    2020  echo('<table class="BaseTable">');
    2121
    22   if(array_key_exists('search', $_GET))  $_SESSION['Where'] = ' WHERE `name` LIKE "%'.$_GET['search'].'%" OR `description` LIKE "%'.$_GET['search'].'%"';
     22  if(array_key_exists('search', $_GET))  $_SESSION['search'] = ' WHERE `name` LIKE "%'.$_GET['search'].'%" OR `description` LIKE "%'.$_GET['search'].'%"';
    2323   
    2424    /*
     
    5151    echo('</tr>');
    5252
    53     $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM user WHERE user.team = team.ID) AS numberuser FROM team ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);
     53    $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM user WHERE user.team = team.ID) AS numberuser FROM team '.$_SESSION['search'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);
    5454    while($Line = mysql_fetch_assoc($ID))
    5555    {
Note: See TracChangeset for help on using the changeset viewer.