"; $interviewee = trim(trim($row['bt_fname']).' '.trim($row['bt_lname'])); $date = date("j M Y", strtotime($row["archive_date"])); $description = str_replace('"', "'", $row["archive_description"]); */ include_once("/var/www/php/embed/_database_sba.php"); $sql = " SELECT interviews.id, interviews.title, interviews.filename, interviews.day, interviews.description, users.firstname, users.lastname FROM interviews, users WHERE interviews.filename = '$filename' AND users.id = interviews.interviewee_id_1 ORDER BY filename ASC "; $result = db_query($sql); $row = db_fetch_array($result); // define variables from the database $title = addslashes(trim($row["title"]).""); $title_for_html_title = addslashes(trim($row["title"])); $interviewid = $row['id']; $firstname = $row['firstname']; $lastname = $row['lastname']; $guest = addslashes($firstname.' '.$lastname); $description = str_replace('"', "'", $row["description"]).""; $date = date("j M Y", strtotime($row["day"])); $filename = trim(addslashes($row["filename"])); $mouseover = ''; $mouseoverend = ' [more]'; $truncateto = 160; if(strlen($description) > $truncateto) { $description = $mouseover.truncate($description, $truncateto).$mouseoverend; } // canonical link element URL $linkname = strtolower($firstname) ."-". strtolower($lastname) ."-". $interviewid; /* // query the database $PGconnection = pg_connect("host=drop.eyecentric.com dbname=sba user=askjim password=b@s1c"); $PGsql = "SELECT archive_num, archive_title, archive_url, archive_date, archive_description FROM archives WHERE archive_url = '$filename'"; $PGresult = pg_exec($PGconnection,$PGsql); $row = pg_fetch_array($PGresult); */ $urlitunes = "itpc://www.smallbusinessadvocate.com/small-business-interviews/". strtolower($firstname) ."-". strtolower($lastname) ."-". $interviewid .".rss"; $urllink = 'http://www.smallbusinessadvocate.com/embed/link.php?f='. $filename; // define variables from the database ?> Small business interview: , featuring
Featuring ()
Topic of Discussion
$length) { // string exceeded length, truncate and add trailing dots return substr($str,0,$length).$trailing; } else { // string was already short enough, return the string $res = $str; } } return $res; } ?>