MYSQL update through PHP form

[Codethat]

Hi,

I want to use a php form textfield to change a value in my databas.

Statement i want to send the databas: UPDATE people SET name='VALUE FROM TEXTFILED' WHERE id=1

How do i integrate this statement into a php form textfield?

[claritydigital]

Assuming you are using a mysql database, this should do the trick:

if(isset['submit']) {
mysql_query("UPDATE people SET name='".$_POST['value from field']."' WHERE id=1");
  }

Happy coding:)

[nav33n]

Most of the time (like 99% of the time), people tend to forget how important it is to sanitize the user's input. Using mysql_real_escape_string will prevent sql injections by escaping ' and /.