Thanks Jason,
Locally using my XAMPP testing server, everything seems to work OK.
However, when I go live, with the error reporting on I get the following;
Notice: Undefined variable: database_DW_TDSDBase in /netapp/whnas-silo1-node1/s6/s6/01000/www.dpinnovations.com/webdocs/uR.php on line 101
Notice: Undefined variable: DW_TDSDBase in /netapp/whnas-silo1-node1/s6/s6/01000/www.dpinnovations.com/webdocs/uR.php on line 101
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /netapp/whnas-silo1-node1/s6/s6/01000/www.dpinnovations.com/webdocs/uR.php on line 101
Notice: Undefined variable: DW_TDSDBase in /netapp/whnas-silo1-node1/s6/s6/01000/www.dpinnovations.com/webdocs/uR.php on line 105
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /netapp/whnas-silo1-node1/s6/s6/01000/www.dpinnovations.com/webdocs/uR.php on line 105
Here's the text relevant to the first error message;
mysql_select_db($database_DW_TDSDBase, $DW_TDSDBase); < Line 101
$query_WADAusers = "SELECT UserID, UserEmail, UserFirstName, UserLastName, UserIP, UserCountry, UserType, UserLoginName, UserCompany, UserReseller FROM users ORDER BY UserLoginName ASC";
setQueryBuilderSource($query_WADAusers,$WADbSearch1,false);
$query_limit_WADAusers = sprintf("%s LIMIT %d, %d", $query_WADAusers, $startRow_WADAusers, $maxRows_WADAusers);
$WADAusers = mysql_query($query_limit_WADAusers, $DW_TDSDBase) or die(mysql_error());
$row_WADAusers = mysql_fetch_assoc($WADAusers);
Thanks for your help (Is this anything to do with my connection having an '_' in it ?)