29. december 2003 - 21:29
Der er
6 kommentarer og 1 løsning
Bannerrotation, hvad er galt ?
Hey, Jeg har prøvet at lave en bannerrotation til min hjemmeside, men jeg kan ikke få det til at virke. Er der nogen, som kan se hvad der er galt med dette? <?php $foresp = mysql_query("SELECT id, pic1, pic1spg, pic1url, pic2, pic2spg, pic2url, pic3, pic3spg, pic3url, pic4, pic4spg, pic4url, pic5, pic5spg, pic5url FROM banner WHERE id = '1' ORDER BY id DESC LIMIT 0, 1"); while($data = mysql_fetch_array($foresp)){ $tid1 = (double)microtime(); srand((double)microtime()*1000000); if(($pic1spg == "1") && ($pic2spg == "0") && ($pic3spg == "0") && ($pic4spg == "0") && ($pic5spg == "0")) { $tal = "1"; } if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "0") && ($pic4spg == "0") && ($pic5spg == "0")) { $tal = rand(0,1); } if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "0") && ($pic5spg == "0")) { $tal = rand(0,2); } if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "1") && ($pic5spg == "0")) { $tal = rand(0,3); } if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "1") && ($pic5spg == "1")) { $tal = rand(0,4); } switch($tal){ case (0): $pic = "$data[pic1]"; $url = "$data[pic1url]"; break; case (1): $pic = "$data[pic2]"; $url = "$data[pic2url]"; break; case (2): $pic = "$data[pic3]"; $url = "$data[pic3url]"; break; case (3): $pic = "$data[pic4]"; $url = "$data[pic4url]"; break; case (4): $pic = "$data[pic5]"; $url = "$data[pic5url]"; break; } } ?> Den udskriver hele tiden den første mulighed - altså $tal = 0
Annonceindlæg tema
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
29. december 2003 - 21:42
#1
Prøv: while($data = mysql_fetch_array($foresp)){ extract $data; $tid1 = (double)microtime(); srand((double)microtime()*1000000);
29. december 2003 - 21:49
#2
Det giver samme resultat.. er det ikke også bare 2 forskellige måder at hive data ud af en database på ?
29. december 2003 - 22:00
#3
extract $data; skulle være: extract($data);
29. december 2003 - 22:06
#4
Prøv: <?php $foresp = mysql_query("SELECT id, pic1, pic1spg, pic1url, pic2, pic2spg, pic2url, pic3, pic3spg, pic3url, pic4, pic4spg, pic4url, pic5, pic5spg, pic5url FROM banner WHERE id = '1' ORDER BY id DESC LIMIT 0, 1"); while($data = mysql_fetch_array($foresp)){ extract($data); srand((double)microtime()*1000000); if(($pic1spg == "1") && ($pic2spg == "0") && ($pic3spg == "0") && ($pic4spg == "0") && ($pic5spg == "0")) $tal = 1; if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "0") && ($pic4spg == "0") && ($pic5spg == "0")) $tal = rand(0,1); if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "0") && ($pic5spg == "0")) $tal = rand(0,2); if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "1") && ($pic5spg == "0")) $tal = rand(0,3); if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "1") && ($pic5spg == "1")) $tal = rand(0,4); switch($tal){ case (0): $pic = $pic1; $url = $pic1url; break; case (1): $pic = $pic2; $url = $pic2url; break; case (2): $pic = $pic3; $url = $pic3url; break; case (3): $pic = $pic4; $url = $pic4url; break; case (4): $pic = $pic5; $url = $pic5url; break; } } ?>
29. december 2003 - 22:10
#5
prøver...
29. december 2003 - 22:12
#6
nice... det virkede! Tusind tak. Kan du ikke lige lave et svar ?
29. december 2003 - 22:14
#7
Lidt kortere: <?php $foresp = mysql_query("SELECT id, pic1, pic1spg, pic1url, pic2, pic2spg, pic2url, pic3, pic3spg, pic3url, pic4, pic4spg, pic4url, pic5, pic5spg, pic5url FROM banner WHERE id = '1' ORDER BY id DESC LIMIT 0, 1"); while($data = mysql_fetch_array($foresp)){ extract($data); srand((double)microtime()*1000000); if(($pic1spg == "1") && ($pic2spg == "0") && ($pic3spg == "0") && ($pic4spg == "0") && ($pic5spg == "0")) $tal = 1; if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "0") && ($pic4spg == "0") && ($pic5spg == "0")) $tal = rand(0,1); if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "0") && ($pic5spg == "0")) $tal = rand(0,2); if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "1") && ($pic5spg == "0")) $tal = rand(0,3); if(($pic1spg == "1") && ($pic2spg == "1") && ($pic3spg == "1") && ($pic4spg == "1") && ($pic5spg == "1")) $tal = rand(0,4); $pic = ${'pic'.($tal+1)}; $url = ${'pic'.($tal+1).'url'}; } ?>
Vi tilbyder markedets bedste kurser inden for webudvikling