These are videos I have taken from various sites I have worked at recently. Click any row to see the streaming video. Please note I am a DJ, not a videographer!!
$sql = "SELECT * FROM PromoVideos ORDER BY Description";
$creditwrapperbefore = "";
$creditwrapperafter = "";
$creditinner = "";
$counter = 0;
$conn = dbConnect();
$result = $conn->query($sql) or die(mysqli_error($conn));
$numRows = $result->num_rows;
if ($numRows > 0) {
$creditwrapperbefore = "";
$creditwrapperafter = "";
$creditinner = "";
while ($row = $result->fetch_assoc()) {
$sandesc = addslashes($row['Description']);
$sancredit = addslashes($row['Credit']);
echo "
";
echo "

";
echo "
".$row['Description']."
";
if((strlen($row['Credit'])>0) || (strlen($row['CreditURL']) >0)){
if(strlen($row['CreditURL'])>0){
$creditwrapperbefore = "
";
$creditwrapperafter = "";
}
if(strlen($row['Credit'])>0){
$creditinner = $row['Credit'];
}else{
$creditinner = $row['CreditURL'];
}
echo "
Video Credits: ".$creditwrapperbefore.$creditinner.$creditwrapperafter."
";
}
echo "
\r\n";
$counter++;
}
echo "
";
}
?>