ErroreWarning: mysql_fetch_array(): supplied argument is not a valid MySQL

**kamibest** · 11-09-2007, 13:06

Ecco gli errori che mi escono quando faccio partire la pagina :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.mysite.com/htdocs/manager/edit.php on line 101

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.mysite.com/htdocs/manager/edit.php on line 109

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.mysite.com/htdocs/manager/edit.php on line 113

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.mysite.com/htdocs/manager/edit.php on line 114

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.mysite.com/htdocs/manager/edit.php on line 115

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.mysite.com/htdocs/manager/edit.php on line 116

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.circuitolinks.com/htdocs/manager/edit.php on line 117

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.circuitolinks.com/htdocs/manager/edit.php on line 118

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.circuitolinks.com/htdocs/manager/edit.php on line 119

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.circuitolinks.com/htdocs/manager/edit.php on line 120

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.circuitolinks.com/htdocs/manager/edit.php on line 121

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.circuitolinks.com/htdocs/manager/edit.php on line 122

Ecco il codice :

<?
require('error_inc.php');
require('config_inc.php');

$id=intval($id);

if($REQUEST_METHOD=="POST"){
if(isset($edit)){
if($name==""){
die($err[3]);
}
$name=htmlspecialchars($name);
$query = "select * from ".$t_main." where name=\"".$name."\" and id!=".$id;
$result = MYSQL_QUERY($query);
if(mysql_num_rows($result)!=0){
die($err[9]);
}
@mysql_free_result($result);
if($title==""){
die($err[3]);
}
$title=htmlspecialchars($title);
if($email==""){
die($err[3]);
}
$email=htmlspecialchars($email);
if($unsafe_credits==""){
die($err[3]);
}
$unsafe_credits=intval($unsafe_credits);
if($total_credits==""){
die($err[3]);
}
$total_credits=intval($total_credits);
if($url==""){
die($err[3]);
}
if($pass==""){
die($err[3]);
}
$pass=htmlspecialchars($pass);

if($sel[1]==""){
$er[]=$err[6];
$flag=false;
}
if($sel[2]==""){
$er[]=$err[6];
$flag=false;
}
if($sel[3]==""){
$er[]=$err[6];
$flag=false;
}
if($sel1[1]==""){
$er[]=$err[6];
$flag=false;
}
if($sel1[2]==""){
$er[]=$err[6];
$flag=false;
}
if($sel1[3]==""){
$er[]=$err[6];
$flag=false;
}

$links=trim(htmlspecialchars($links));
$query="update ".$t_main." set title=\"".$title."\",fio=\"".$fio."\", country=\"".$country."\", url=\"".$url."\" , email=\"".$email."\" ,name=\"".$name."\" , unsafe_credits=".$unsafe_credits.", total_credits=".$total_credits." , pass=\"".$pass."\" , links=\"".$links."\" where id=".$id;
if(!@mysql_query($query)){
die($err[6]);
}

$query="delete from ".$t_idm_id." where idm=".$id;
if(!@mysql_query($query)){
print $err[6];
}
$query="delete from ".$t_w_idm_id." where idm=".$id;
if(!@mysql_query($query)){
print $err[6];
}
for($i=1;$i<=3;$i++){
$query="insert into ".$t_idm_id." set idm=".$id.", id=".intval($sel[$i]);
if(!@mysql_query($query)){
print($err[6]);
}
}
for($i=1;$i<=3;$i++){
$query="insert into ".$t_w_idm_id." set idm=".$id.", id=".intval($sel1[$i]);
if(!@mysql_query($query)){
print($err[6]);
}
}
header("location:".$ref);
}
}

$query = "select id from ".$t_main.", ".$t_w_idm_id." where ".$t_main.".id=".$id." and idm=".$id." order by id";
$result = MYSQL_QUERY($query);
$i=1;
while($row = mysql_fetch_array($result)){
$cat1[$i]=$row["id"];
$i++;
}
@mysql_free_result($result);
$query = "select * from ".$t_main.", ".$t_idm_id." where ".$t_main.".id=".$id." and idm=".$id." order by id";
$result = MYSQL_QUERY($query);
$i=1;
while($row = mysql_fetch_array($result)){
$cat[$i]=$row["id"];
$i++;
}
$name=mysql_result($result,0,"name");
$fio=mysql_result($result,0,"fio");
$country=mysql_result($result,0,"country");
$email=mysql_result($result,0,"email");
$url=mysql_result($result,0,"url");
$title=mysql_result($result,0,"title");
$pass=mysql_result($result,0,"pass");
$total_credits=mysql_result($result,0,"total_credi ts");
$unsafe_credits=mysql_result($result,0,"unsafe_cre dits");
$links=mysql_result($result,0,"links");
@mysql_free_result($result);
require('header_adm.php');
?>
<script language="JavaScript">

</script>
<form name="form1" method="post" action="">
<input type="hidden" name="ref" value="<?print $HTTP_REFERER;?>">
<table width="550" border=1 cellspacing=0 cellpadding=5 bordercolor="#FFFFFF">
<tr>
<td width="40%" align="right" class="text">User Name:</td>
<td align="left" class="text">
<input type="text" name="fio" size="40" value="<?print $fio;?>">
</td>
</tr>
<tr>
<td width="40%" align="right" class="text">Your E-mail:</td>
<td align="left" class="text">
<input type="text" name="email" size="40" value="<?print $email;?>">
</td>
</tr>
<tr>
<td width="40%" align="right" class="text">Web Site URL:</td>
<td align="left" class="text">
<input type="text" name="url" size="40" value="<?print $url;?>">
</td>
</tr>
<tr>
<td width="40%" align="right" class="text">Link Title:</td>
<td align="left" class="text">
<input type="text" name="title" size="40" value="<?print $title;?>">
</td>
</tr>
<tr>
<td width="200" align="right" class="text">Your Country:</td>
<td align="left" class="text" width="450">
<input type="text" name="country" size="40" value="<?print $country;?>">
</td>
</tr>
<tr>
<td width="200" align="right" class="text" valign="top">Your website Category:</td>
<td align="left" class="text" width="450">
<?
$query = "select * from ".$t_cat." order by id";
$result = MYSQL_QUERY($query);
$i=0;
while($row = mysql_fetch_array($result)){
$ch["id"][$i]=$row["id"];
$ch["title"][$i]=$row["title"];
$i++;
}?>
<select name="sel[1]">
<?
$siz=$i;
for($i=0;$i<$siz;$i++){
?>
<option value="<?
print $ch["id"][$i];
?>
" <?if($ch["id"][$i]==$cat[1]){print "selected";}?>>
<?
print $ch["title"][$i];
?>
</option>
<?
}
?>
</select>
<select name="sel[2]">
<?
for($i=0;$i<$siz;$i++){
?>
<option value="<?
print $ch["id"][$i];
?>
" <?if($ch["id"][$i]==$cat[2]){print "selected";}?>>
<?
print $ch["title"][$i];
?>
</option>
<?
}
?>
</select>
<select name="sel[3]">
<?
for($i=0;$i<$siz;$i++){
?>
<option value="<?
print $ch["id"][$i];
?>
" <?if($ch["id"][$i]==$cat[3]){print "selected";}?>>
<?
print $ch["title"][$i];
?>
</option>
<?
}
?>
</select>
</td>
</tr>
<tr>
<td width="200" align="right" class="text" valign="top">Target Category: where do you want your link to be displayed:</td>
<td align="left" class="text" width="450">
<select name="sel1[1]">
<?
for($i=0;$i<$siz;$i++){
?>
<option value="<?
print $ch["id"][$i];
?>
" <?if($ch["id"][$i]==$cat1[1]){print "selected";}?>>
<?
print $ch["title"][$i];
?>
</option>
<?
}
?>
</select>
<select name="sel1[2]">
<?
for($i=0;$i<$siz;$i++){
?>
<option value="<?
print $ch["id"][$i];
?>
" <?if($ch["id"][$i]==$cat1[2]){print "selected";}?>>
<?
print $ch["title"][$i];
?>
</option>
<?
}
?>
</select>
<select name="sel1[3]">
<?
for($i=0;$i<$siz;$i++){
?>
<option value="<?
print $ch["id"][$i];
?>
" <?if($ch["id"][$i]==$cat1[3]){print "selected";}?>>
<?
print $ch["title"][$i];
?>
</option>
<?
}
?>
</select>

<?
@mysql_free_result($result);
?>
</td>
</tr>

<tr>
<td width="40%" align="right" class="text">Unsafe credits you have earned</td>
<td align="left" class="text">
<input type="text" name="unsafe_credits" size="4" value="<?print $unsafe_credits;?>">
</td>
</tr>
<tr>
<td width="40%" align="right" class="text">Total credits you have left</td>
<td align="left" class="text">
<input type="text" name="total_credits" size="4" value="<?print $total_credits;?>">
</td>
</tr>
<tr>
<td width="40%" align="right" class="text" valign="top">Links in linksbox

http://URL|Title
http://URL2|Title2 </td>
<td align="left" class="text">
<textarea name="links" cols="40" rows="5"><?print $links;?></textarea>
</td>
</tr>
<tr>
<td width="40%" align="right" class="text">User Name:</td>
<td align="left" class="text">
<input type="text" name="name" size="15" value="<?print $name;?>">this is used for login propose
</td>
</tr>
<tr>
<td width="40%" align="right" class="text" valign="top">New Password</td>
<td align="left" class="text">
<input type="textfield" name="pass" size="15" value="<?print $pass;?>">
</td>
</tr>
<tr>
<td width="40%" align="right" class="text" valign="top"></td>
<td align="left" class="text">
<input type="submit" name="edit" value="Edit">
</td>
</tr>
<tr>
<td align="right"> </td>
<td align="right"> [ back ] </td>
</tr>
<tr>
<td align="right"> </td>
<td align="right"> [ statistics ] </td>
</tr>
</table>
</form>
<?
require('footer_adm.php');

?>
<? die/(mysql_error()) ?>

Spero possiate aiutarmi !

Discussione: ErroreWarning: mysql_fetch_array(): supplied argument is not a valid MySQL

Strumenti discussione

Ricerca discussione

Visualizza

Visualizzazione discussione

Permessi di invio