// JavaScript Document


$(document).ready(function() {


	$.ajax({//ajax
			type: "POST",
        	url: "./fmysql.php",
        	data: "consulta=banners",
        	success: function(bn){
									
									bn=bn.split("|@|");
									
									var cosbn="<table width='100%'>";
									for(var i=0; i<bn.length-1; i++){
																	bntmp=bn[i].split("@@@");
																	if(bntmp[5]!=0)
																	{
																		if(bntmp[3]=="Barcelona") var colorbaner="id='bannerbarna'";
																		else var colorbaner="id='bannersabadell'";
																	
										                            	cosbn+="<tr class='bannerformat'>";
																		cosbn+="<td><span id='codi' style='display:none;'>"+bntmp[6]+"</span><table class='bannerprom' width='100%' "+colorbaner+">";
																		cosbn+="<tr><td width='80%' "+colorbaner+">";
																		cosbn+=bntmp[0];                           //Títol
																		cosbn+="</td><td style='font-size:85%; background-color:#ffff00; color:#000000;' align='center'>";
																		cosbn+="Inicio:<br/>"+bntmp[1];           //Data inici
																		cosbn+="</td></tr>";
																		cosbn+="<tr><td "+colorbaner+"><p>"+bntmp[2]+"</p></td>";  //Titulació
																		cosbn+="<td "+colorbaner+"><p>"+bntmp[3]+"</p></td></tr>";  //Lloc
			                                                        	cosbn+="</table></td>";
																		cosbn+="</tr>";
																	}
									}//for
									
									cosbn+="</table>";
									$("#banners").html(cosbn);
									
									
																	
																		
			}//success
	});//ajax


	
	
});//fi jquery