[ Milan M. Radovic @ 20.09.2007. 21:37 ] @
Da li neko moze da mi uprosti code, inace rec je o kodu koji kasnije koristi smarty (u vidu izlaznih promenjivih) Ako ne to,onda me zanima (pored ovoga) kako da baratam sa dimenzijama nizova,tj. videcete da se u kodu prave novi nizovi sa [index][key] sto je 2D,a ja bih da stavljam u tekuci index jos jedan KEY.... ne znam da li kapirate:D Code: ##### Tabela anketa ##### $query_polls = mysql_query("SELECT DISTINCT aid,value FROM voting WHERE vid='time' ORDER BY vid DESC;"); $counter=0; while($row=mysql_fetch_array($query_polls)) { $polls[] =$row; $temp_aid =$row['aid']; $query_total_votes=mysql_query("SELECT SUM(votes) AS total_votes FROM voting WHERE aid='$temp_aid' LIMIT 1;"); #uzimanje ukupnog broja glasova while($row_total_votes=mysql_fetch_array($query_total_votes)) { $polls[$counter]['total_votes'] = $row_total_votes['total_votes']; } #uzimanje naslova $query_title=mysql_query("SELECT value FROM voting WHERE aid='$temp_aid' and vid='question' LIMIT 1;"); while($row_title=mysql_fetch_array($query_title)) { $polls[$counter]['title'] = $row_title['value']; } $counter++; } Ovo je MySQL tabela,mozda pomogne da se shvati kako je sacinjena MySQL taleba "voting" Code: CREATE TABLE `voting` ( `aid` tinytext, `vid` tinytext, `value` tinytext, `votes` bigint(10) unsigned default '0' ) ENGINE=MyISAM; # # Data for the `voting` table (LIMIT 0,500) # INSERT INTO `voting` (`aid`, `vid`, `value`, `votes`) VALUES ('fa','question','Za koga navijate',0), ('fa','option','FK Vozdovac',0), ('a','option','Renault',0), ('a','option','Fiat',0), ('a','option','Dacia',1), ('a','option','Volkswagen',12), ('fa','option','FK Rad',12), ('a','option','Audi',0), ('a','option','BMW',0), ('fa','option','FK Obilic',2), ('a','option','Zastava',25), ('fa','option','FK Zvezda',0), ('fa','option','FK Partizan',0), ('a','question','Koji automobil vozite',0), ('a','time','1156347202',0), ('a','status','1',0), ('fa','status','1',0), ('fa','time','1156347100',0); COMMIT; [Ovu poruku je menjao Milan M. Radovic dana 24.09.2007. u 12:54 GMT+1] |