I’m receiving the following errors suddenly:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/97/6031597/html/index.php on line 102
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/97/6031597/html/index.php on line 129
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/97/6031597/html/index.php on line 150
The code has worked in the past and was never changed. The code refers to the following:
-
$totalRows_getHHH = mysql_num_rows($all_getHHH);
-
$totalRows_getEvents = mysql_num_rows($all_getEvents);
-
$totalRows_getNews = mysql_num_rows($all_getNews);
I’m rather confused since this has worked in the past.
The complete request:
$maxRows_getHHH = 4;
$pageNum_getHHH = 0;
if (isset($_GET['pageNum_getHHH'])) {
$pageNum_getHHH = $_GET['pageNum_getHHH'];
}
$startRow_getHHH = $pageNum_getHHH * $maxRows_getHHH;
mysql_select_db($database_Tr_L349, $Tr_L349);
$query_getHHH = "SELECT hth_id, heading FROM how_to_help";
$query_limit_getHHH = sprintf("%s LIMIT %d, %d", $query_getHHH, $startRow_getHHH, $maxRows_getHHH);
$getHHH = mysql_query($query_limit_getHHH, $Tr_L349) or die(mysql_error());
$row_getHHH = mysql_fetch_assoc($getHHH);
if (isset($_GET['totalRows_getHHH'])) {
$totalRows_getHHH = $_GET['totalRows_getHHH'];
} else {
$all_getHHH = mysql_query($query_getHHH);
$totalRows_getHHH = mysql_num_rows($all_getHHH);
}
$totalPages_getHHH = ceil($totalRows_getHHH/$maxRows_getHHH)-1;
mysql_select_db($database_Tr_L349, $Tr_L349);
$query_getBS = "SELECT books_on_sale.teaser, books_on_sale.book, books_on_sale.author, books_on_sale.image FROM books_on_sale ORDER BY books_on_sale.book";
$getBS = mysql_query($query_getBS, $Tr_L349) or die(mysql_error());
$row_getBS = mysql_fetch_assoc($getBS);
$totalRows_getBS = mysql_num_rows($getBS);
$maxRows_getEvents = 5;
$pageNum_getEvents = 0;
if (isset($_GET['pageNum_getEvents'])) {
$pageNum_getEvents = $_GET['pageNum_getEvents'];
}
$startRow_getEvents = $pageNum_getEvents * $maxRows_getEvents;
mysql_select_db($database_Tr_L349, $Tr_L349);
$query_getEvents = "SELECT event_id, event, day_time FROM events";
$query_limit_getEvents = sprintf("%s LIMIT %d, %d", $query_getEvents, $startRow_getEvents, $maxRows_getEvents);
$getEvents = mysql_query($query_limit_getEvents, $Tr_L349) or die(mysql_error());
$row_getEvents = mysql_fetch_assoc($getEvents);
if (isset($_GET['totalRows_getEvents'])) {
$totalRows_getEvents = $_GET['totalRows_getEvents'];
} else {
$all_getEvents = mysql_query($query_getEvents);
$totalRows_getEvents = mysql_num_rows($all_getEvents);
}
$totalPages_getEvents = ceil($totalRows_getEvents/$maxRows_getEvents)-1;
$maxRows_getNews = 3;
$pageNum_getNews = 0;
if (isset($_GET['pageNum_getNews'])) {
$pageNum_getNews = $_GET['pageNum_getNews'];
}
$startRow_getNews = $pageNum_getNews * $maxRows_getNews;
mysql_select_db($database_Tr_L349, $Tr_L349);
$query_getNews = "SELECT news_id, date_pub, title, link FROM news ORDER BY news_id DESC";
$query_limit_getNews = sprintf("%s LIMIT %d, %d", $query_getNews, $startRow_getNews, $maxRows_getNews);
$getNews = mysql_query($query_limit_getNews, $Tr_L349) or die(mysql_error());
$row_getNews = mysql_fetch_assoc($getNews);
if (isset($_GET['totalRows_getNews'])) {
$totalRows_getNews = $_GET['totalRows_getNews'];
} else {
$all_getNews = mysql_query($query_getNews);
$totalRows_getNews = mysql_num_rows($all_getNews);
}
$totalPages_getNews = ceil($totalRows_getNews/$maxRows_getNews)-1;
Do you see anything I’m missing?