Adding information into database with drop down selection

[tang28]

Hey i am having problems with inserting my data from a drop down into mysql database, basically what i am trying to do is to insert score, place, memberID, event ID INTO a table called "results"

 

This table has 4 colums! Score, Place, EventID, MemberID.

 

what i am trying to achieve is to insert data based on the eventID clicked on given by the query string: Assignment2/RecordResults.php?event=3

 

but i am getting this error: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') WHERE (eventID= NULL)' at line 1 

 

here is the code:

 

 

	  	$pdo = new PDO('mysql:host=127.0.0.1;dbname=clubresults', 'root', '');

	$result = $pdo->query ('SELECT MemberID, Firstname, Surname FROM members');

		echo '<select name="memberID">';

		foreach ($result as $member)
		{
			echo "<option value=\"{$member['MemberID']}\">{$member['Firstname']} {$member['Surname']}</option>";	
		}
			echo '</select>';

    $errors = array();
    
      $eventID= $_GET['event'];
      echo $eventID;
      
	if (isset($_POST['score']))
		{
            require 'validate.inc';

		    validateScore($errors, $_POST, 'score');
		    validatePlace($errors, $_POST, 'place');

			if ($errors)
				{ 
				  	require 'RecordResultsForm.inc';
			  	}
					else
				{				

				$pdo = new PDO('mysql:host=127.0.0.1;dbname=clubresults', 'root', '');

				$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
				try 
				{


				$stmt =$pdo->prepare ('INSERT INTO results (Score, Place, MemberID) VALUE (:score, :place, :memberID,) WHERE (eventID= :event)');



		       	$stmt -> bindValue (':score',$_POST['score']);
		       	$stmt -> bindValue (':place',$_POST['place']);
	       		$stmt -> bindValue (':memberID',$_POST['memberID']);
	       		$stmt -> bindValue (':event',$_GET['event']);
    				$stmt ->execute();
				}
		        	catch (PDOException $e)
					{
			        echo $e->getMessage();
				}       
         			    
         			    require 'RecordResultsForm.inc';
         			    echo "<br/>";
      					echo 'Form submitted successfully with no errors!';
			    }
    	}[size=8pt][/size]
    		else
	        require 'RecordResultsForm.inc';
	          
        echo "<br/>";
        echo "<br/>";

Please i need help!!

[tang28]

Anyone? i am new to SQL and php and this assignment is due in 2 days! any help would be appreciated

[Pikachu2000]

The error message generally pinpoints the spot the error occurs. I'd be suspicious of the extra comma just before the closing parenthesis.

[PFMaBiSmAd]

Also, insert queries don't have where clauses.

[fenway]

  Quote

Also, insert queries don't have where clauses.

Sounds like the OP wants an UPDATE.