Anyone able to help, i get Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 182.
line 182 is
while($row = mysql_fetch_array($sql)) {
full code
<?php
//error_reporting(E_ALL);
//ini_set("display_errors",1);
$mysite_username = $_COOKIE["mysite_username"];
$perpage2=$_POST['perpage'];
if($perpage2=="") {
//$perpage2=10;
} else {
setcookie("perpage", "$perpage2");
header('Location: memberarea.php');
}
include("config.php");
$search2=mysql_real_escape_string($_POST['search'],$dbc);
//$search = str_replace("'","",$search2);
$bad = array("'", "/", "union", "-", "+", "_", "?");
$search= str_replace($bad, "", $search2);
if($search=="") {
//$perpage2=10;
} else {
setcookie("search", "$search");
header('Location: memberarea.php');
}
$showall=$_GET['showall'];
if($showall=="yes") {
setcookie("search", "");
header('Location: memberarea.php');
}
$perpage2 =$_COOKIE["perpage"];
if ($perpage2=="10" or $perpage2=="20" or $perpage2=="50" or $perpage2=="100" or $perpage2=="200") {
} else {
$perpage2 = 10;//limit in each page
unset($_COOKIE['perpage']);
}
$sort=$_POST['sort'];
if ($sort=="") { $sort="";
} else {
setcookie("sort", "$sort");
header('Location: memberarea.php');
}
$sort=$_COOKIE["sort"];
if ($sort=="time" or $sort=="title" or $sort=="linkid") {
} else {
$sort = "time";//limit in each page
unset($_COOKIE['perpage']);
}
$order=$_POST['order'];
if ($order=="") { $order="";
} else {
setcookie("order", "$order");
header('Location: memberarea.php');
}
$order=$_COOKIE["order"];
if ($order=="asc" or $order=="desc") {
} else {
$order = "desc";//limit in each page
unset($_COOKIE['perpage']);
}
$search=$_COOKIE["search"];
if ($order!="") {
} else {
$order = "desc";//limit in each page
unset($_COOKIE['perpage']);
}
//header('Location: index.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="stylesheet" type="text/css" href="style1.css" />
<style type="text/css">
a {
color:#333;
text-transform: capitalize;
}
a:hover{
color: #999;
text-decoration:underline
}
</style>
<title>Member Area | <?php echo $webtitle ?></title>
<?php
require_once ('pagination.php');
include("template/top.php");
?>
<h1>Link View and Edit</h1>
</div>
<div class="middle_content">
<div class="middle_form">
<div class="left_content">
<?php
if (!isset($_COOKIE['loggedin'])) die("$lang_notlogin");
$update=$_GET['updateprofile'];
$delete=$_GET['delete'];
if ($delete=="yes") {
echo "<h1> <font color=red size=5>Links Deleted!!!</font></h2>";
}
if ($perpage=="10") {$select10="selected"; }
if ($perpage=="20") {$select20="selected"; }
if ($perpage=="50") {$select50="selected"; }
if ($perpage=="100") {$select100="selected"; }
if ($perpage=="200") {$select200="selected"; }
if ($sort=="time") {$sort10="selected"; }
if ($sort=="title") {$sort20="selected"; }
if ($sort=="linkid") {$sort50="selected"; }
if ($order=="acs") {$order10="selected"; }
if ($order=="desc") {$order20="selected"; }
//echo $perpage2;
?>
<br><table width="650px" align="RIGHT" valign="TOP">
<tr>
<td>
<b>Search:</b> <form name="form1" method="post" action="">
<input type="text" name="search" value="<?php echo $search; ?>"> <input type="submit" value="Go" name="per_search"></form><a href="memberarea.php?showall=yes"><b>Show ALL Links</b></a>
</td><td>
<b>ASC/DESC:</b> <form name="form1" method="post" action="">
<select name="order" onchange="this.form.submit();">
<option value="asc" <?php echo $order10; ?>>Ascending</option>
<option value="desc" <?php echo $order20; ?>>Descending</option>
</select><noscript> <input type="submit" value="Go" name="per_order"> </noscript></form>
</td><td>
<b>Sort:</b> <form name="form1" method="post" action="">
<select name="sort" onchange="this.form.submit();">
<option value="title" <?php echo $sort20; ?>>Title</option>
<option value="linkid" <?php echo $sort50; ?>>Link ID</option>
</select><noscript> <input type="submit" value="Go" name="per_sort"> </noscript></form>
</td><td>
<b>Per Page: </b><form name="form1" method="post" action="">
<select name="perpage" onchange="this.form.submit();">
<option value="10" <?php echo $select10; ?>>10</option>
<option value="20" <?php echo $select20; ?>>20</option>
<option value="50" <?php echo $select50; ?>>50</option>
<option value="100" <?php echo $select100; ?>>100</option>
<option value="200" <?php echo $select200; ?>>200</option>
</select><noscript> <input type="submit" value="Go" name="per_submit"> </noscript></form>
</td>
<td>
<form name="form1" method="post" action=""><input name="delete" type="submit" id="delete" value="Delete Link(s)">
</td>
</tr>
</table>
<table border="1" width="95%" cellpadding="2" cellspacing="2">
<tr>
<td background="images/text_box.gif" style="border:1px"> <b>Title/Edit</b> </td>
<td background="images/text_box.gif" style="border:1px"> <b>Links/View</b></td>
<td background="images/text_box.gif" style="border:1px"><b>Viewed</b></td>
<td background="images/text_box.gif" style="border:1px"><b>Delete</b></td>
</tr>
<?php
/*$query = "SELECT username, linkid, title, regedit, captcha, password FROM forlink where username='$mysite_username'";
$result = mysql_query($query) or die(mysql_error());
$sno=1;
while($row = mysql_fetch_array($result)){ */
$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
$page = ($page == 0 ? 1 : $page);
// echo "$perpage page 2 $perpage2";
if ($search=="") {
} else {
$finalsearch="AND title LIKE '%$search%'";
}
$startpoint = ($page * $perpage2) - $perpage2;
//$username2=$_GET["username"];
// echo $username2;
//$sql = @mysql_query("select * FROM `earn_url` WHERE `urid`='$username2' order by timing desc LIMIT $startpoint,$perpage");
// $sql = @mysql_query("select * FROM earn_url WHERE urid='$username2' order by id desc LIMIT $startpoint,$perpage");
$query = "SELECT username, linkid, title, regedit, captcha, password FROM forlink where username='$mysite_username' $finalsearch order by $sort $order LIMIT $startpoint, $perpage2";
//echo $query;
$sql =@mysql_query($query);
//select * FROM earn_url WHERE urid='sanishan' order by timing desc LIMIT 1,5
$sno=1;
while($row = mysql_fetch_array($sql)) {
//echo $row['username']. " - ". $row['linkid']. " - ". $row['title'];
$username=$row['username'];
$linkid=$row['linkid'];
$title=$row['title'];
$captcha=$row['captcha'];
$password=$row['password'];
//$check = "SELECT * FROM forlink inner join links on forlink.linkid = links.linkid where links.linkid='$linkid'";
$check = "select linkid from log where linkid= '$linkid';";
$qry = mysql_query($check)
or die ("Could not match data because ".mysql_error());
$num_rows = mysql_num_rows($qry);
//echo "Total Visit" . $num_rows;
echo "<tr>
<td style=border:1px><h4><a href=linkadd.php?linkadd=add&linkid=$linkid>$title</a></h4></td> ";
if ($captcha==1) {
echo " <td style=border:1px><h4><a href=linkcheck.php?linkid=$linkid>$linkid</a> </h4></td>";
} else {
echo " <td style=border:1px> <h4><a href=linkidwoc.php?linkid=$linkid>$linkid</a></h4> </td>";
}
$num_rows2=$num_rows+$num_rows2;
echo " <td style=border:1px><h4><a href=viewlog.php?linkid=$linkid>$num_rows </a></h4> </td> ";
?><td style=border:1px><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row['linkid']; ?>"> </td></tr><?
echo "</tr> ";
$sno=$sno+1;
}
?>
<?php
if($_POST['delete']){
//print_r($_POST);
$checkbox=$_POST['checkbox'];
//exit;
for($i=0;$i<count($checkbox);$i++){
$del_id = $checkbox[$i];
mysql_query("Delete FROM links WHERE linkid='$del_id'");
mysql_query("Delete FROM forlink WHERE linkid='$del_id'");
$result = mysql_query($sql);
?>
<script type="text/javascript">
<!--
window.location = "memberarea.php?delete=yes"
//-->
</script>
<?php
}
// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=index.php\">";
}
}
?> </table> <input name="delete" type="submit" id="delete" value="Delete Records"> </form> <?php
echo Pages("forlink",$perpage2,"memberarea.php?",$mysite_username,$search);
echo "<h1><B>Total Link View at this page</b> $num_rows2"; ?></h1>
<?php include("template/right.php");
include("template/bottom.php"); ?>
