|
';
if (intval($nlim) ==0) $nlim=20;
$sdb=sqlite_open("config.php") or die(sql_error_string());
$r=@sqlite_query($sdb,"Select * from config where ikey = 'db' ");
$re=sqlite_fetch_array($r);
$db_name=$re['ivalue'];
$table_name="shoptable";
$db=sqlite_open($db_name);
$sql="select * from $table_name ORDER BY Random() LIMIT $nlim" ;
if ($typez==2) $sql="select * from $table_name ORDER BY clicks DESC LIMIT $nlim" ;
$result=sqlite_array_query($db,$sql);
//$result=@sqlite_query($db,$sql);
$j=0;
foreach ($result as $row) {
//while ($row=sqlite_fetch_array($result)) {
$titles=$row['titles'];
$links=$row['links'];
$id=$row['id'];
if ($typez==0 || $typez==2) {
echo ' | '.($j % 2==0 ? '' : ' | |
| ' ) ;
$j++;
}
}
/* Good but Low
$row= sqlite_fetch_all($result);
shuffle($row);
foreach ( $row as $r22) {
$titles=$r22['titles'];
$links=$r22['links'];
$id=$r22['id'];
echo ''.$titles.' '; } */ ?> |