<?php

    $host = "";
    $user = "";
    $pass = "";

    mysql_connect($host,$user,$pass);
    mysql_select_db("admin_appdb");


    $sql = "SELECT * FROM `appdb` WHERE `name` LIKE \"%".$_POST['query']."%\" ORDER BY  `appdb`.`date_added` DESC LIMIT 0 , 30;";
    $result = mysql_query($sql);
if(mysql_num_rows($result)==0){
        echo("<li class=\"group av-sm\"><p>No Apps were found...</p></li>");
    }

    else {


        while($row = mysql_fetch_array($result)) {
                echo("<li class=\"group av-sm\">");
                echo("<a class=\"avatar\" ");
                echo("href=\"#\" ");
                echo("style=\"background-image:url(".$row['icon'].");\"");
                echo("</a>");
                echo("<a href=\"".$row['link']."\" ");
                echo("<class=\"groupLink\">".$row['name']."<br />");
                echo("<small>");
                echo("Cracked by: <font color=\"red\">".$row['cracker']."");
                echo("</small></font>");
                echo("<span class=\"s\">".$row['version']."");
                echo("<small>Version</small></span>");
                echo("</a>");
                echo("</li>");
        }



}
?>