select + while + for nome delle variabili modificato in ciclo for

[Barman@83]

ok solo ancora un dubbio le vecchie var $url_1 ---> $url_30

cosa ci scrivo al loro posto?

ecco il codice come ora

<?php
include("condb.php");
$query="SELECT * FROM `banner`;";
$select=mysql_query($query) or die (MYSQL_ERRNO()." ".MYSQL_ERROR());

          $query="SELECT * FROM `banner`;";
$select = mysql_query($query) or die("Query fallita");

          while($row = mysql_fetch_array($select))
                {
                for($x=0 , $y=0; $x<=5 , $y<=4 ; $x++ , $y++)
                {
                $url[$x][$y] = $row['link'];
                $image[$x][$y] = $row['percorso'];
                   }   
                
             
             if (($row['tipo']=='Flash') OR ($row['tipo']=='JSC') OR ($row['tipo']=='HTML') )
                 {
                    $BFlash=1;
                    $Url_Flash=$row['tipo'];
                }
        }

// questa funzione gestisce 6 spazi pubblicitari e ogni spazio può contenere 5 banner che rotano ogni 5 secondi per un totale di 30 Banner Programmabili
echo" 
    <script language='Javascript' type='text/javascript'>
    <!--
    
    var i=0 
    var url[][] = new Array (('".$url_1."', '".$url_2."','".$url_3."','".$url_4."','".$url_5."')('".$url_6."', '".$url_7."','".$url_8."','".$url_9."','".$url_10."')('".$url_11."', '".$url_12."','".$url_13."','".$url_14."','".$url_15."')('".$url_16."', '".$url_17."','".$url_18."','".$url_19."','".$url_20."')('".$url_21."', '".$url_22."','".$url_23."','".$url_24."','".$url_25."')('".$url_26."', '".$url_27."','".$url_28."','".$url_29."','".$url_30."'));
    
    var image[][] = new Array (('".$image_1."', '".$image_2."','".$image_3."','".$image_4."','".$image_5."')('".$image_6."', '".$image_7."','".$image_8."','".$image_9."','".$image_10."')('".$image_11."', '".$image_12."','".$image_13."','".$image_14."','".$image_15."')('".$image_16."', '".$image_17."','".$image_18."','".$image_19."','".$image_20."')('".$image_21."', '".$image_22."','".$image_23."','".$image_24."','".$image_25."')('".$image_26."', '".$image_27."','".$image_28."','".$image_29."','".$image_30."'));
    
        
    function CambiaBanner()
        {
            if (document.images) 
                {
                    
                        
                            if (i != 5 )
                                {
                                    document.getElementById('banner1').src=image[0][i];
                                    document.getElementById('link_1').href=url[0][i];    
                                    
                                    document.getElementById('banner2').src=image[1][i];
                                    document.getElementById('link_2').href=url[1][i];    
                                    
                                    document.getElementById('banner3').src=image[2][i];
                                    document.getElementById('link_3').href=url[2][i];    
                                    
                                    document.getElementById('banner4').src=image[3][i];
                                    document.getElementById('link_4').href=url[3][i];    
                                    
                                    document.getElementById('banner5').src=image[4][i];
                                    document.getElementById('link_5').href=url[4][i];    
                                    
                                    document.getElementById('banner6').src=image[5][i];
                                    document.getElementById('link_6').href=url[5][i];    
                                                                
                                    i++;
                                }
                            else { i = 0 }
                        
                    setTimeout ('CambiaBanner()' , 3000 , 'javascript')
                }
        }
    
      -->
    </script>"; // fine echo questo è tutto lo script con dentro la funzione che cambia i baanner e li fa rotare oggni 5 secondi 
?>

[Barman@83]

ok ci sono scrivo questo :


var url[][] = new Array (('".$url[0][0]."', '".$url[0][1]."','".$url[0][2]."','".$url[0][3]."','".$url[0][4]."')('".$url[1][0]."', '".$url[1][1]."','".$url[1][2]."','".$url[1][3]."','".$url[1][4]."')('".$url[2][0]."', '".$url[2][1]."','".$url[2][2]."','".$url[2][3]."','".$url[2][4]."')('".$url[3][0]."', '".$url[3][1]."','".$url[3][2]."','".$url[3][3]."','".$url[3][4]."')('".$url[4][0]."', '".$url[4][1]."','".$url[4][2]."','".$url[4][3]."','".$url[4][4]."')('".$url[5][0]."', '".$url[5][1]."','".$url[5][2]."','".$url[5][3]."','".$url[5][4]."'));

var image[][] = new Array (('".$image[0][0]."', '".$image[0][1]."','".$image[0][2]."','".$image[0][3]."','".$image[0][4]."')('".$image[1][0]."', '".$image[1][1]."','".$image[1][2]."','".$image[1][3]."','".$image[1][4]."')('".$image[2][0]."', '".$image[2][1]."','".$image[2][2]."','".$image[2][3]."','".$image[2][4]."')('".$image[3][0]."', '".$image[3][1]."','".$image[3][2]."','".$image[3][3]."','".$image[3][4]."')('".$image[4][0]."', '".$image[4][1]."','".$image[4][2]."','".$image[4][3]."','".$image[4][4]."')('".$image[5][0]."', '".$image[5][1]."','".$image[5][2]."','".$image[5][3]."','".$image[5][4]."'));

[Barman@83]

NIENTE non funziona :master: :master: :master:

non mi da nessun errore ma non riempe i campi dei 2 array Javascript


ecco il codice che ho modificato

<?php
include("condb.php");
$query="SELECT * FROM `banner`;";
$select=mysql_query($query) or die (MYSQL_ERRNO()." ".MYSQL_ERROR());

          
          while($row = mysql_fetch_array($select))
             {
                for($x=0 ; $x<=5 ;  $x++)
                {
                    for($y=0 ; $y<=4 ;  $y++)
                    {
                        $url[$x][$y] = $row['link'];
                        $image[$x][$y] = $row['percorso'];
                    }
                }   
                
             
                 if (($row['tipo']=='Flash') OR ($row['tipo']=='JSC') OR ($row['tipo']=='HTML') )
                    {
                        $BFlash=1;
                        $Url_Flash=$row['tipo'];
                    }
            }


// questa funzione gestisce 6 spazi pubblicitari e ogni spazio può contenere 5 banner che rotano ogni 5 secondi per un totale di 30 Banner Programmabili
echo" 
    <script language='Javascript' type='text/javascript'>
    <!--
    
    var i=0 
    var url= new Array (('".$url[0][0]."', '".$url[0][1]."','".$url[0][2]."','".$url[0][3]."','".$url[0][4]."')('".$url[1][0]."', '".$url[1][1]."','".$url[1][2]."','".$url[1][3]."','".$url[1][4]."')('".$url[2][0]."', '".$url[2][1]."','".$url[2][2]."','".$url[2][3]."','".$url[2][4]."')('".$url[3][0]."', '".$url[3][1]."','".$url[3][2]."','".$url[3][3]."','".$url[3][4]."')('".$url[4][0]."', '".$url[4][1]."','".$url[4][2]."','".$url[4][3]."','".$url[4][4]."')('".$url[5][0]."', '".$url[5][1]."','".$url[5][2]."','".$url[5][3]."','".$url[5][4]."'));
    
    var image= new Array (('".$image[0][0]."', '".$image[0][1]."','".$image[0][2]."','".$image[0][3]."','".$image[0][4]."')('".$image[1][0]."', '".$image[1][1]."','".$image[1][2]."','".$image[1][3]."','".$image[1][4]."')('".$image[2][0]."', '".$image[2][1]."','".$image[2][2]."','".$image[2][3]."','".$image[2][4]."')('".$image[3][0]."', '".$image[3][1]."','".$image[3][2]."','".$image[3][3]."','".$image[3][4]."')('".$image[4][0]."', '".$image[4][1]."','".$image[4][2]."','".$image[4][3]."','".$image[4][4]."')('".$image[5][0]."', '".$image[5][1]."','".$image[5][2]."','".$image[5][3]."','".$image[5][4]."'));

BUONA NOTTE

[Barman@83]

up

Qualcunno a qualche idea?

il ciclo for è giusto se chiedo di stampare a video i 2 array li stampa ma non so perche non li scriva dentro l'array in Javascript.....

[Barman@83]

OK funziona tutto






Ecco il codice funzioante

$query="SELECT * FROM `banner` order by 'ID';";
$select=mysql_query($query) or die (MYSQL_ERRNO()." ".MYSQL_ERROR());

          

          while($row = mysql_fetch_array($select))
             {
                        $h=$row['ID'];
                        $url[$h]= $row['link'];
                        $image[$h] = $row['percorso'];