Jeepers Creepers - Down Low and Fun to Grow

$iLength) : $sTempText = substr($sText, 0, ($iLength - 3)); $sText = "$sTempText..."; endif; if (strlen($sText) == 0) : $sText = " "; endif; return $sText; } $sHostname = "localhost"; $sUser = "do180_DBUser"; $sDBPassword = "green@@chair11"; $sDatabase = "do180_JeepersCreepers"; try { $pdoConnection = new PDO("mysql:host=$sHostname;dbname=$sDatabase;charset=utf8", $sUser, $sDBPassword); $pdoConnection -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdoConnection -> setAttribute(PDO::ATTR_EMULATE_PREPARES, false); $pdoConnection -> query("set names utf8"); $sqlJC = $pdoConnection->prepare("select * from Data where itemnum = '1'"); $sqlJC->execute(); $sRow = $sqlJC->setFetchMode(PDO::FETCH_ASSOC); $sRow = $sqlJC->fetch(); } catch(PDOException $pdoResult) { die("Sorry, Database Offline..."); } $sRow["news"] = preg_replace('/\n/', '
', $sRow["news"]); $sRow["tip"] = preg_replace('/\n/', '
', $sRow["tip"]); $sPlant1 = $sRow["plant1"]; $sPlant2 = $sRow["plant2"]; $sqlJC = $pdoConnection->prepare("select * from Plants order by rand() limit 1"); $sqlJC->execute(); # $sRowPlant1 = $sqlJC->setFetchMode(PDO::FETCH_ASSOC); $sRowPlant1 = $sqlJC->fetch(PDO::FETCH_ASSOC); $sqlJC = $pdoConnection->prepare("select * from Plants order by rand() limit 1"); $sqlJC->execute(); $sRowPlant2 = $sqlJC->setFetchMode(PDO::FETCH_ASSOC); $sRowPlant2 = $sqlJC->fetch(); ?>