Hi all,
Having some problems with Next/Previous script.
I can get the Next button to show with the correct variables but when it goes to that page it displays all kinds of errors.
eg.
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in c:\phpdev\www\swiftflix\admin\distributer_admin.php on line 150
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\phpdev\www\swiftflix\admin\distributer_admin.php on line 154
Can anyone see where i might be going wrong?
Here's the code:
if ($_GET['incoming'] == 'true'){
?>
<form name="URLJump">
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="right">
<span class="textSmallBold">SELECT:</span>
<select style="font-size:9; font-face:Verdana" name="urls" onchange="window.status=this.options[this.selectedIndex].text">
<option value="distributer_admin.php?incoming=true&sortby=all" <? if ($_GET['sortby'] == 'all') echo "selected"; ?>>All</option>
<option value="distributer_admin.php?incoming=true&sortby=today" <? if ($_GET['sortby'] == 'today') echo "selected"; ?>>Todays</option>
<option value="distributer_admin.php?incoming=true&sortby=past1" <? if ($_GET['sortby'] == 'past1') echo "selected"; ?>>Last 5 days</option>
<option value="distributer_admin.php?incoming=true&sortby=past2" <? if ($_GET['sortby'] == 'past2') echo "selected"; ?>>Last 10 days</option>
<option value="distributer_admin.php?incoming=true&sortby=past3" <? if ($_GET['sortby'] == 'past3') echo "selected"; ?>>Last 30 days</option>
<option value="distributer_admin.php?incoming=true&sortby=past4" <? if ($_GET['sortby'] == 'past4') echo "selected"; ?>>Last 60 days</option>
<option value="distributer_admin.php?incoming=true&sortby=past5" <? if ($_GET['sortby'] == 'past5') echo "selected"; ?>>Last 90 days</option>
</select>
<a href="#" onClick="jump (document.URLJump.urls.options[urls.selectedIndex].value)"><img src="images/go.gif" width="21" height="20" border="0" align="absbottom"></a>
</div></tr>
</table>
<table class=footer width="80%" border="0" cellpadding="0" cellspacing="0">
<tr class="textSmallBold">
<td width="15%"> ORDER DATE</td>
<td width="15%"> DISTRIBUTER</td>
<td width="45%"> TITLE</td>
<td width="10%"> PRICE</td>
<td width="5%"> QTY</td>
<td width="10%"></td>
</tr>
<?
include ("include/dbconnect.php");
if(!isset($_GET['start'])) $start = 0;
$row = mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM orders WHERE processed = 'N'"));
if($row[0] > 0){
if ($_GET['sortby'] == 'all'){
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
} else if ($_GET['sortby'] == 'today'){
$current_date = date("Y-m-d");
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' AND orders.order_date > '$current_date 00:00:00' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
} else if ($_POST['sortby'] == 'past1'){
$past_date = date('Y-m-d', time()-432000);
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' AND orders.order_date > '$past_date 00:00:00' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
} else if ($_GET['sortby'] == 'past2'){
$past_date = date('Y-m-d', time()-864000);
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' AND orders.order_date > '$past_date 00:00:00' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
} else if ($_GET['sortby'] == 'past3'){
$past_date = date('Y-m-d', time()-2952000);
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' AND orders.order_date > '$past_date 00:00:00' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
} else if ($_GET['sortby'] == 'past4'){
$past_date = date('Y-m-d', time()-5184000);
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' AND orders.order_date > '$past_date 00:00:00' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
} else if ($_GET['sortby'] == 'past5'){
$past_date = date('Y-m-d', time()-7776000);
$sql = mysql_query("SELECT * FROM orders, movie WHERE orders.movie_id = movie.movie_id AND orders.processed = 'N' AND orders.order_date > '$past_date 00:00:00' ORDER BY movie.movie_studio LIMIT " . $start . ", 2");
}
$resultsnumber = mysql_numrows($sql);
$alternate = "2";
while($row = mysql_fetch_array($sql)){
$order_id = $row["order_id"];
$customer_id = $row["customer_id"];
$movie_title = $row["movie_title"];
$movie_current_price = $row["movie_current_price"];
$qty = $row["qty"];
$order_date = $row["order_date"];
$processed = $row["processed"];
$movie_studio = $row["movie_studio"];
if ($alternate == "1") {
$color = "#ffffff";
$alternate = "2";
} else {
$color = "#efefef";
$alternate = "1";
}
?>
<tr class="textSmall" bgcolor="<? echo $color ?>">
<td class="textSmall"> <? echo $order_date ?></td>
<td class="textSmall"> <? echo $movie_studio ?></td>
<td class="textSmall"> <? echo $movie_title ?></td>
<td class="textSmall"> <? echo $movie_current_price ?></td>
<td class="textSmall"> <? echo $qty ?></td>
<?
echo "<td align='center'><a href=order_admin.php?orders=detail&id=$customer_id&order_id=$order_id><img src='images/details_btn.gif' border='0' align='middle'></a>";
?>
<td class="textSmall"></td>
</tr>
<?
}
?>
</table>
<table width="80%" border="0" cellpadding="0" cellspacing="0">
<tr>
<?
if($resultsnumber <= 2){
echo "";
}
if($_GET['start'] >= 2)
echo "<td><a href=\"javascript:void(0);\" onclick=\"history.back(); return(false);\" >Previous</a>";
if($resultsnumber >= 2)
echo " <a href=\"" . $PHP_SELF . "?incoming=true&sortby=" . $_GET['sortby'] . "&start=" . ($_GET['start'] + 2) . "\">Next</a>";
}
?>
</td>
</tr>
</table>
</form>
Cheers,
chrima