Data Assist and CMS
I have just added a table to the database of PowerCMS and then ran data assist to help me build admin pages to edit the new table. I have just tested the pages, and for the first time ever that I have run this extension, I have resultant pages that error. The error is:
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/linux/a/abc.com/user/htdocs/admin/seo.php on line 91
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/linux/a/abc.com/user/htdocs/admin/seo.php on line 95
Line 91 is: mysql_select_db($database_localhost, $localhost);
and 95 is: $WADAseo = mysql_query($query_limit_WADAseo, $localhost) or die(mysql_error());
The two lines are part of this:
<?php
$maxRows_WADAseo = 1000;
$pageNum_WADAseo = 0;
if (isset($_GET['pageNum_WADAseo'])) {
$pageNum_WADAseo = $_GET['pageNum_WADAseo'];
}
$startRow_WADAseo = $pageNum_WADAseo * $maxRows_WADAseo;
mysql_select_db($database_localhost, $localhost);
$query_WADAseo = "SELECT seoID, pagename, browsertitle, metatags, metadescription FROM seo";
setQueryBuilderSource($query_WADAseo,$WADbSearch1,false);
$query_limit_WADAseo = sprintf("%s LIMIT %d, %d", $query_WADAseo, $startRow_WADAseo, $maxRows_WADAseo);
$WADAseo = mysql_query($query_limit_WADAseo, $localhost) or die(mysql_error());
$row_WADAseo = mysql_fetch_assoc($WADAseo);
if (isset($_GET['totalRows_WADAseo'])) {
$totalRows_WADAseo = $_GET['totalRows_WADAseo'];
} else {
$all_WADAseo = mysql_query($query_WADAseo);
$totalRows_WADAseo = mysql_num_rows($all_WADAseo);
}
$totalPages_WADAseo = ceil($totalRows_WADAseo/$maxRows_WADAseo)-1;
?>
Have you got any advice on this as I am stumped. There is content in the MySQL table, it's a simple table, and yet I can't get the results page to display. The insert and search page (prior to a search) will display, but these don't seem to be calling anything from the database yet.