Questo codice mi restituisce sempre l'errore
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdoc/www/home/dinamico/admin/gestionale/admin/sel_contabilita.php on line 103
Sapete dirmi dove sbaglio?
Codice PHP:<?
include("../config.php");
$obj=new sast1com();
$temput=$_SESSION['temput'];
$temppass=$_SESSION['temppass'];
?>
<?
if($temput==$obj->user && $temppass==$obj->password){
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html dir="ltr">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="content-type">
<title> </title>
<link href="images/cpanel_002.css" type="text/css" rel="stylesheet">
<link href="images/smenustyles.css" rel="stylesheet">
<script src="js/tabs/jquery-1.1.3.1.pack.js" type="text/javascript"></script>
<script src="js/tabs/jquery.history_remote.pack.js" type="text/javascript"></script>
<script src="js/tabs/jquery.tabs.pack.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
$('#container-1').tabs();
});
</script>
<link rel="stylesheet" href="js/tabs/jquery.tabs.css" type="text/css" media="print, projection, screen">
<!--[if lte IE 7]>
<link rel="stylesheet" href="js/tabs/jquery.tabs-ie.css" type="text/css" media="projection, screen">
<![endif]-->
</head>
<body>
<?
include("includes/header.php");
include("includes/menu.php");
?>
<div id="nav2">
<h2>Gestione contabilita'</h2>
<ul>
<li class="selected">Cassa[*] [url="sel_fatture.php"]Fatture[/url] [*] [url="sel_acquisti.php"]Acquisti[/url] [/list]
</div>
<div id="nav2">
<ul>
<li class="selected">Visualizza[*] [url="sel_fatture.php"]Cerca[/url] [*] [url="sel_acquisti.php"]Inserisci[/url] [/list]
</div>
<div id="content">
<div id="container-1">
<ul>
<?
$obj->connessione();
//tira fuori gli anni e costruisce tabs
$i=1;
$result = mysql_query("select distinct SUBSTRING(data,7,10) as annoemissione from contabilita order by contabilita.nr desc");
while($array=mysql_fetch_array($result)){
echo "[*]<a href=\"#fragment-$i\"><span>$array[annoemissione]</span></a> ";
$i++;
}
?>[/list]
<?
//tira fuori gli anni e costruisce tabs
$kj=1;
$resultz = mysql_query("select distinct SUBSTRING(data,7,10) as annoemissione from contabilita order by contabilita.nr desc");
while($array2=mysql_fetch_array($resultz)){
echo "<div id=\"fragment-$kj\">";
?>
<table width=95% class="tableborder1">
<tr>
<td class="sectionHeading1">Nr.</td>
<td class="sectionHeading1">Data</td>
<td class="sectionHeading1">Tipo</td>
<td class="sectionHeading1">Desc</td>
<td class="sectionHeading1">Importo</td>
<td class="sectionHeading1">Responsabile</td>
<td class="sectionHeading1" width="20">+/-</td>
<td class="sectionHeading1" width="20">apri</td>
<td class="sectionHeading1" width="20">mod</td>
<td class="sectionHeading1" width="20">canc</td>
</tr>
<?
$i=1;
$obj->connessione();
$result = mysql_query("select data,senso,tipo,desc,importo from contabilita where SUBSTRING(data,7,10)='$array2[annoemissione]' order by contabilita.nr desc");
while($array=mysql_fetch_array($result)){
echo "<td class=\"textDisplay1\">".$array[data]."</td>";
echo "<td class=\"textDisplay1\"></td>";
echo "<td class=\"textDisplay1\"></td>";
echo "<td class=\"textDisplay1\"></td>";
echo "<td class=\"textDisplay1\"></td>";
if($array[senso]==1)echo "<td class=\"textDisplay1\"><img src=\"images/success.gif\" border=0></td>";
else echo "<td class=\"textDisplay1\"><img src=\"images/chiudi.gif\" border=0></td>";
echo"<td class=\"textDisplay1\"><a href=\"sel_fatture.php?id=$array[nr]&op=del\" onclick=\"return(confirm('Sei sicuro di voler cancellare??'))\"><img src=\"images/rimuovi.png\" border=0></a></td>";
echo "</tr>";
}
?>
</table>
<?
$kj++;
echo"</div>\n";
}
?>
</div>
</div>
<?
include("includes/footer.php");
?>
</body>
</html>
<?}else{
echo"<script language=\"javascript\">";
echo"document.location.href='errore.php'";
echo"</script>";
}?>
<?
function cliente($id){
$obj=new sast1com();
$obj->connessione();
$dati=mysql_query("select denominazione from clienti where id='$id'");
while($array=mysql_fetch_array($dati)){
return $array[denominazione];
}
}
?>
<?
if ($_GET['op']=="del"){
$obj=new sast1com();
$obj->connessione();
$id=$_GET['id'];
$dati=mysql_query("delete from fatture where id='$id'");
if($dati) echo "cancellato correttamente";
else echo "non 衳tato cancellato per motivi tecnici: ".mysql_error();
$dati=mysql_query("delete from fattureitem where idfattura='$id'");
if($dati) echo "cancellato correttamente";
else echo "non 衳tato cancellato per motivi tecnici: ".mysql_error();
echo"<script language=javascript>";
echo"document.location.href='sel_fatture.php'";
echo"</script>";
}
?>
Rispondi quotando
