[RESOLVED] One HTML Form into TWO tables on mysql

[funkymonkey]

I need a specific code or a concrete example on how to put information from one html form into two seperate tables in mysql.

I know that this

$sql="INSERT INTO table1 VALUES ()
$sql="INSERT INTO table2 VALUES ()

This does not work, the data only shows up in the first table while the second table is blank.

I have a survey about cats and dogs, and I would like the responses about the dogs to go into the dogs table and the responses about cats to go into the cats table.

I simply want to know the code or be giving a concrete example on how to insert data into TWO seperate mysql forms.

Thanks in advance!

[bradgrafelman]

What's the actual code you tried? It doesn't matter if you have 1, 2, or 2000 tables - the process is still the same; form a SQL insert query, execute it, repeat for each table you want to populate.

[funkymonkey]

bradgrafelman;10982387 wrote:

What's the actual code you tried? It doesn't matter if you have 1, 2, or 2000 tables - the process is still the same; form a SQL insert query, execute it, repeat for each table you want to populate.

I'm not sure, but when I've been inserting data into one table I've just been using

$sql="INSERT INTO table VALUES ()

That method doesn't work for two tables. Do you know what method works for inserting data into two tables?

[bradgrafelman]

What "method" ? The only "method" you're talking about is assigning a string to a variable.

[funkymonkey]

bradgrafelman;10982389 wrote:

What "method" ? The only "method" you're talking about is assigning a string to a variable.

Well, what strings do you suggest I assign to variables that can put two different sets of data into two different tables? Do you have an example of what I should do?

[bradgrafelman]

I really don't understand where your confusion comes from....

Run this code and you've inserted data into one table:

$sql = "INSERT INTO table1 VALUES ('value1')";
mysql_query($sql);

Run this code and you've inserted data into two tables:

$sql = "INSERT INTO table1 VALUES ('value1')";
mysql_query($sql);

$sql = "INSERT INTO table2 VALUES ('value2')";
mysql_query($sql);

Run this code and you've inserted data into three tables:

$sql = "INSERT INTO table1 VALUES ('value1')";
mysql_query($sql);

$sql = "INSERT INTO table2 VALUES ('value2')";
mysql_query($sql);

$sql = "INSERT INTO table3 VALUES ('value3')";
mysql_query($sql);

Bonus points if you can figure out what inserting into four tables might look like...

[funkymonkey]

OH okay thank you very much, I really appreciate it! I am new to this so I am trying to grasp basic concepts. Thanks again, I shall try it and see if it works successfully.

[funkymonkey]

I have tried the code above, and it works, I get a "successful" echo, BUT there is no data entry in any of mysql tables.

Why isn't anything being shown in the mysql table?

[bradgrafelman]

Are you checking to make sure that [man]mysql_query/man didn't return boolean FALSE and, if it does, outputting or logging the error message returned by the MySQL server?

[funkymonkey]

bradgrafelman;10983859 wrote:

Are you checking to make sure that [man]mysql_query/man didn't return boolean FALSE and, if it does, outputting or logging the error message returned by the MySQL server?

How can I check that? I'm using phpmyadmin by the way.

[NogDog]

ini_set('display_errors', true); // set to false in production mode
error_reporting(E_ALL);
$sql = "INSERT INTO `table_name` (`col_1`, `col_2`) VALUES ('$val_1', '$val_2')";
$result = mysql_query($sql);
if($result == false) {
   user_error(mysql_error()."<br />\n$sql"); // shows error message and actual query
   exit("Database error");
}

[psuplat]

If this doesn't work for you or maybe you have hard time understanding the whole thing just paste in the whole code or attach the file with code (just save it as txt).

I could go line by line and explain you what does what and what it returns

[funkymonkey]

I am going to post the code here

<?php
  $con = mysql_connect("localhost","myusername","mypassword");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

mysql_select_db("mydatabase", $con);

$arraybodytype = array($_POST['partnerbodytype']);
$parnterbodytype= implode(",",$arraybodytype);
$arrayethnicity = array($_POST['partnerethnicity']);
$partnerethnicity= implode(",",$arrayethnicity);
$arrayage= array($_POST['partnersage']);
$partnersage= implode(",",$arrayage);
$arraygender= array($_POST['partnersgender']);
$partnersgender= implode(",",$arraygender);
$arrayorientation= array($_POST['partnersorientation']);
$partnersorientation= implode(",",$arrayorientation);
$arraypresentation= array($_POST['partnerspresentation']);
$partnerspresentation= implode(",",$arraypresentation);


$sql= "INSERT INTO `Client_Info` (Last_Name, First_Name, Middle_Name, Date_of_Birth, Street_Address, City, State, Zip_Code, Phone_Number, Email, Preferred_Contact, Gender, Sexual_Orientation, Race_Ethnicity, 
Gender_Presentation, Body_Type, Height, Weight, Felony, Partners_Gender, Partners_Sexual_Orientation, 
Partners_Race_Ethnicity, Partners_Gender_Presentation, Partners_Body_Type, Partners_Age, Partners_Height, Turn_On, Turn_Off, Celebrity_Crush, First_thing_you_notice, Deal_Breaker)
VALUES ('$_POST[lastname]','$_POST[firstname]','$_POST[middlename]','$_POST[birthdate]',
'$_POST[streetaddress]','$_POST[city],'$_POST[state]','$_POST[zip]','$_POST[phone]',
'$_POST[email]','$_POST[contactmethod]','$_POST[yourgender]','$_POST[yourorientation]',
'$_POST[ethnicity]','$_POST[yourpresentation]','$_POST[bodytype]','$_POST[height]',
'$_POST[weight]','$_POST[felony]','$partnersgender','$partnersorientation',
'$partnerethnicity','$partnerspresentation','$partnerbodytype',
'$partnersage','$_POST[partnersheight]','$_POST[turnon]','$_POST[turnoff]',
'$_POST[celebritycrush]','$_POST[firstthing]','$_POST[dealbreaker]')";


$sql= "INSERT INTO `Lifestyles` (Employment, Occupation, Education_Achieved, Children, Pets, Drink, Smoke, Socializing, Achieving_your_goals_in_life, Working_career, Keeping_physically_fit, Maintaining_a_healthy_lifestyle, Making_new_riends, Dining_out, Traveling, Partners_level_of_education, Partners_Smoke, Partners_Drink, Partners_Employment, Partners_Religious_beliefs) 
VALUES ('$_POST[employed]','$_POST[occupation]','$_POST[educationlevel]','$_POST[yourchildren]',
'$_POST[yourpets]','$_POST[yourdrink]','$_POST[yoursmoke]','$_POST[socializing]',
'$_POST[achievinggoals]','$_POST[workingcareer]','$_POST[keepingfit]','$_POST[healthylifestyle]',
'$_POST[newfriends]','$_POST[diningout]','$_POST[traveling]','$_POST[partnerseducation]',
'$_POST[partnersmokes]','$_POST[partnerdrinks]','$_POST[partnersemployment]','$_POST[partnersfaith]')";



$sql= "INSERT INTO `Values` (I_am_looking_for_a_long_term_relationship, A_serious_relationship_needs_to_be_exclusive_monogamous, Being_monogamous_helps_build_trust_and_intimacy, 
Being_monogamous_causes_relationships_to_get_boring_over_time) 
VALUES ('$_POST[longterm]','$_POST[seriousexclusive]','$_POST[monogamousintimacy]',
'$_POST[monogamousboring]')";


$sql= "INSERT INTO `Emotional` 
(It_is_difficult_for_me_to_let_people_get_emotionally_close_to_me, I_sometimes_find_it_difficult_to_trust_people, Try_not_to_dwell_on_an_issue_once_it_is_resolved, Show_that_my_partner_needs_are_important, The_friendship_between_me_and_my_partner, Being_able_to_make_compromises) 
VALUES ('$_POST[longterm]','$_POST[difficulttrust]','$_POST[dwellonissue]','$_POST[partnerneeds]',
'$_POST[friendshippartner]','$_POST[makecompromises]')";


$sql= "INSERT INTO `Communication` (When_I_get_romantically_involved_I_tell_my_partner_everything,  Try_to_accommodate_the_other_person's_position, Try_to_resolve_conflict_quickly, Being_able_to_discuss_with_my_parnter_how_I_am_feeling, Having_my_parnter_be_open_with_me_about_how_she/he_feels) 
VALUES ('$_POST[telleverything]','$_POST[accomodatepartner]','$_POST[resolveconflict]',
'$_POST[discussmyfeelings]')";


$sql= "INSERT INTO `Romance` (Engage_in_public_displays_of_affection, Provide_physical_intimacy_and_affection_to_my_partner, Public_displays_of_affection, Doing_special_things_to_let_my_parnter_know_how_important_heshe, Enjoying_physical_closeness_with_my_partner, Spending_quality_time_with_my_partner, 
Plan_the_date, Pay_for_dinner, Pick_up_your_date, Creating_romance_in_a_relationship, 
Sexual_Activity) 
VALUES ('$_POST[engagepda]','$_POST[physicalintimacy]',
'$_POST[importantpda]','$_POST[specialthings]','$_POST[physicalcloseness]',
'$_POST[qualitytime]','$_POST[planthedate]','$_POST[payfordinner]','$_POST[drivetodate]',
'$_POST[creatingromance]','$_POST[sexualactivity]')";


$arraythreebest= array('$_POST[threeyoudobest]');
$arraythreeyoudobest= implode(",",$arraythreebest);

$sql= "INSERT INTO `Activity_Skills` (Three_You_Do_Best) VALUES ('$arraythreeyoudobest')";


$sql= "INSERT INTO `Personality` (EIQ1, EIQ2, EIQ3, EIQ4, EIQ5, SN1Q, SN2Q, SN3Q, SN4Q, SN5Q, 
TF1Q, TF2Q, TF3Q, TF4Q, TH5Q, JP1Q, JP2Q, JP3Q, JP4Q, JP5Q) VALUES ('$_POST[eiq1]',
'$_POST[eiq2]','$_POST[eiq3]','$_POST[eiq3]','$_POST[eiq4]','$_POST[eiq5]','$_POST[sn1q]',
'$_POST[sn2q]','$_POST[sn3q]','$_POST[sn4q]','$_POST[sn5q]','$_POST[jp1q]','$_POST[jp2q]',
'$_POST[jp3q]','$_POST[jp4q]','$_POST[jp5q]')";


$sql= "INSERT INTO `Interests` (Making_art_and_culture_an_ongoing_part_of_my_life, Live_music, 
Movies, Listening_to_music, Watching_TV, Parties, Board_game, Art, Shopping, Friendship) 
VALUES ('$_POST[artandculture]','$_POST[livemusic]','$_POST[movies]','$_POST[listeningtomusic]',
'$_POST[watchingtv]','$_POST[reading]','$_POST[parties]','$_POST[boardgames]','$_POST[art]',
'$_POST[shopping]','$_POST[friendship]')";


$arrayfriendsdescriptions= array('$_POST[friendsdescriptions]');
$friendsdescriptions= implode(",",$arrayfriendsdescriptions);
$arrayidealpartner= array('$_POST[idealpartner]');
$idealpartner= implode(",",$arrayidealpartner);


$sql= "INSERT INTO `Word_Descriptions` (Worst_Day1, Worst_Day2, Worst_Day3, 
Friends_Description1, Ideal_Partner1) VALUES ('$_POST[worstday1]',
'$_POST[worstday2]','$_POST[worstday3]','$friendsdescriptions','$idealpartner')";


if (!mysql_query($sql,$con))
   {
   die('Error: ' . mysql_error());
   }
 echo successful;

exit();
mysql_close($con)
?>

How can I incorporate the above code you gave me?

[psuplat]

Whoa, firstly I get slightly confused by the whole assigning of the $POST to array (you do know that $POST is an array and you basically put elements of one array into another), then again I don't know how your form looks like and what you want to achieve. For the remainder of the code:

you overwrite the variable $sql with new values every time you create a new select statement, so by the time you get to the if (!mysql_query($sql,$con)) piece of code, you $sql has the last query in it, and it will execute only that query (in your case "INSERT INTO Word_Descriptions)

So first personal piece of advice: if you have more than 1 query in code name then differently i.e. $sql1, $sql2 or $sqlClienInfo, $sqlLifestyles, you get the idea. That's how I do it and it helps a lot specially if your code get really big

Next thing you have to do is submit and check result of the query so in your case it wil look like that:

$sql= "INSERT INTO `Client_Info` (Last_Name, First_Name, Middle_Name, Date_of_Birth, Street_Address, City, State, Zip_Code, Phone_Number, Email, Preferred_Contact, Gender, Sexual_Orientation, Race_Ethnicity,
Gender_Presentation, Body_Type, Height, Weight, Felony, Partners_Gender, Partners_Sexual_Orientation,
Partners_Race_Ethnicity, Partners_Gender_Presentation, Partners_Body_Type, Partners_Age, Partners_Height, Turn_On, Turn_Off, Celebrity_Crush, First_thing_you_notice, Deal_Breaker) 
VALUES ('$_POST[lastname]','$_POST[firstname]','$_POST[middlename]','$_POST[birthdate]', 
'$_POST[streetaddress]','$_POST[city],'$_POST[state]','$_POST[zip]','$_POST[phone]', 
'$_POST[email]','$_POST[contactmethod]','$_POST[yourgender]','$_POST[yourorientation]', 
'$_POST[ethnicity]','$_POST[yourpresentation]','$_POST[bodytype]','$_POST[height]', 
'$_POST[weight]','$_POST[felony]','$partnersgender','$partnersorientation', 
'$partnerethnicity','$partnerspresentation','$partnerbodytype', 
'$partnersage','$_POST[partnersheight]','$_POST[turnon]','$_POST[turnoff]', 
'$_POST[celebritycrush]','$_POST[firstthing]','$_POST[dealbreaker]')"; 

// run query Client_Info and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
           //if you want you can do echo $sql at this point and you will see on screen
           //how the submitted query looks like (this can help localise problem if one is in the statement)
   } else {
      echo 'Query Client_Info was successful<br>'; 
  }

$sql= "INSERT INTO `Lifestyles` (Employment, Occupation, Education_Achieved, Children, Pets, Drink, Smoke, Socializing, Achieving_your_goals_in_life, Working_career, Keeping_physically_fit, Maintaining_a_healthy_lifestyle, Making_new_riends, Dining_out, Traveling, Partners_level_of_education, Partners_Smoke, Partners_Drink, Partners_Employment, Partners_Religious_beliefs)
VALUES ('$_POST[employed]','$_POST[occupation]','$_POST[educationlevel]','$_POST[yourchildren]', 
'$_POST[yourpets]','$_POST[yourdrink]','$_POST[yoursmoke]','$_POST[socializing]', 
'$_POST[achievinggoals]','$_POST[workingcareer]','$_POST[keepingfit]','$_POST[healthylifestyle]', 
'$_POST[newfriends]','$_POST[diningout]','$_POST[traveling]','$_POST[partnerseducation]', 
'$_POST[partnersmokes]','$_POST[partnerdrinks]','$_POST[partnersemployment]','$_POST[partnersfaith]')"; 

// run query Lifestyles and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Lifestyles was successful<br>'; 
  }


$sql= "INSERT INTO `Values` (I_am_looking_for_a_long_term_relationship, A_serious_relationship_needs_to_be_exclusive_monogamous, Being_monogamous_helps_build_trust_and_intimacy,
Being_monogamous_causes_relationships_to_get_boring_over_time) 
VALUES ('$_POST[longterm]','$_POST[seriousexclusive]','$_POST[monogamousintimacy]', 
'$_POST[monogamousboring]')"; 

// run query Values and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Values was successful<br>'; 
  }

$sql= "INSERT INTO `Emotional` 
(It_is_difficult_for_me_to_let_people_get_emotionally_close_to_me, I_sometimes_find_it_difficult_to_trust_people, Try_not_to_dwell_on_an_issue_once_it_is_resolved, Show_that_my_partner_needs_are_important, The_friendship_between_me_and_my_partner, Being_able_to_make_compromises)
VALUES ('$_POST[longterm]','$_POST[difficulttrust]','$_POST[dwellonissue]','$_POST[partnerneeds]', 
'$_POST[friendshippartner]','$_POST[makecompromises]')"; 

// run query Emotional and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Emotional was successful<br>'; 
  }

$sql= "INSERT INTO `Communication` (When_I_get_romantically_involved_I_tell_my_partner_everything,  Try_to_accommodate_the_other_person's_position, Try_to_resolve_conflict_quickly, Being_able_to_discuss_with_my_parnter_how_I_am_feeling, Having_my_parnter_be_open_with_me_about_how_she/he_feels)
VALUES ('$_POST[telleverything]','$_POST[accomodatepartner]','$_POST[resolveconflict]', 
'$_POST[discussmyfeelings]')"; 

// run query Communiction and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Communication was successful<br>'; 
  }

$sql= "INSERT INTO `Romance` (Engage_in_public_displays_of_affection, Provide_physical_intimacy_and_affection_to_my_partner, Public_displays_of_affection, Doing_special_things_to_let_my_parnter_know_how_important_heshe, Enjoying_physical_closeness_with_my_partner, Spending_quality_time_with_my_partner,
Plan_the_date, Pay_for_dinner, Pick_up_your_date, Creating_romance_in_a_relationship, 
Sexual_Activity) 
VALUES ('$_POST[engagepda]','$_POST[physicalintimacy]', 
'$_POST[importantpda]','$_POST[specialthings]','$_POST[physicalcloseness]', 
'$_POST[qualitytime]','$_POST[planthedate]','$_POST[payfordinner]','$_POST[drivetodate]', 
'$_POST[creatingromance]','$_POST[sexualactivity]')"; 

// run query Romance and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Romance was successful<br>'; 
  }

$arraythreebest= array('$_POST[threeyoudobest]'); 
$arraythreeyoudobest= implode(",",$arraythreebest); 

$sql= "INSERT INTO `Activity_Skills` (Three_You_Do_Best) VALUES ('$arraythreeyoudobest')"; 

// run query Activity_Skils and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Activity_Skills was successful<br>'; 
  } 

$sql= "INSERT INTO `Personality` (EIQ1, EIQ2, EIQ3, EIQ4, EIQ5, SN1Q, SN2Q, SN3Q, SN4Q, SN5Q, 
TF1Q, TF2Q, TF3Q, TF4Q, TH5Q, JP1Q, JP2Q, JP3Q, JP4Q, JP5Q) VALUES ('$_POST[eiq1]', 
'$_POST[eiq2]','$_POST[eiq3]','$_POST[eiq3]','$_POST[eiq4]','$_POST[eiq5]','$_POST[sn1q]', 
'$_POST[sn2q]','$_POST[sn3q]','$_POST[sn4q]','$_POST[sn5q]','$_POST[jp1q]','$_POST[jp2q]', 
'$_POST[jp3q]','$_POST[jp4q]','$_POST[jp5q]')"; 

// run query Personality and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Personality was successful<br>'; 
  }

$sql= "INSERT INTO `Interests` (Making_art_and_culture_an_ongoing_part_of_my_life, Live_music, 
Movies, Listening_to_music, Watching_TV, Parties, Board_game, Art, Shopping, Friendship) 
VALUES ('$_POST[artandculture]','$_POST[livemusic]','$_POST[movies]','$_POST[listeningtomusic]', 
'$_POST[watchingtv]','$_POST[reading]','$_POST[parties]','$_POST[boardgames]','$_POST[art]', 
'$_POST[shopping]','$_POST[friendship]')"; 

// run query Interests and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Interests was successful<br>'; 
  }

$arrayfriendsdescriptions= array('$_POST[friendsdescriptions]'); 
$friendsdescriptions= implode(",",$arrayfriendsdescriptions); 
$arrayidealpartner= array('$_POST[idealpartner]'); 
$idealpartner= implode(",",$arrayidealpartner); 


$sql= "INSERT INTO `Word_Descriptions` (Worst_Day1, Worst_Day2, Worst_Day3, 
Friends_Description1, Ideal_Partner1) VALUES ('$_POST[worstday1]', 
'$_POST[worstday2]','$_POST[worstday3]','$friendsdescriptions','$idealpartner')"; 

// run query Word_Descriptions and check result
if (!mysql_query($sql,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else {
      echo 'Query Word_Descriptions was successful<br>'; 
  }

hope this helps

[funkymonkey]

Thank you! 🙂

Now I am facing another error:

Parse error: syntax error, unexpected $end

Can you tell me what this means?

<?php
  $con = mysql_connect("localhost","myusername","mypassword");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

mysql_select_db("mydatabse", $con);

$arraybodytype = array($_POST['partnerbodytype']);
$parnterbodytype= implode(",",$arraybodytype);
$arrayethnicity = array($_POST['partnerethnicity']);
$partnerethnicity= implode(",",$arrayethnicity);
$arrayage= array($_POST['partnersage']);
$partnersage= implode(",",$arrayage);
$arraygender= array($_POST['partnersgender']);
$partnersgender= implode(",",$arraygender);
$arrayorientation= array($_POST['partnersorientation']);
$partnersorientation= implode(",",$arrayorientation);
$arraypresentation= array($_POST['partnerspresentation']);
$partnerspresentation= implode(",",$arraypresentation);


$sqlClientInfo= "INSERT INTO `Client_Info` (Last_Name, First_Name, Middle_Name, Date_of_Birth, Street_Address, City, State, Zip_Code, Phone_Number, Email, Preferred_Contact, Gender, Sexual_Orientation, Race_Ethnicity, 
Gender_Presentation, Body_Type, Height, Weight, Felony, Partners_Gender, Partners_Sexual_Orientation, 
Partners_Race_Ethnicity, Partners_Gender_Presentation, Partners_Body_Type, Partners_Age, Partners_Height, Turn_On, Turn_Off, Celebrity_Crush, First_thing_you_notice, Deal_Breaker)
VALUES ('$_POST[lastname]','$_POST[firstname]','$_POST[middlename]','$_POST[birthdate]',
'$_POST[streetaddress]','$_POST[city],'$_POST[state]','$_POST[zip]','$_POST[phone]',
'$_POST[email]','$_POST[contactmethod]','$_POST[yourgender]','$_POST[yourorientation]',
'$_POST[ethnicity]','$_POST[yourpresentation]','$_POST[bodytype]','$_POST[height]',
'$_POST[weight]','$_POST[felony]','$partnersgender','$partnersorientation',
'$partnerethnicity','$partnerspresentation','$partnerbodytype',
'$partnersage','$_POST[partnersheight]','$_POST[turnon]','$_POST[turnoff]',
'$_POST[celebritycrush]','$_POST[firstthing]','$_POST[dealbreaker]')";

// run query Client_Info and check result 
if (!mysql_query($sqlClientInfo,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Client_Info was successful<br>'; 
  } 



$sqlLifestyles= "INSERT INTO `Lifestyles` (Employment, Occupation, Education_Achieved, Children, Pets, Drink, Smoke, Socializing, Achieving_your_goals_in_life, Working_career, Keeping_physically_fit, Maintaining_a_healthy_lifestyle, Making_new_riends, Dining_out, Traveling, Partners_level_of_education, Partners_Smoke, Partners_Drink, Partners_Employment, Partners_Religious_beliefs) 
VALUES ('$_POST[employed]','$_POST[occupation]','$_POST[educationlevel]','$_POST[yourchildren]',
'$_POST[yourpets]','$_POST[yourdrink]','$_POST[yoursmoke]','$_POST[socializing]',
'$_POST[achievinggoals]','$_POST[workingcareer]','$_POST[keepingfit]','$_POST[healthylifestyle]',
'$_POST[newfriends]','$_POST[diningout]','$_POST[traveling]','$_POST[partnerseducation]',
'$_POST[partnersmokes]','$_POST[partnerdrinks]','$_POST[partnersemployment]','$_POST[partnersfaith]')";

// run query Lifestyles and check result 
if (!mysql_query($sqlLifestyles,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Lifestyles was successful<br>'; 
  } 


$sqlValues= "INSERT INTO `Values` (I_am_looking_for_a_long_term_relationship, A_serious_relationship_needs_to_be_exclusive_monogamous, Being_monogamous_helps_build_trust_and_intimacy, 
Being_monogamous_causes_relationships_to_get_boring_over_time) 
VALUES ('$_POST[longterm]','$_POST[seriousexclusive]','$_POST[monogamousintimacy]',
'$_POST[monogamousboring]')";
// run query Values and check result 
if (!mysql_query($sqlValues,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Values was successful<br>'; 
  } 



$sqlEmotional= "INSERT INTO `Emotional` 
(It_is_difficult_for_me_to_let_people_get_emotionally_close_to_me, I_sometimes_find_it_difficult_to_trust_people, Try_not_to_dwell_on_an_issue_once_it_is_resolved, Show_that_my_partner_needs_are_important, The_friendship_between_me_and_my_partner, Being_able_to_make_compromises) 
VALUES ('$_POST[longterm]','$_POST[difficulttrust]','$_POST[dwellonissue]','$_POST[partnerneeds]',
'$_POST[friendshippartner]','$_POST[makecompromises]')";

// run query Emotional and check result 
if (!mysql_query($sqlEmotional,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Emotional was successful<br>'; 


$sqlCommunication= "INSERT INTO `Communication` (When_I_get_romantically_involved_I_tell_my_partner_everything,  Try_to_accommodate_the_other_person's_position, Try_to_resolve_conflict_quickly, Being_able_to_discuss_with_my_parnter_how_I_am_feeling, Having_my_parnter_be_open_with_me_about_how_she/he_feels) 
VALUES ('$_POST[telleverything]','$_POST[accomodatepartner]','$_POST[resolveconflict]',
'$_POST[discussmyfeelings]')";

// run query Communiction and check result 
if (!mysql_query($sqlCommunication,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Communication was successful<br>'; 
  }

$sqlRomance= "INSERT INTO `Romance` (Engage_in_public_displays_of_affection, Provide_physical_intimacy_and_affection_to_my_partner, Public_displays_of_affection, Doing_special_things_to_let_my_parnter_know_how_important_heshe, Enjoying_physical_closeness_with_my_partner, Spending_quality_time_with_my_partner, 
Plan_the_date, Pay_for_dinner, Pick_up_your_date, Creating_romance_in_a_relationship, 
Sexual_Activity) 
VALUES ('$_POST[engagepda]','$_POST[physicalintimacy]',
'$_POST[importantpda]','$_POST[specialthings]','$_POST[physicalcloseness]',
'$_POST[qualitytime]','$_POST[planthedate]','$_POST[payfordinner]','$_POST[drivetodate]',
'$_POST[creatingromance]','$_POST[sexualactivity]')";

// run query Romance and check result 
if (!mysql_query($sqlRomance,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Romance was successful<br>'; 
  } 

$arraythreebest= array('$_POST[threeyoudobest]');
$arraythreeyoudobest= implode(",",$arraythreebest);

$sqlActivitySkills= "INSERT INTO `Activity_Skills` (Three_You_Do_Best) VALUES ('$arraythreeyoudobest')";

// run query Activity_Skils and check result 
if (!mysql_query($sqlActivitySkills,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Activity_Skills was successful<br>'; 
  } 


$sqlPersonality= "INSERT INTO `Personality` (EIQ1, EIQ2, EIQ3, EIQ4, EIQ5, SN1Q, SN2Q, SN3Q, SN4Q, SN5Q, 
TF1Q, TF2Q, TF3Q, TF4Q, TH5Q, JP1Q, JP2Q, JP3Q, JP4Q, JP5Q) VALUES ('$_POST[eiq1]',
'$_POST[eiq2]','$_POST[eiq3]','$_POST[eiq3]','$_POST[eiq4]','$_POST[eiq5]','$_POST[sn1q]',
'$_POST[sn2q]','$_POST[sn3q]','$_POST[sn4q]','$_POST[sn5q]','$_POST[jp1q]','$_POST[jp2q]',
'$_POST[jp3q]','$_POST[jp4q]','$_POST[jp5q]')";

// run query Personality and check result 
if (!mysql_query($sqlPersonality,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Personality was successful<br>'; 
  } 


$sql= "INSERT INTO `Interests` (Making_art_and_culture_an_ongoing_part_of_my_life, Live_music, 
Movies, Listening_to_music, Watching_TV, Parties, Board_game, Art, Shopping, Friendship) 
VALUES ('$_POST[artandculture]','$_POST[livemusic]','$_POST[movies]','$_POST[listeningtomusic]',
'$_POST[watchingtv]','$_POST[reading]','$_POST[parties]','$_POST[boardgames]','$_POST[art]',
'$_POST[shopping]','$_POST[friendship]')";

// run query Interests and check result 
if (!mysql_query($sqlInterests,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Interests was successful<br>'; 
  } 

$arrayfriendsdescriptions= array('$_POST[friendsdescriptions]');
$friendsdescriptions= implode(",",$arrayfriendsdescriptions);
$arrayidealpartner= array('$_POST[idealpartner]');
$idealpartner= implode(",",$arrayidealpartner);


$sql= "INSERT INTO `Word_Descriptions` (Worst_Day1, Worst_Day2, Worst_Day3, 
Friends_Description1, Ideal_Partner1) VALUES ('$_POST[worstday1]',
'$_POST[worstday2]','$_POST[worstday3]','$friendsdescriptions','$idealpartner')";

// run query Word_Descriptions and check result 
if (!mysql_query($sqlWordDescriptions,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Word_Descriptions was successful<br>'; 
   } 


exit();
mysql_close($con)
?>

[psuplat]

it pretty much means that you are missing an end of line character ( ; ) or have too many or not enough closing brackets ( } ). Does it say any more, like on which line for example?

[psuplat]

Found it. My mistake.

I you look at the code, where you define query (INSERT INTO Emotional), the piece of code I inserted below to execute the query and check for results is missing a closing }.

At the moment is:

// run query Emotional and check result 
if (!mysql_query($sqlEmotional,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Emotional was successful<br>';

while it should be:

// run query Emotional and check result 
if (!mysql_query($sqlEmotional,$con)) 
   { 
     die('Error: ' . mysql_error()); 
   } else { 
      echo 'Query Emotional was successful<br>';
   }

[funkymonkey]

Thank you, I have found the same problem.

Now I am puzzled, I am receiving another error once I process the html form.

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0','','', '','','','0', '','0','','', '','','', '','','','', '','','')' at line 5

Where do i go to solve this problem? the html code for the html form, or the php code for the mysql tables?

[psuplat]

i thought would come, it's probably caused by all those arrays you create from Post at the beginning

Can i see the code of your html file with the form, and also the definitions of your mysql table client info (what fields are numbers, text, dates, etc)

[funkymonkey]

Unfortunately, my html file is too large to be uploaded as an attachment.

Would you mind explaining to me where the error stems from, and ways I can fix it?