Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Bom dia galerinha, estou tentando filtrar a seleção de dados pelo id da area especifica, porem na pagina ao inves de aparecer o que esta relacionado ao id da area, so aparece o que esta relacionado ao id 1 e ainda por cima repete ele várias vezes. abaixo segue o código para vcs avaliarem e se puderem me ajudar. desde já obrigada
<?
include ('conecta.php');
$projetos = mysql_query('SELECT * from projetos WHERE id_area=id_area');
$info = mysql_fetch_array( $projetos );
$dir = 'admin/fotos/'.$projetos['id_projetos'].'/';
$foto = @scandir($dir);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script language="javascript">AC_FL_RunContent = 0;</script>
<script src="../AC_RunActiveContent.js" language="javascript"></script>
<SCRIPT LANGUAGE="JavaScript"> var bannerAD=new Array();
var bannerADlink=new Array();
var adNum=0;
bannerAD[0]="images/banner/tepon-banner.jpg";
bannerADlink[0]="";
bannerAD[1]="images/banner/luanda-banner.jpg";
bannerADlink[1]="";
bannerAD[2]="images/banner/subestacao-banner.jpg";
bannerADlink[2]="";
bannerAD[3]="images/banner/bbraun.jpg";
bannerADlink[3]="";
bannerAD[3]="images/banner/mix-banner.jpg";
bannerADlink[3]="";
var preloadedimages=new Array();
for (i=1;i<bannerAD.length;i++){
preloadedimages[i]=new Image();
preloadedimages[i].src=bannerAD[i];
}
function setTransition(){
if (document.all){
bannerADrotator.filters.revealTrans.Transition=Math.floor(Math.random()*23);
bannerADrotator.filters.revealTrans.apply();
}
}
function playTransition(){
if (document.all)
bannerADrotator.filters.revealTrans.play()
}
function nextAd(){
if(adNum<bannerAD.length-1)adNum++ ;
else adNum=0;
setTransition();
document.images.bannerADrotator.src=bannerAD[adNum];
playTransition();
theTimer=setTimeout("nextAd()", 5000);
}
function jump2url(){
jumpUrl=bannerADlink[adNum];
jumpTarget='';
if (jumpUrl != ''){
if (jumpTarget != '')window.open(jumpUrl,jumpTarget);
else location.href=jumpUrl;
}
}
function displayStatusMsg() {
status=bannerADlink[adNum];
document.returnValue = true;
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function MM_showHideLayers() { //v9.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3)
with (document) if (getElementById && ((obj=getElementById(args[i]))!=null)) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v; }
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}</script>
<title>.: Excenge - excelência em engenharia :.</title>
<link href="[http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700|Archivo+Narrow:400,700](http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700%7CArchivo+Narrow:400,700)" rel="stylesheet" type="text/css">
<link href="default.css" rel="stylesheet" type="text/css" media="all" />
<link href="estilo_interno.css" rel="stylesheet" type="text/css">
<style type="text/css"> margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}td.class1 {
background-repeat:repeat-x;
}</style></head>
<script type="text/javascript">function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}</script>
<body onLoad="MM_preloadImages('banner/botoes2/bt1_1_hover.png','banner/botoes2/bt1_3_hover.png','banner/botoes2/bt1_hover.png','banner/botoes2/bt1_2_hover.png','banner/botoes2/bt4_hover.png','banner/botoes2/bt2_hover.png','banner/botoes2/bt3_hover.png')">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" background="images/bg01.png" class="class1"> </td>
</tr>
<tr>
<td align="center"><? include "menu.php" ?></td>
</tr>
<tr>
<td height="655" align="center" valign="top"><table width="1200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="18" align="center"> </td>
</tr>
<tr>
<td height="400" align="center"><div id="box_banner">
<div id="box_banner_image">
<div id="apDiv20" class="classe"><img src="images/banner/pet-gas.jpg" width="800" height="400"/></div>
<div id="apDiv2" class="classe"><img src="banner/2.png" width="800" height="400"/></div>
<div id="apDiv3" class="classe"><img src="images/banner/ind-banner.jpg" width="800" height="400"/></div>
<div id="apDiv4" class="classe"><img src="banner/3.png" width="800" height="400"/></div>
<div id="apDiv5" class="classe"><img src="banner/4.png" width="800" height="400"/></div>
<div id="apDiv6" class="classe"><img src="images/banner/sub-banner.jpg" width="800" height="400"/></div>
<div id="apDiv7" class="classe"><img src="banner/7.png" width="800" height="400"/></div>
<div id="apDiv8" class="classe"><img src="images/banner/emp-comercial.jpg" width="800" height="400"/></div>
<div id="apDiv9" class="classe"><img src="images/banner/emp-residencial.jpg" width="800" height="400"/></div>
<div id="apDiv15" class="classe"><img src="images/banner/pet-gas.jpg" width="800" height="400"/></div>
</div>
<div id="box_banner_botoes"><a href="projeto-area.php?id_area=1"><img src="images/banner/bt-pj1.png" width="65" height="400" border="0" id="Image7" onMouseOver="MM_showHideLayers('apDiv20','','show');MM_swapImage('Image7','','images/banner/bt-pj1-over.png',1)" onMouseOut="MM_showHideLayers('apDiv20','','hide');MM_swapImgRestore()" /></a></div>
<div id="box_banner_botoes"><a href="projeto-area.php?id_area=2"><img src="images/banner/bt-pj2.png" width="65" height="400" border="0" id="Image2" onMouseOver="MM_swapImage('Image2','','images/banner/bt-pj2-over.png',1);MM_showHideLayers('apDiv3','','show')" onMouseOut="MM_swapImgRestore();MM_showHideLayers('apDiv3','','hide')" /></a></div>
<div id="box_banner_botoes"><a href="#"><img src="images/banner/bt-pj3.png" width="65" height="400" border="0" id="Image1" onMouseOver="MM_swapImage('Image1','','images/banner/bt-pj3-over.png',1);MM_showHideLayers('apDiv2','','show')" onMouseOut="MM_swapImgRestore();MM_showHideLayers('apDiv2','','hide')" /></a></div>
<div id="box_banner_botoes"><a href="#"><img src="images/banner/bt-pj6.png" width="65" height="400" border="0" id="Image3" onMouseOver="MM_swapImage('Image3','','images/banner/bt-pj6-over.png',1);MM_showHideLayers('apDiv6','','show')" onMouseOut="MM_swapImgRestore();MM_showHideLayers('apDiv6','','hide')" /></a></div>
<div id="box_banner_botoes"><a href="#"><img src="images/banner/bt-pj4.png" width="65" height="400" border="0" id="Image9" onMouseOver="MM_swapImage('Image9','','images/banner/bt-pj4-over.png',1);MM_showHideLayers('apDiv8','','show')" onMouseOut="MM_swapImgRestore();MM_showHideLayers('apDiv8','','hide')" /></a></div>
<div id="box_banner_botoes"><a href="#"><img src="images/banner/bt-pj5.png" width="65" height="400" border="0" id="Image10" onMouseOver="MM_swapImage('Image10','','images/banner/bt-pj5-over.png',1);MM_showHideLayers('apDiv9','','show')" onMouseOut="MM_swapImgRestore();MM_showHideLayers('apDiv9','','hide')" /></a></div>
</div></td>
</tr>
<tr>
<td height="16" align="center"> </td>
</tr>
<tr>
<td height="20" align="center" background="images/bg01.png" class="class1"> </td>
</tr>
<tr>
<td height="35" align="left" ><img src="images/certo.jpg" alt="" width="32" height="27" /> <span class="txt-tit-pag">PROJETOS</span></td>
</tr>
<tr>
<td height="16" align="center"> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td height="16" align="center"> </td>
</tr>
<?
if(!empty($info))
{
for($i=0;$i<count($info);$i++)
{
//print_r($projetos);
$foto = @scandir('admin/fotos_projetos/'.$info[$i]['id_projetos'].'/');
?>
<tr>
<td align="left">
<table width="867" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="218" ><table width="147" border="0" cellspacing="4" cellpadding="0">
<tr>
<td width="139" valign="top">
<?
if(empty($foto[2]))
{
?>
<img src="admin/images/sem_foto.png" width="210" height="137" border="0" />
<?
}
else
{
?>
<a href=""><img src="admin/fotos_projetos/<?=$info['id_projetos'].'/'.$foto[2];?>" width="210" height="137" border="0" /> </a><br /><?
}
?>
</td>
</tr>
</table></td>
<td width="6"> </td>
<td width="643" align="left" valign="top">
<table width="645" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="75"><span class="txt-client">Projeto</span>:</td>
<td width="570" class="fontTXT-home"><span class="style6">
<?=$info['projeto']?>
</span></td>
</tr>
<tr>
<td colspan="2"><img src="images/spacer.png" width="5" height="10"></td>
</tr>
<tr>
<td class="txt-client">Ano:</td>
<td class="fontTXT-home"><span class="style6">
<?=$info['ano']?>
</span></td>
</tr>
<tr>
<td colspan="2"><img src="images/spacer.png" width="5" height="10"></td>
</tr>
<tr>
<td class="txt-client">Cliente:</td>
<td class="fontTXT-home"><span class="style6">
<?=$info['cliente']?>
</span></td>
</tr>
<tr>
<td colspan="2"><img src="images/spacer.png" width="5" height="10"></td>
</tr>
<tr>
<td colspan="2" align="justify" class="fontTXT-home">
<?=$info['descricao']?>
</td>
</tr>
<tr>
<td colspan="2" align="justify" class="fontTXT-home"> </td>
</tr>
<tr>
<td colspan="2" align="justify" class="fontTXT-home">
</td>
</tr>
</table>
<p> </p>
<div align="justify"></div></td>
</tr>
<tr>
<td colspan="3" ></td>
</tr>
<tr>
<td height="5" colspan="3" ></td>
</tr>
</table>
<p> </p></td>
</tr>
<tr>
<td background="images/line_hor.gif">
</td>
</tr>
<?
}
}
else
{
?>
<tr>
<td><table width="720" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><span class="style6"><span class="style13">Não há Projetos cadastrados</span></span></div></td>
</tr>
</table></td>
</tr>
<tr>
<td background="images/line_hor.gif"> </td>
<?
}
?>
<tr>
<td> </td>
</tr>
<tr>
<td height="16" align="center"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="178" align="center" valign="top" background="images/bg01.png"><table width="1150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td width="835" align="left" valign="top"><table width="797" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="169" height="30" align="center"><a href="quem-somos.asp" accesskey="1" title="" class="menuR">QUEM SOMOS</a></td>
<td width="5" align="center"> </td>
<td width="169" height="30" align="center"><a href="atuacao.asp" accesskey="2" title="" class="menuR">ÁREAS DE ATUAÇÃO</a></td>
<td width="5" align="center"> </td>
<td width="216" height="30"><a href="projetos.asp" accesskey="3" title="" class="menuR"> PROJETOS</a></td>
<td width="10" align="center"> </td>
<td width="111" height="30" align="left"><a href="clientes.asp" accesskey="4" title="" class="menuR"> CLIENTES</a></td>
<td width="9" align="center"> </td>
<td width="108" height="30" align="left"><a href="sigede.asp" target="_blank" accesskey="5" title="" class="menuR"> SIGEDE</a></td>
</tr>
<tr>
<td height="20" align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center" valign="top"><table width="185" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="15"> </td>
<td width="170" align="left" valign="top" class="menuSUB">Petróleo e Gás<br />
Instalações Industriais<br />
Infraestrutura<br />
Empreend. Comerciais<br />
Empreend. Residenciais</td>
</tr>
</table></td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
</table></td>
<td width="315" align="left" valign="top"><table width="315" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="315" height="30"><a href="fale.asp" class="menuSUB">FALE CONOSCO</a></td>
</tr>
<tr>
<td height="51" class="menuSUB"></td>
</tr>
<tr>
<td height="49"><span class="menuSUB"></span></td>
</tr>
<tr>
<td height="48"><span class="mail-01"><a href="#" class="menuSUB"></a></span></td>
</tr>
</table></td>
</tr>
<tr>
<td height="16" colspan="2"> </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
.Carregando comentários...