Smiley list by difrent category,how?

[manavworld]

Plz tell me hw i can make smiley list by category, adult,emotions,own smileys etc category

[i0nutzxp]

add in _smilies a new line : tipe int(1) ... //

$lcateg = 8; //last categ
$categ = (int)$_GET["cat"];
 if($categ<1||$categ>$lcateg)$categ = 0; else $categ = $_GET["cat"];

//replace count
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_smilies WHERE tipe='". $categ."'"));
//and replace $sql
$sql = "SELECT id, scode, imgsrc FROM ibwf_smilies WHERE tipe='".$categ."' ORDER BY id DESC LIMIT $limit_start, $items_per_page";

/// and add in links &amp;cat=$categ
//make an action whit links to categ
<a href=\"lists.php?action=smilies&amp;cat=0&amp;sid=$sid\">Diverse Emotions</a><br/>
// 

// user 0 for diverse tipe of emotions:D

[manavworld]

Thhhhhaaaanxxxx brotherrrrr

[Kirsty]

please help

add in _smilies a new line : tipe int(1) ... //

$lcateg = 8; //last categ
$categ = (int)$_GET["cat"];
 if($categ<1||$categ>$lcateg)$categ = 0; else $categ = $_GET["cat"];

//replace count
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_smilies WHERE tipe='". $categ."'"));
//and replace $sql
$sql = "SELECT id, scode, imgsrc FROM ibwf_smilies WHERE tipe='".$categ."' ORDER BY id DESC LIMIT $limit_start, $items_per_page";

/// and add in links &amp;cat=$categ
//make an action whit links to categ
<a href=\"lists.php?action=smilies&amp;cat=0&amp;sid=$sid\">Diverse Emotions</a><br/>
// 

// user 0 for diverse tipe of emotions:D

i have put new line in smilies database with categ int 1, where do i put the above code?

[WhiteWarrior]

its already telling you lol

$lcateg = 8; //last categ
$categ = (int)$_GET["cat"];
if($categ<1||$categ>$lcateg)$categ = 0; else $categ = $_GET["cat"];
//////////////////////////////////////////////////////////////////////////////////
//replace count
//////////////////////////////////////////////////////////////////////////////////
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_smilies WHERE tipe='". $categ."'"));


//////////////////////////////////////////////////////////////////////////////////
//and replace $sql
//////////////////////////////////////////////////////////////////////////////////
$sql = "SELECT id, scode, imgsrc FROM ibwf_smilies WHERE tipe='".$categ."' ORDER BY id DESC LIMIT $limit_start, $items_per_page";



//////////////////////////////////////////////////////////////////////////////////
/// and add in links &amp;cat=$categ
//////////////////////////////////////////////////////////////////////////////////
//make an action whit links to categ
//////////////////////////////////////////////////////////////////////////////////
<a href="lists.php?action=smilies&amp;cat=0&amp;sid=$ sid\">Diverse Emotions</a><br/>
//



;)

[WhiteWarrior]

its already telling you lol

$lcateg = 8; //last categ
$categ = (int)$_GET["cat"];
if($categ<1||$categ>$lcateg)$categ = 0; else $categ = $_GET["cat"];
//////////////////////////////////////////////////////////////////////////////////
//replace count
//////////////////////////////////////////////////////////////////////////////////
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_smilies WHERE tipe='". $categ."'"));


//////////////////////////////////////////////////////////////////////////////////
//and replace $sql
//////////////////////////////////////////////////////////////////////////////////
$sql = "SELECT id, scode, imgsrc FROM ibwf_smilies WHERE tipe='".$categ."' ORDER BY id DESC LIMIT $limit_start, $items_per_page";



//////////////////////////////////////////////////////////////////////////////////
/// and add in links &amp;cat=$categ
//////////////////////////////////////////////////////////////////////////////////
//make an action whit links to categ
//////////////////////////////////////////////////////////////////////////////////
<a href="lists.php?action=smilies&amp;cat=0&amp;sid=$ sid\">Diverse Emotions</a><br/>
//



;)

[animal1982]

lists.php, ownercp.php and ownrproc.....search its there lol