CREATE TABLE `parama` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dt` datetime NOT NULL,
`tonr` varchar(45) NOT NULL,
`txt` varchar(255) NOT NULL,
`phone` varchar(45) NOT NULL,
`operator` varchar(15) NOT NULL,
`amount` float(5,2) unsigned NOT NULL,
`word` varchar(45) NOT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `tonr` (`tonr`),
KEY `phone` (`phone`),
KEY `word` (`word`),
KEY `amount` (`amount`),
KEY `uid` (`uid`),
KEY `dt` (`dt`)
) ENGINE=MyISAM;

<?php
function get_parama($conn, $cnt=1, $word="", $amount=0, $phone="", $operator="", $uid=0)
{
$sql="";

if(!empty($word))
$sql="word='".$word."'";

if($amount>0)
$sql=$sql.(!empty($sql) ? " AND " : "")."amount=".sprintf("%01.2f",$amount);

if(!empty($phone))
$sql=$sql.(!empty($sql) ? " AND " : "")."phone='".$phone."'";

if(!empty($operator))
$sql=$sql.(!empty($sql) ? " AND " : "")."operator='".$operator."'";

if($uid>0)
$sql=$sql.(!empty($sql) ? " AND " : "")."uid=".$uid;

if($cnt<1)
$cnt=1; //Jei nenurodyta ar nurodyta 0, tai gauti 1 paskutine zinute
else
if($cnt>100)
$cnt=100;//Jei daugiau nei 100, tai rodyti tik 100 zinuciu

$sql="SELECT * FROM parama ".(!empty($sql) ? "WHERE ".$sql : "")." ORDER BY dt DESC LIMIT ".$cnt;
$result=mysql_query($sql,$conn) or die(mysql_error());
if(!mysql_num_rows($result))
return array(); //Neradus rezultatu, grazinti tuscia masyva

// Sukeliam rezultatus i masyva
$arr=array();
$kount=0;
while($arr[$kount] = mysql_fetch_assoc($result))
$kount++;

return $arr;
}
?>