<?php include("assets/snippets/eventlister/config.php"); $query = " SELECT * FROM subscriptions WHERE email = '[+user.email+]' "; $paramra = array( 'hostvar' =>$dbhost, 'uservar' => $dbuser, 'passvar' => $dbpass, 'databasevar'=> $dbname, 'sql' =>$query, 'chunkName' =>'youreventsformat', 'perPage' => '', 'orderby' => '', 'missingValTxt' => '--'); return $modx->runSnippet('loopDBChunk' , $paramra); ?>
WHERE email = $_SESSION['webEmail'] or WHERE email = '$_SESSION['webEmail']' I guess I'm just too clueless.
<?php include("assets/snippets/eventlister/config.php"); $email = $_SESSION['webEmail']; $query = " SELECT * FROM subscriptions WHERE email = '$email' "; $paramra = array( 'hostvar' =>$dbhost, 'uservar' => $dbuser, 'passvar' => $dbpass, 'databasevar'=> $dbname, 'sql' =>$query, 'chunkName' =>'youreventsformat', 'perPage' => '', 'orderby' => '', 'missingValTxt' => '--'); return $modx->runSnippet('loopDBChunk' , $paramra); ?>
<?php include("assets/snippets/eventlister/config.php"); $email = $_SESSION['webEmail']; $query = " SELECT * FROM subscriptions WHERE email = \'{$email}\' "; $paramra = array( 'hostvar' =>$dbhost, 'uservar' => $dbuser, 'passvar' => $dbpass, 'databasevar'=> $dbname, 'sql' =>$query, 'chunkName' =>'youreventsformat', 'perPage' => '', 'orderby' => '', 'missingValTxt' => '--'); return $modx->runSnippet('loopDBChunk' , $paramra); ?>
<?php include("assets/snippets/eventlister/config.php"); $email = $_SESSION['webEmail']; $query = " SELECT * FROM subscriptions WHERE email = '$email' "; $paramra = array( 'hostvar' =>$dbhost, 'uservar' => $dbuser, 'passvar' => $dbpass, 'databasevar'=> $dbname, 'sql' =>$query, 'chunkName' =>'youreventsformat', 'perPage' => '', 'orderby' => '', 'missingValTxt' => '#'); return $modx->runSnippet('loopDBChunk' , $paramra); ?>