Palmetto Dance Academy Videos

[insert_php]

echo “

“;
echo ““;
echo “

“;

echo “

The following videos are available for purchase. Click the Add to Cart button to pay by credit/debit card. To order by mail, send your check, name, and mailing address to: TADA! Media Services, 932 Fargo Street, Mauldin, S.C. 29662. When ordering by mail, please tell us the Studio Name, Performance Name, and Video #.

“;

mysqli_connect(“localhost”,”cp33751_thomas”,”AaZzUUur8B”);
mysqli_select_db($con,”cp33751_wp611″);
if ($con->connect_error) {
die(“Connection failed: ” . $con->connect_error);
}

global $wpdb;
$results = $wpdb->get_results( “select * from VIDEO_FOR_SALE where CLIENT_NAME LIKE ‘%Palmetto%’ ORDER BY PERFORMANCE_DATE DESC” );
if(!empty($results))
{
foreach($results as $row)
{
$id=$row->ID;
$client_name=$row->CLIENT_NAME;
$performance_name=$row->PERFORMANCE_NAME;
$performance_location=$row->PERFORMANCE_LOCATION;
$performance_date=$row->PERFORMANCE_DATE;
$discount_date=$row->PERFORMANCE_DATE + 31622400;
$video_filename=$row->VIDEO_FILENAME;
$logo_picture=$row->LOGO_PICTURE;
$price=$row->PRICE;
$video_id=$row->ID;
$discount=1;
$sale=””;
if ($discount_date
“;
}
else
{
echo “
“;
}

echo “Studio: ” . $client_name . “
“;
echo “Performance Name: ” . $performance_name . “
“;
echo “Performance Location: ” . $performance_location . “
“;
echo “Performance Date: ” . date(“F j, Y”,$performance_date) . “
“;
echo “Video #: ” . $video_id . “
“;

echo $sale . “Price: $” . number_format($price,2) . “
“;

$pp=”

“;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . ““;
$pp=$pp . “

“;

echo “
” . $pp . “
“;

echo “


“;
}
}

[/insert_php]