How to find the table name with the following code

[reddymade]

Please help, i am new to php this is a software i bought and now i am trying to do some modifications:

I dont find the table called SETTINGS_TABLE under the database, is there a way to find the name of the table: PLease help.

	////////// settings
	$strSQL = "select value, name from ".SETTINGS_TABLE." where name in ( 'min_age_limit', 'max_age_limit','zip_letters', 'zip_count') ";
	$rs = $dbconn->Execute($strSQL);
	while(!$rs->EOF){
		$settings[$rs->fields[1]] = $rs->fields[0];
		$rs->MoveNext();
	}

Thank you very much for the information.

[toplay]

You have to create the database and tables. Maybe the software has an SQL file for creating the tables that you have to run within phpmyadmin or similar tool. The SQL "show tables;" command will reveal all table names found in a particular database.

The above code you posted shows a constant that is just called SETTINGS_TABLE. This can have a value of anything, or rather it needs to be set to the actual name of your particular table. Example:

define('SETTINGS_TABLE', 'table_name');

Read the documentation or instructions that might have come with the software. Search the code and configuration files for that constant to see where it's defined. If it's not found, then you have to define it.

Good luck.