how to update table

[TheSky]

hey forum people

can you help me on one problem so i have script what should update mysql table by username

UPDATE data SET username='$name' WHERE value1='$value1' AND value2='$value2' AND value3='$value3' AND value4='$value4' AND value5='$value5'

any ideas ?

[Maq]

any ideas ?

If I had to guess, it's broken somewhere.

[TheSky]

on point i dont know how to update mysql database

EDIT but is this cutoff valid?

[Maq]

on point i dont know how to update mysql database

You're already using UPDATE, what's the problem?

[fugix]

your syntax looks correct...did you try troubleshooting your query using mysql_error()?

[TheSky]

do i have to select database also ? i think i do and i didnt add it i did run $result = mysql_query($sql) or die(mysql_error()); and it was successful

EDIT: hmm i checked i have selected in included connect file but i think i made wrong ?

i want update username and add data

[Maq]

do i have to select database also ?

Yes, how else would your program know the BD to use?

 

i think i do and i didnt add it i did run $result = mysql_query($sql) or die(mysql_error()); and it was successful

mysql_query is what actually executes your query.  Read the documentation...

[TheSky]

UPDATE data SET value1='$value1',value2='$value2',value3='$value3',value4='$value4,value5='$value5' WHERE username='$name'

thanks i found now answer for my question

[Maq]

UPDATE data SET value1='$value1',value2='$value2',value3='$value3',value4='$value4,value5='$value5' WHERE username='$name'

thanks i found now answer for my question

In the future you can temporarily use or die(mysql_error()) to display mysql errors.  But you should eventually fix/handle them properly.