Jump to content



  • Please log in to reply
2 replies to this topic

#1 eric07

  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 08 May 2006 - 03:10 AM

Hi I am really srtuggling with how to create a update SQL statement for a table in MySQL. I know I need a SQL statement but I am struggling in implementing it. Is there any examples of code that I can look at that will explain this.

The new values that will be assigned to these table are done through $_POST function. So do I also have to assign these to normal php variables embedded in the page and then map these to fields in the table?

#2 Ferenc

  • Members
  • PipPipPip
  • Advanced Member
  • 94 posts

Posted 08 May 2006 - 03:35 AM

$var_1 = $_POST['textfield_name'];
$sql = mysql_query("INSERT INTO table_name VALUES ('$var_1')"); // the same would apply to UPDATE statements

// or 

$sql = mysql_query("INSERT INTO table_name VALUES ('" . $_POST['textfield_name'] . "')");

edited my errors.
Everything you want to know is here.

#3 trq

  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 08 May 2006 - 03:41 AM

Both those examples are incorrect.
INSERT INTO tbl (fld1,fld2) VALUES ('val1','val2');
Or to update...
UPDATE tbl SET fld1='val1',fld2='val2';

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users