PHP - Please Help Echoing Constant

Hi,
Please can someone tell me why the text in my constant is not displaying?
Code: [Select]

if($totalRows_checkdup_RS==1)
{
$errorMsg =  '.CNT_TXT_WARNING_EMAILEXISTE.'; // I want this constant to print a warning message but all I get printed is the constant!!!
}

else{

Can someone help me out, I had a guy make some great changes to a script. works perfectly - however I want to modify it further and he's unavailable till tomorrow to discuss.

Hopefully someone will be able to guide me:

define('TBL_PROFILE_COUNTRY_FILTER', '`country_id` = \'IE\'');

This line is based on users in a database from Ireland (IE) but what I need to do is make it so that this TBL_PROFILE_COUNTRY_FILTER doesnt just filter Ireland members but also those from Northern Ireland (Ni) as well.

So my question is this - can I (and if so how) - can I add Ni to this define statement.

Grateful for any guidance (php isn't my thing at all but I'm trying to pick up what I need when I need it).

Thanks again.

I get an undefined constant error message.  Am I using the variable correctly?  Should I use an echo to output the variable as text?

Added by <?php ${displayName}; ?>

I can't see what I'm doing wrong here.
When I use this code, the link HOME gets echoes with no problem:
Code: [Select]
         
<td valign="middle"><?php echo '<a href="index.php"'; 
if(strstr($checkit,"index.php")) echo ' class="clicked"'; 
else echo ' class="menulinks"';
echo '>HOME</a>'; ?></td>
...but when I swap HOME with a php constant, I get nothing...
Code: [Select]
         
<td valign="middle"><?php echo '<a href="index.php"'; 
if(strstr($checkit,"index.php")) echo ' class="clicked"'; 
else echo ' class="menulinks"';
echo '><?=CNT_TXT_HOME?></a>'; ?></td>
Please help

I am having a problem with some php code that runs on a landing page that queries a database for the content needed to display on the template page from the keywords passed in the url. My issue is that when I tried to add some php code to the template page it reads it fails and returns

Notice: Use of undefined constant tdbd_name - assumed 'tdbd_name' in /var/www/ppcindex.php on line 147 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/ppcindex.php on line 150

If anyone could point me in the right direction it would be much appreciated.

Here is the code from the landing page php





<?php 
// template variables - PLEASE CHANGE 


error_reporting(E_ALL); 
ini_set('display_errors','On'); 
define("TEMPLATE_NAME","ppcindexcontent.php"); // your page templates 
define("FULL_PATH","/var/www/speedppc/"); // true path to your speedPPC install directory 
define("MAX_ROWS",1); // maximum display rows for CSV data - we recommend no more the 100 records 

if(!isset($_GET["CSVID"])){ 
    define("CSVID", "18"); // CSVID of your csv file. leave blank if passing csvid in the url (See README.txt) 
} 
else { 
    define("CSVID", $_GET[csvid], true); 
} 

define("REPLACECHAR", '-'); // this is the replacement character for the custom function replace() 
// include files 
include(FULL_PATH."config.php"); 
include(FULL_PATH."common.php"); 

// variables passed in URL 
$csvkeyword = $_GET['csvkeyword']; 
$seed = $_GET['seed']; 
$expansion = $_GET['expansion']; 
$final = $_GET['final']; 

// connect to DB 
$dbhandle = dbconnect($host, $user, $pass, $db); 


// functions 
function replaceTokens($passedContent) { 
    global $csvkeyword, $seed, $expansion, $final; 
    $tokens = array("[%csvkeyword%]", "[%seed%]", "[%expansion%]", "[%final%]", "[%Csvkeyword%]", "[%Seed%]", "[%Expansion%]", "[%Final%]"); 
    $tokenValues = array(rs($csvkeyword), rs($seed), rs($expansion), rs($final), uc(rs($csvkeyword)), uc(rs($seed)), uc(rs($expansion)), uc(rs($final))); 
    $replacedContent = str_replace($tokens, $tokenValues, $passedContent); 
    return $replacedContent; 
} 

function stripUndefinedTokens($passedContent) { 
    $patterns = '/\[%.*?(%\]|\]|%)/'; 
    $result = preg_replace($patterns, '', $passedContent); 
    return $result; 
} 

function changeCase($passedContent) { 
    $patterns = '/\$.*?\]/'; 
    $string = $passedContent; 
    preg_match_all($patterns, $string, $matches); 
    $uniqueMatches = array_unique($matches[0]);   

    foreach($uniqueMatches as $key => $value) { 
        if(substr($value, 13, 1) == strtoupper(substr($value, 13, 1))) { 
            $string = str_replace($value, '".ucwords('.strtolower($value).')."', $string); 
        } 
    } 
    return $string; 
} 

function replaceChar($passedContent) { 
    $string = $passedContent; 
    $patterns = '/replace\(.*?\)/'; 
    preg_match_all($patterns, $string, $matches); 
    $replaceChar = '-'; 
    foreach($matches[0] as $key => $value) { 
        $valueReplaced = str_replace(' ', REPLACECHAR, $value); 
        $string = str_replace($value, $valueReplaced, $string); 
    } 
    $replace = array("replace(", ")"); 
    //$string = str_replace($replace, '', $string); 
    return $string; 
} 

function rs($passWord) { 
    return str_replace('-', ' ', $passWord); 
} 

function uc($passWord) { 
    return ucfirst($passWord); 
} 

// get CSV table Information 
$sql = "SELECT * FROM tabledb_details WHERE tdbd_id = '".CSVID."'"; 
$result = mysql_query($sql); 
$row = mysql_fetch_assoc($result); 

// replace '-' in keyword with space and also use keyword with '-' in it incase it is part of the word 
$keywordsArray = explode(",", $csvkeyword); 
$i = 0; 
foreach($keywordsArray as $key => $value) { 
    $keywords[$i] = $value; 
    $i++; 
    $position = strpos($value, '-'); 
    if($position !== false){ 
        $keywords[$i] = str_replace("-", " ", $value); 
        $i++; 
    } 
} 

// CSV fields  to search keyword occurence in 
$keywordFields = explode("|", $row[tdbd_search_fields]); 

$sqlKeyword = ' ('; 
foreach($keywords as $key => $value) { 
    $sqlKeyword .= "("; 
    foreach($keywordFields as $keyField => $valueField) { 
        $sqlKeyword .= "`" . $valueField . "` REGEXP '( |^)".$value."( |s|[\.]|$)' OR ";  
    } 
    $sqlKeyword = substr($sqlKeyword, 0, -4); 
    $sqlKeyword .= ") OR "; 
} 
$sqlKeyword = substr($sqlKeyword, 0, -4).')'; 

// set the default sql 'where' section if the keyword is not defined in url 
if($csvkeyword == '' || !isset($csvkeyword)) { 
    $sqlKeyword = '1'; 
} 




// start template Display Output 
ob_start(); 
include(TEMPLATE_NAME); 
$output = ob_get_contents(); 
ob_end_clean(); 

// get the position of the loop template 
$loopStart = strpos($output,"[start_csv_loop]"); 
$loopEnd = strpos($output,"[end_csv_loop]"); 
// get the loop template layout 
$loopTemplate = substr($output, ($loopStart+16), ($loopEnd-($loopStart+16))); 

// get content before loop template 
$preContent = stripslashes(stripUndefinedTokens(addslashes(replaceTokens(substr($output, 0, $loopStart))))); 

// get content after loop template 
$postContent = stripslashes(stripUndefinedTokens(addslashes(replaceTokens(substr($output, $loopEnd+14))))); 



// output pre content 
eval("\$preContent = \"$preContent\";"); 
print_r( replaceChar($preContent) ); 

$sqlSearch = "SELECT * FROM ".$row[tdbd_name]." WHERE ".$sqlKeyword." LIMIT ".MAX_ROWS; 
$resultSearch = mysql_query($sqlSearch); 

while($displayrows = mysql_fetch_assoc($resultSearch)) { 
    $display = replaceTokens($loopTemplate); 
    $display = str_replace('\\', '[backslash]', $display); 
    $display = str_replace('[%', '$displayrows[', $display); 
    $display = addslashes(str_replace('%]', ']', $display)); 
    $display = replaceTokens($display); 
    $display = changeCase($display); 

    eval("\$display = \"$display\";"); 

    $display = stripslashes($display); 
    $display = str_replace('[backslash]', '\\', $display); 
    $display = replaceChar($display); 

    print_r( $display ); 

} 
// output post content 
eval("\$postContent = \"$postContent\";"); 
print_r( replaceChar($postContent) ); 
?>




And here is part of the template (ppcindexcontent.php) the above code is reading.

                 <div style=" float:right; width: 300px; height: 0px; margin-top:-20px ; margin-bottom:0px"> 
                <p style=" font-size:16px; text-align: center;  line-height:1; color:#0391D1;">     

                 
<?php 
error_reporting(E_ALL); 
ini_set('display_errors','On'); 
$mySQLServer = "xxxxxx"; 
$mySQLUser = "xxxxxxxx"; 
$mySQLPass = "xxxxxxxxx"; 
$mySQLDB = "xxxxxxxxxxx";  
$SQLToday = date("m/d/y") . "<br />"; 
$SQLsevendays = mktime(0,0,0,date("n"),date("j")-7,date("Y")); 
$SQLsevenname = (date("l", $SQLsevendays)); 
$SQLsevennumber = (date("jS", $SQLsevendays)); 
$dbhandle = mssql_connect($mySQLServer, $mySQLUser, $mySQLPass) 
  or die("Couldn't connect to SQL Server on $myServer");  
$selected = mssql_select_db($mySQLDB, $dbhandle) 
  or die("Couldn't open database $myDB");  
$query = "WEB_ApproveHistory @State='CA', @Days=5, @Records=8"; 
$data = mssql_query($query); 
$result = array(); 

while ($row = mssql_fetch_object($data)) : 
 $result[] = $row; 
 $returnedresults = (97*($row->TotalApprovals)) ; 
  

endwhile; 
$englishreturnedresults = number_format($returnedresults); 
echo 'In just the last week since ' . $SQLsevenname . ' the ' . $SQLsevennumber . ' xx '; 
echo $englishreturnedresults;  
echo ' to People Just Like you In California. <br><br>Here are just a few people who' ; 

echo '<ul class="BulletCheck">'; 

mssql_next_result($data); 


while ($row = mssql_fetch_object($data)) : 

       $result[] = $row; 
       echo '<li>' . '  ' . $row->FirstName  . ' From '. $row->City . ', ' . $row->State .' PreApproved On ' .$row->ApprovedDate . '</li>'; 
endwhile; 
mssql_close($dbhandle); 
?>             

</div>