-------ok this is my script…and my actionscript--------
<?php
$venuename = $_POST[‘venuename’];
$email = $_POST[‘email’];
$website = $_POST[‘website’];
$phonenumber = $_POST[‘phonenumber’];
$areacode = $_POST[‘areacode’];
$address = $_POST[‘address’];
$city = $_POST[‘city’];
$state = $_POST[‘state’];
$zipcode = $_POST[‘zipcode’];
$contact = $_POST[‘contact’];
$inputclubtype = $_POST[‘clubtype’];
$inputmusictype = $_POST[‘musictype’];
$inputcrowd = $_POST[‘crowd’];
$inputdresscode = $_POST[‘dresscode’];
$comments = $_POST[‘comments’];
$conn = mysql_connect(“localhost”, “nigolmvc_nigolmv”, “******”);
mysql_select_db (“nigolmvc_nightspotz”, $conn);
$result = mysql_query(“INSERT into venues ( venuename, email, website, phonenumber, areacode, address, city, state, zipcode, contact, clubtype, musictype, crowd, dresscode, comment) VALUES(’$venuename’, ‘$email’, ‘$website’, ‘$phonenumber’, ‘$areacode’, ‘$address’, ‘$city’, ‘$state’, ‘$zipCode’, ‘$contact’, ‘$inputclubtype’, ‘$inputmusictype’, ‘$inputcrowd’, ‘$inputdresscode’, ‘$comment’)”);
if(!mysql_query($query,$conn))
{
echo mysql_error();
exit;
}
?>
----the actionscript is attached to frame not the button-----
submitBtn.onPress = function(){
if(venuename.text!="" && address.text!="" && email.text!="" && city.text!="" && website.text!="" && zipcode.text!="" contact.text!="" areacode.text!="" phonenumber.text!="" comments.text!=""){
myData = new LoadVars();
myData.venuename = venuename.text;
myData.address = address.text;
myData.email = email.text;
myData.city = city.text;
myData.website = website.text;
myData.zipcode = zipcode.text;
myData.contact = contact.text;
myData.areacode = areacode.text;
myData.phonenumber = phonenumber.text;
myData.comments = comments.text;
myData.sendAndLoad(“advertise.php”, myData, “POST”);
gotoAndPlay(113);
venuename = “”;
address = “”;
email = “”;
city = “”;
website = “”;
zipcode = “”;
contact = “”;
areacode = “”;
phonenumber = “”;
comments = “”;
Emailstatus = “”;
}else{
statusBox.text = “Fill out all required fields!”;
}
}
----this is the error im getting from from actiocscript------
Error Scene=Scene 1, layer=form, frame=116:Line 15: ‘)’ expected
if(venuename.text!="" && address.text!="" && email.text!="" && city.text!="" && website.text!="" && zipcode.text!="" contact.text!="" areacode.text!="" phonenumber.text!="" comments.text!=""){
Error Scene=Scene 1, layer=form, frame=116:Line 40: Unexpected ‘}’ encountered
}else{
Total ActionScript Errors: 2 Reported Errors: 2
DONT KNOW WHAT THIS MEANS…
