UPDATE from form values...

seco

Hi,

Im sure this is cake for most of you, I am just getting into the insert/update part of php/mysql.

anyways to the nitty gritty..

this works fine

$sql="INSERT INTO my_profile (mem_id, description) VALUES ('$_POST[mem_id]','$_POST[description]')";

BUT....

I need to change where and how its posted to the DB. basically, its an EXISTING mem_id with a description. I cant seem to figure out how to UPDATE the description from the form values... i have looked around, granted im tired and could have looked harder, but this forum is great.

So if anyone could give me some pointers i would appreciate it.

laserlight

Try something along the lines of:

UPDATE my_profile SET description='$x' WHERE mem_id='$id'

Just to check: hope you properly escaped those incoming variables before using them in the query.

seco

that doesnt help at all.

Horizon88

Yeah laserlight, what were you thinking, showing him an update query? He obviously needed someone to run a Google search for him, as he's apparently incapable of doing so.

Next time, seco, try looking a little harder: "mysql update tutorial" is a pretty straightforward search string, yes?

http://www.tizag.com/mysqlTutorial/mysqlupdate.php
http://dev.mysql.com/books/mysqlpress/mysql-tutorial/ch10.html
http://www.developerfusion.co.uk/show/3998/9/

The first one's the shortest. :rolleyes:

seco

Horizon88 wrote:
Yeah laserlight, what were you thinking, showing him an update query? He obviously needed someone to run a Google search for him, as he's apparently incapable of doing so.

Next time, seco, try looking a little harder: "mysql update tutorial" is a pretty straightforward search string, yes?

http://www.tizag.com/mysqlTutorial/mysqlupdate.php
http://dev.mysql.com/books/mysqlpress/mysql-tutorial/ch10.html
http://www.developerfusion.co.uk/show/3998/9/

The first one's the shortest. :rolleyes:

i did look, no luck. im using a form "2 hidden inputs" with values pulled from a db, using ajax to update another table, update the description field of the mem_id.
the mem_id and description are pulled from one table into 2 text boxes and updated to another table, but i cant find the right way to go about updating only the description field of the mem_id. i can update all day long, this is just new for me using ajax and html form elements.

foyer

'but i cant find the right way to go about updating only the description field of the mem_id'

laserlight showed you, that will update the descript of the field mem_id.. maybe you are not explaining your problem so that we can understand it.

TheDefender

seco wrote:
i did look, no luck. im using a form "2 hidden inputs" with values pulled from a db, using ajax to update another table, update the description field of the mem_id.
the mem_id and description are pulled from one table into 2 text boxes and updated to another table, but i cant find the right way to go about updating only the description field of the mem_id. i can update all day long, this is just new for me using ajax and html form elements.

No offense, but what exactly do you want?

HTML is the base code for web pages and AJAX is extended Javascript in which you would presumably just be calling your PHP script on anyhow... The HTML and PHP remain the same and really don't care where AJAX comes into the picture. So, exactly what do you want, and what is the source of your lack of understanding on how to do an update on a MySQL database?!?

seco

i got it to work the way i need it.

"INSERT INTO music_profile (mem_id, embed_code) VALUES ('$_POST[mem_id]','$_POST[embed_code]') ON DUPLICATE KEY UPDATE embed_code='$_POST[embed_code]'";

seco

TheDefender wrote:
No offense, but what exactly do you want?

HTML is the base code for web pages and AJAX is extended Javascript in which you would presumably just be calling your PHP script on anyhow... The HTML and PHP remain the same and really don't care where AJAX comes into the picture. So, exactly what do you want, and what is the source of your lack of understanding on how to do an update on a MySQL database?!?

my lack "was" updating a row of a specified id and setting the values correctly.