""){
$species=$otherspecies;
}
$month=date("F");
$subby=$_POST['subby'];
$subname=$_POST['subname'];
include "../mysql_connect_po.php";
$query = "INSERT INTO photocontest SET caption='$caption', subby='$subby',subname='$subname',description='$des',image='$image', month='$month',thumb='$thumb',type='fish', species='$species', frm='s3', subdate=CURDATE()";
$result=@mysql_query($query);
if ($result) {
echo(' Thanks for your item.');
mail('gsonntag@prairieoutdoors.com',$caption,$des,"From: fishingphotocontest@s3outdoors.com");
}
//get image id of newest entry
$query = "SELECT * FROM photocontest ORDER BY id";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)){
$imageid=$row['id'];
}
//add a rating of 3 to newest entry
$query = "INSERT INTO photocontestrating SET imageid='$imageid', r='3', month='$month', subdate=CURDATE()";
$result=@mysql_query($query);
// add details to campfire db table
$location=$_POST['location'];
$query = "INSERT INTO campfire SET date=CURDATE(), text='$des', location='$location', alttext='$caption', image='$image', timage='$thumb', category='fishing', species='$species', frm='s3', submitted_date=CURDATE()";
$result=@mysql_query($query);
if ($result) {
mail('gjs@s3outdoors.com',$caption,$des,"From: campfire@s3outdoors.com");
}
echo 'Thanks for your entry to the Fishing Photo contest.
See all entries.';
}else{
echo 'Invalid File Type. Please upload a gif or jpeg file.
';
}
}else{
if (isset($_POST['sendrating'])){
$rating=$_POST['rating'];
$imageid=$_POST['imageid'];
$month=date("F");
include "../mysql_connect_po.php";
$query = "INSERT INTO photocontestrating SET imageid='$imageid', r='$rating', month='$month', subdate=CURDATE()";
$result=@mysql_query($query);
if ($result) {
echo 'Thanks, the rating was saved.';
}else{
echo 'rating entry to db failed: '.mysql_error();
}
}
if ($_GET['form']=='yes'){
?>
Fishing Photo Contest
Fill out the form below and then click submit to enter the photo contest.
UPLOAD JPG OR JPEG FILES ONLY PLEASE