[Resolved] there is nothing wrong with this function but i still get errors !!!!!!!

[k994519]

HI guys

check this function out

<?
function delete_student($student_id)
{
		global $link; 
		$query="ALTER students DROP * WHERE student_id='$student_id'";
		$result=mysql_query($query,$link) or die("died deleting student from db.  Error returned if any:" .mysql_error());

	return true;
}

and the way its is called

 if(!isset($_POST['submit'])) 
        {  

		field_validator("student_id", $_POST["student_id"], "number", 1, 7);


		 if( !($row =  check_sid($_POST['student_id'])) ) 

    { 
    // Staff ID does not exist, create an error message: 
        $messages[]="  student_id ID does not exist please, try again"; 
    }             


	delete_student($student_id);

		print"<center>";
		echo "<H4>All field's being been updated...............All Data Saved</H4>";
		echo "Please click link .........x2.";
		echo "</CENTER>";	
	}  
   else  
	{ 
        displayErrors($messages); 
        echo"<CENTER>click back to try again update errpr </CENTER>"; 
	} 
?>
   

i get this error from it........

 
died deleting student from db. Error returned if any: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 'students DROP * WHERE student_id='154789'' at line 1

I keep getting this error as you can see it does recoginse the student_id number as "154789". the number is still in the database and has not been changed in anyway........

any help would be very appreicated......

[mrhappiness]

DELETE FROM students WHERE student_id=$student_id

[k994519]

YES ITS OFFICAL

I should be using

delete from table where ..... as it runs better!!!

Im such a stupid biiiiach

[eoghain]

Well, you have an error in your SQL Syntax as is reported.

It looks like you want to remove the record with student_id = 154789 from the table students. The query to do this is:

DELETE
  FROM students
 WHERE student_id = 154789

The SQL that you wrote is completly wrong, the ALTER keyword is used for manipulating a tables structure (and is actually ALTER TABLE). The DROP keyword is used to remove column from the given table, the enitre column.

[k994519]

THanks for your help everyone...

Yes I do feel like a prize prat considering i was telling my mate yesterday to do delete from , where