function fetch_spacer() { $sql = "select versetto,end from spacer where libro='{$this->libro_id}' and capitolo={$this->capitolo} ORDER by id_spacer"; $fs = mysql_queryconerror($sql, $this->db); $i = 0; while ($rs = mysql_fetch_row($fs)) { $i++; $this->spacer[$this->lang][$this->libro_id][$this->capitolo][$rs[0]] = true; $tmp = $rs[1]; } $this->spacer[$this->lang][$this->libro_id][$this->capitolo][$tmp] = true; }
function selectfeq($dim) { $dim = floor($dim ? $dim / 2 : $this->select_dimension); /************/ /* * Per orindare con le frequenze devo prima vedere 24 item prima che frequenza ci stà quindi un * select freq < $feqn limit 24,1 */ //UNa unica non va bene perchè non sò quanti risultati ci sono in una sola... //$sql="(select word from ita_frequency where frequency = $feq and word <= '$word' order by word DESC limit 24) UNION (select word from ita_frequency where frequency = $feq and word > '$word' order by word ASC limit 24) order by word ASC"; $sql = "select word from (select word from {$this->lang_frequency} where frequency = {$this->wordfreq} and word <= '{$this->wordfound}' order by word DESC limit {$dim})as t2 order by word ASC"; $this->fsfreq = mysql_queryconerror($sql, $this->db, false); $sql = "select word from (select word from {$this->lang_frequency} where frequency = {$this->wordfreq} and word > '{$this->wordfound}' order by word ASC limit {$dim})as t2 order by word ASC"; $this->fsfreq2 = mysql_queryconerror($sql, $this->db, false); }
<?php include '../util/mysqlutil.php'; connetti(); header("Content-Type: text/css"); if (isset($_REQUEST['user'])) { $get = $_REQUEST['user']; if ($get == "Dario") { $sql = "select config from usercss where id_user=1"; $fs = mysql_queryconerror($sql, $db); $rs = mysql_fetch_row($fs); $arr = explode("\n", $rs[0]); //Faccio array riga per riga $le = sizeof($arr); $findme = "="; foreach ($arr as $riga) { $riga = explode($findme, $riga); //var_dump($riga); $text .= "{$riga['0']}{\n{$riga['1']}\n}\n"; } echo $text; } }