'common_information',
'where' => '', // load first record
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$common_informationRecord = @$common_informationRecords[0]; // get first record
// load records from 'home_page_background_images'
list($home_page_background_imagesRecords, $home_page_background_imagesMetaData) = getRecords(array(
'tableName' => 'home_page_background_images',
'loadUploads' => true,
'allowSearch' => false,
));
// load records
list($publcity_listingsRecords, $publcity_listingsMetaData) = getRecords(array(
'tableName' => 'publcity_listings',
));
// load records
list($media_typesRecords, $media_typesMetaData) = getRecords(array(
'tableName' => 'media_types',
));
// load records
list($specialty_groupRecords, $specialty_groupMetaData) = getRecords(array(
'tableName' => 'specialty_group',
));
// load records
list($sourceRecords, $sourceMetaData) = getRecords(array(
'tableName' => 'source',
));
?>
\n"; }
if (!@$_REQUEST['last_name']) { $errorsAndAlerts .= "Please enter a last_name
\n"; }
// if (!@$_REQUEST['media_type']) { $errorsAndAlerts .= "Please select a specialty group
\n"; }
if (!@$_REQUEST['specialty_group']) { $errorsAndAlerts .= "Please select a specialty group
\n"; }
if (!@$_REQUEST['source']) { $errorsAndAlerts .= "Please select a specialty group
\n"; }
if (!@$_REQUEST['email_address']) { $errorsAndAlerts .= "Please enter an email address
\n"; }
else if(!isValidEmail(@$_REQUEST['email_address'])) { $errorsAndAlerts .= "Please enter a valid email (example: user@example.com)
\n"; }
// check for duplicate email
$count = mysql_select_count_from('publicity_listings', "'".mysql_escape($_REQUEST['email_address'])."' IN (email_address)");
if ($count > 0 ) { $errorsAndAlerts .= "That Email Address already exists. \n";
$showSignupForm = true; }
// turn off strict mysql error checking for: STRICT_ALL_TABLES
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)
if (!$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}publcity_listings` SET
source = '".mysql_escape( $_REQUEST['source'] )."',
specialty_group = '".mysql_escape( $_REQUEST['specialty_group'] )."',
media_type = '".mysql_escape( $_REQUEST['media_type'] )."',
organization = '".mysql_escape( $_REQUEST['organization'] )."',
department = '".mysql_escape( $_REQUEST['department'] )."',
first_name = '".mysql_escape( $_REQUEST['first_name'] )."',
last_name = '".mysql_escape( $_REQUEST['last_name'] )."',
title = '".mysql_escape( $_REQUEST['title'] )."',
email_address = '".mysql_escape( $_REQUEST['email_address'] )."',
street_address = '".mysql_escape( $_REQUEST['street_address'] )."',
city = '".mysql_escape( $_REQUEST['city'] )."',
state = '".mysql_escape( $_REQUEST['state'] )."',
zip = '".mysql_escape( $_REQUEST['zip'] )."',
phone = '".mysql_escape( $_REQUEST['phone'] )."',
cell = '".mysql_escape( $_REQUEST['cell'] )."',
description = '".mysql_escape( $_REQUEST['description'] )."',
createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n");
$userNum = mysql_insert_id();
$_REQUEST = array(); // clear form values
$showSignupForm = false;
}
}
?>
Dance Spotlight - Publicity List
'); removed to show links
$text = $textOrHtml;
$words = preg_split("/\s+/", $text, $maxWords+1);
if (count($words) > $maxWords) { unset($words[$maxWords]); }
$output = join(' ', $words);
return $output;
}
?>
");
$words = preg_split("/\s+/", $text);
return count($words);
}
?>