[RESOLVED] Connecting a survey to a db

hoogeebear

Hi,

Im having trouble connecting a simple survey I created to a db. Im not even sure if im going about it correctly. It only consists of 3 questions. It is for a prototype that I need to submit next week! Anyone got any idea how I can connect this to a database named survey. I have a table called onlinesurvey created with the appropiate fields also.? My knowledge of php is very limited as I am only new to it.

<html>
<head>My Survey </head>
<form action = "surveyconnect.php" method = "post">

<table border = "1">
<tr>
  <td>What gender are you?</td>
  <td colspan = "5"><input type = "radio" name = "gender" value= "male">Male
  |  <input type = "radio" name = "gender" value= "female">Female</td>
</tr>

<tr>
  <td> Which of these are your favourite colors? </td>
  <td colspan = "5"><input type = "radio" name = "color" value= "blue">Blue
  |  <input type = "radio" name = "color" value= "white">White
  |  <input type = "radio" name = "color" value= "Green">Green

<tr>
 <td>How Happy are you?</td>
 <td>input type = "radio" name = "personability" value = "0" />0-Not Very</td>
 <td>input type = "radio" name = "personability" value = "1" />1</td>
 <td>input type = "radio" name = "personability" value = "2" />2</td>
 <td>input type = "radio" name = "personability" value = "3" />3</td>
 <td>input type = "radio" name = "personability" value = "0" />4- Very</td> 
</tr>

</table><br />
<input type = "submit" value = "submit" name = "submit" />
</form>
</body>

</html>

Haddman

Maybe we could see some PHP code?

Also you forgot to put the greater then symbol on first input in the last question

hoogeebear

Im very sorry, I forget to include my code! Here is my php code.

<?PHP

require "db_survey.php";

$link = mysql_connect( $db_host, $db_username, $db_password ); // connection to database

if ( !$link )

exit ( "Database error: " . mysql_error() );

mysql_select_db ( $db_name, $link ); // selects database name

{

$gender = $_POST ['gender'];
$relationship = $_POST ['relationship'];
$personability = $_POST ['personability'];

$result = mysql_query( "INSERT INTO onlinesurvey (gender, relationship, personability,) VALUES('$gender', '$relationship', '$personability')", $link ); // insert post into db

if( !$result )
    exit ( "Query failed: " . mysql_error() );

Here isthe error i recieve when i run this code, I do not know why its telling me that theend php tag is unexpected?

Parse error: syntax error, unexpected $end in C:\Program Files\XAMP\xampp\htdocs\john\surveyconnect.php.php on line 25

Kudose

You have a rouge { after mysql_select_db

hoogeebear

Thank you! Changing this gives me another error. Any ideas?

Query failed: 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 ') VALUES('Male', 'Lecturer', '0')' at line 1

Kudose

You have an extra comma after personability

INSERT INTO onlinesurvey (gender, relationship, personability,) VALUES

hoogeebear

Hi,

Thanks soooo much! I really appreciate that and i feel like a twat for not seeing them silly errors! Thanks again dude....