maniu91
18-12-2012, 06:45
Witam!
Jak wyświetlić rekordy alfabetycznie A-Z w funkcji poniżej?
function getAllSignedArtist($keyword='',$limitStart=0,$limi t=10)
{
$db =& JFactory::getDBO();
$query = "SELECT SQL_CALC_FOUND_ROWS DISTINCT s.userid,u.id,u.name,u.username,u.registerDate,u.u sertype FROM #__session AS s,#__users AS u,#__profile AS p WHERE s.client_id = 0 AND s.guest = 0 AND s.usertype='Artist' AND u.id = s.userid AND u.block=0 AND u.id=p.user_id AND (p.genre1 LIKE '%$keyword%'OR p.genre2 LIKE '%$keyword%')";
$db->setQuery($query,$limitStart,$limit);
return $db->loadObjectList();
} // EO: getAllSignedArtist function
Jak wyświetlić rekordy alfabetycznie A-Z w funkcji poniżej?
function getAllSignedArtist($keyword='',$limitStart=0,$limi t=10)
{
$db =& JFactory::getDBO();
$query = "SELECT SQL_CALC_FOUND_ROWS DISTINCT s.userid,u.id,u.name,u.username,u.registerDate,u.u sertype FROM #__session AS s,#__users AS u,#__profile AS p WHERE s.client_id = 0 AND s.guest = 0 AND s.usertype='Artist' AND u.id = s.userid AND u.block=0 AND u.id=p.user_id AND (p.genre1 LIKE '%$keyword%'OR p.genre2 LIKE '%$keyword%')";
$db->setQuery($query,$limitStart,$limit);
return $db->loadObjectList();
} // EO: getAllSignedArtist function