No Database Selected

Peer,
you can put all the connection data into the beginning of dbconnection.php file. Then remove it from ..._variables.php and dbcommon.php files.
dbcommon.php is used by login and registration related pages while ..._variables.php files are used by table pages.

OK

Here is my db common.

<?php
$user="xxxxxxx";

$pwd="xxxxxxx";

$host="xxxxxxx";

$port="";

$sys_dbname="xxxxxxx";
define("LOGIN_HARDCODED","0");

define("LOGIN_TABLE","1");
define("ADVSECURITY_ALL","0");

define("ADVSECURITY_VIEW_OWN","1");

define("ADVSECURITY_EDIT_OWN","2");

define("ADVSECURITY_NONE","3");
define("ACCESS_LEVEL_ADMIN","Admin");

define("ACCESS_LEVEL_USER","User");

define("ACCESS_LEVEL_GUEST","Guest");
$strLeftWrapper="`";

$strRightWrapper="`";
$cLoginTable = "``";

$cUserNameField = "";

$cPasswordField = "";
?>
Here is my _variables.php
When I delete the below from the _variables.php

$user="xxxxxxx";

$pwd="xxxxxxx";

$host="xxxxxx";

$port="";

$sys_dbname="xxxxxxx";
I get the following error:
PHP error happened

Technical information

Error type 256

Error description No Database Selected

URL www.techsgroup.com/components/com_mosaddressbook/mos_addressbook_list.php

Error file C:\Inetpub\wwwroot\techsgroup\mambo\components\com_mosaddressbook\include\dbconnection.php

Error line 12

SQL query
?
$user="xxxxxxx";

$pwd="xxxxxxx";

$host="xxxxxx";

$port="";

$sys_dbname="xxxxxxx";
$dDebug=false;

$dSQL="";
$strKeyField="address_book_id";

$strKeyField2="";

$strKeyField3="";

$strTableName="`mos_addressbook`";

$gPageSize=20;

$strLeftWrapper="`";

$strRightWrapper="`";

$gstrOrderBy="ORDER BY `create_date` ASC, `contact` ASC, `position` ASC, `company_name` ASC, `work_phone` ASC, `work_phone_ext` ASC, `cell_phone` ASC, `fax_phone` ASC, `home_phone` ASC, `primary_email` ASC, `secondary_email` ASC, `primary_web_address` ASC, `secondary_web_address` ASC, `billing_address_one` ASC, `billing_address_two` ASC, `billing_city` ASC, `billing_state` ASC, `billing_zip` ASC, `status` ASC, `address_book_id` ASC";

$bKeyFieldEditable1=False;

$bKeyFieldEditable2=False;

$bKeyFieldEditable3=False;

$gstrSQL = "select `create_date`, `status`, `contact`, `position`, `company_name`, `work_phone`, `work_phone_ext`, `cell_phone`, `fax_phone`, `home_phone`, `primary_email`, `secondary_email`, `billing_address_one`, `billing_address_two`, `billing_city`, `billing_state`, `billing_zip`, `primary_web_address`, `secondary_web_address`, `address_book_id` From `mos_addressbook`";
define("FORMAT_NONE","");

define("FORMAT_DATE_SHORT","Short Date");

define("FORMAT_DATE_LONG","Long Date");

define("FORMAT_DATE_TIME","Time");

define("FORMAT_CURRENCY","Currency");

define("FORMAT_HYPERLINK","Hyperlink");

define("FORMAT_EMAILHYPERLINK","Email Hyperlink");

define("FORMAT_FILE_IMAGE","File-based image");

define("FORMAT_DATABASE_IMAGE","Database image");

define("FORMAT_DATABASE_FILE","Database file");

define("FORMAT_LOOKUP_WIZARD","Lookup wizard");

define("FORMAT_PHONE_NUMBER","US Phone Number");

define("FORMAT_NUMBER","Number");

define("FORMAT_HTML","HTML");
define("EDIT_FORMAT_NONE","");

define("EDIT_FORMAT_TEXT_FIELD","Text field");

define("EDIT_FORMAT_TEXT_AREA","Text area");

define("EDIT_FORMAT_PASSWORD","Password");

define("EDIT_FORMAT_DATE","Date");

define("EDIT_FORMAT_RADIO","Radio button");

define("EDIT_FORMAT_CHECKBOX","Checkbox");

define("EDIT_FORMAT_DATABASE_IMAGE","Database image");

define("EDIT_FORMAT_DATABASE_FILE","Database file");

define("EDIT_FORMAT_LOOKUP_WIZARD","Lookup wizard");

define("EDIT_FORMAT_HIDDEN","Hidden field");

define("EDIT_FORMAT_READONLY","Readonly");
define("EDIT_DATE_SIMPLE",0);

define("EDIT_DATE_SIMPLE_DDMMYYYY_DP",1);

define("EDIT_DATE_SIMPLE_MMDDYYYY_DP",2);

define("EDIT_DATE_DDMMYYYY",3);

define("EDIT_DATE_DDMMYYYY_DP",4);

define("EDIT_DATE_MMDDYYYY",5);

define("EDIT_DATE_MMDDYYYY_DP",6);
define("MODE_ADD",0);

define("MODE_EDIT",1);

define("MODE_SEARCH",2);
define("LOGIN_HARDCODED",0);

define("LOGIN_TABLE",1);
define("ADVSECURITY_ALL",0);

define("ADVSECURITY_VIEW_OWN",1);

define("ADVSECURITY_EDIT_OWN",2);

define("ADVSECURITY_NONE",3);
define("ACCESS_LEVEL_ADMIN","Admin");

define("ACCESS_LEVEL_USER","User");

define("ACCESS_LEVEL_GUEST","Guest");
define("DATABASE_MSSQLServer","MS SQL SERVER");

define("DATABASE_SQLAnyWhere","SYBASE SQL ANYWHERE");

define("DATABASE_ASAnyWhere","ADAPTIVE SERVER ANYWHERE");

define("DATABASE_SybaseOpenServer","SQL SERVER");

define("DATABASE_Oracle","ORACLE");

define("DATABASE_VisualFoxPro","VISUAL FOXPRO");

define("DATABASE_Excel","EXCEL");

define("DATABASE_Access","ACCESS");

define("DATABASE_Text","TEXT");

define("DATABASE_MySQL","MYSQL");

define("DATABASE_Paradox","PARADOX");

define("DATABASE_FileMaker","FILEMAKER PRO");

define("DATABASE_Unknown","UNKNOWN");
$cAdvSecurityMethod = 0;

$cLoginMethod = 0;

$cNumberOfChars = 80;
$cMaxUploadFileSize = 2048*1024;
$cXMLTopNode = "rs";

$cXMLRowNode = "row";

$cYearRadius = 50;
$HRMonth=array();

$HRMonth[1]="January";

$HRMonth[2]="February";

$HRMonth[3]="May";

$HRMonth[4]="April";

$HRMonth[5]="May";

$HRMonth[6]="June";

$HRMonth[7]="July";

$HRMonth[8]="August";

$HRMonth[9]="September";

$HRMonth[10]="October";

$HRMonth[11]="November";

$HRMonth[12]="December";
Here is the _variables as I have it saved to generate the error.
<?
$dDebug=false;

$dSQL="";
$strKeyField="address_book_id";

$strKeyField2="";

$strKeyField3="";

$strTableName="`mos_addressbook`";

$gPageSize=20;

$strLeftWrapper="`";

$strRightWrapper="`";

$gstrOrderBy="ORDER BY `create_date` ASC, `contact` ASC, `position` ASC, `company_name` ASC, `work_phone` ASC,
`work_phone_ext` ASC, `cell_phone` ASC, `fax_phone` ASC, `home_phone` ASC, `primary_email` ASC, `secondary_email` ASC,
`primary_web_address` ASC, `secondary_web_address` ASC, `billing_address_one` ASC, `billing_address_two` ASC, `billing_city`
ASC, `billing_state` ASC, `billing_zip` ASC, `status` ASC, `address_book_id` ASC";

$bKeyFieldEditable1=False;

$bKeyFieldEditable2=False;

$bKeyFieldEditable3=False;

$gstrSQL = "select `create_date`, `status`, `contact`, `position`, `company_name`, `work_phone`, `work_phone_ext`,
`cell_phone`, `fax_phone`, `home_phone`, `primary_email`, `secondary_email`, `billing_address_one`,
`billing_address_two`, `billing_city`, `billing_state`, `billing_zip`, `primary_web_address`,
`secondary_web_address`, `address_book_id` From `mos_addressbook`";
define("FORMAT_NONE","");

define("FORMAT_DATE_SHORT","Short Date");

define("FORMAT_DATE_LONG","Long Date");

define("FORMAT_DATE_TIME","Time");

define("FORMAT_CURRENCY","Currency");

define("FORMAT_HYPERLINK","Hyperlink");

define("FORMAT_EMAILHYPERLINK","Email Hyperlink");

define("FORMAT_FILE_IMAGE","File-based image");

define("FORMAT_DATABASE_IMAGE","Database image");

define("FORMAT_DATABASE_FILE","Database file");

define("FORMAT_LOOKUP_WIZARD","Lookup wizard");

define("FORMAT_PHONE_NUMBER","US Phone Number");

define("FORMAT_NUMBER","Number");

define("FORMAT_HTML","HTML");
define("EDIT_FORMAT_NONE","");

define("EDIT_FORMAT_TEXT_FIELD","Text field");

define("EDIT_FORMAT_TEXT_AREA","Text area");

define("EDIT_FORMAT_PASSWORD","Password");

define("EDIT_FORMAT_DATE","Date");

define("EDIT_FORMAT_RADIO","Radio button");

define("EDIT_FORMAT_CHECKBOX","Checkbox");

define("EDIT_FORMAT_DATABASE_IMAGE","Database image");

define("EDIT_FORMAT_DATABASE_FILE","Database file");

define("EDIT_FORMAT_LOOKUP_WIZARD","Lookup wizard");

define("EDIT_FORMAT_HIDDEN","Hidden field");

define("EDIT_FORMAT_READONLY","Readonly");
define("EDIT_DATE_SIMPLE",0);

define("EDIT_DATE_SIMPLE_DDMMYYYY_DP",1);

define("EDIT_DATE_SIMPLE_MMDDYYYY_DP",2);

define("EDIT_DATE_DDMMYYYY",3);

define("EDIT_DATE_DDMMYYYY_DP",4);

define("EDIT_DATE_MMDDYYYY",5);

define("EDIT_DATE_MMDDYYYY_DP",6);
define("MODE_ADD",0);

define("MODE_EDIT",1);

define("MODE_SEARCH",2);
define("LOGIN_HARDCODED",0);

define("LOGIN_TABLE",1);
define("ADVSECURITY_ALL",0);

define("ADVSECURITY_VIEW_OWN",1);

define("ADVSECURITY_EDIT_OWN",2);

define("ADVSECURITY_NONE",3);
define("ACCESS_LEVEL_ADMIN","Admin");

define("ACCESS_LEVEL_USER","User");

define("ACCESS_LEVEL_GUEST","Guest");
define("DATABASE_MSSQLServer","MS SQL SERVER");

define("DATABASE_SQLAnyWhere","SYBASE SQL ANYWHERE");

define("DATABASE_ASAnyWhere","ADAPTIVE SERVER ANYWHERE");

define("DATABASE_SybaseOpenServer","SQL SERVER");

define("DATABASE_Oracle","ORACLE");

define("DATABASE_VisualFoxPro","VISUAL FOXPRO");

define("DATABASE_Excel","EXCEL");

define("DATABASE_Access","ACCESS");

define("DATABASE_Text","TEXT");

define("DATABASE_MySQL","MYSQL");

define("DATABASE_Paradox","PARADOX");

define("DATABASE_FileMaker","FILEMAKER PRO");

define("DATABASE_Unknown","UNKNOWN");
$cAdvSecurityMethod = 0;

$cLoginMethod = 0;

$cNumberOfChars = 80;
$cMaxUploadFileSize = 2048*1024;
$cXMLTopNode = "rs";

$cXMLRowNode = "row";

$cYearRadius = 50;
$HRMonth=array();

$HRMonth[1]="January";

$HRMonth[2]="February";

$HRMonth[3]="May";

$HRMonth[4]="April";

$HRMonth[5]="May";

$HRMonth[6]="June";

$HRMonth[7]="July";

$HRMonth[8]="August";

$HRMonth[9]="September";

$HRMonth[10]="October";

$HRMonth[11]="November";

$HRMonth[12]="December";
?>

I have three "modules: Address Book, which is the main, Notes and Tracker. Each are tables linked to the master table Address Book.
I put the include("include/dbcommon.php"); statement at the top of the mos_addressbook_list.php. As soon as I do to another detail table, like notes, that include("include/dbcommon.php"); is lost. How do I get that statement to be inserted in just one place at the beginning and not have to put into all my script files?
Thanks
Peer

Peer,
you should place all the connection data into dbconnection.php file, not the dbcommon.php if you want to keep it in one file.

OK Let me try that..

Thanks

Peer

Works Like A Champ!

Thanks

Peer

Database: MySql: PHPRunner: Connection: Data: How to change manually your connection data?

http://www.faqts.com/knowledge_base/view.p.../36012/fid/1805