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++;
}
##### 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;
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