[es] - Treba mi pomoc oko PHP koda...

Milan M. Radovic
Web Developer
Pančevo

Član broj: 16959
Poruke: 743
*.bisinter.net.

+25 Profil

^{20.09.2007. u 21:37 - pre 202 meseci}

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]}

I don't need a girl for sex , All I Need is Binary and HEX

Odgovor na temu