replacing data in a column

boombanguk

Hi,

How do I replace(update?) data in a specific column (field?) in a mysql table row? would it be something like INSERT INTO $Table WHERE $name = "user" ("data"), ("data2");

Sorry, just starting out with PHP and mySQL.

thanks for any help
boombanguk

jheitz

Read an SQL manual online as you need to know the basics, otherwise you will struggle all the way through. The command you need is "UPDATE"

boombanguk

jheitz wrote:
Read an SQL manual online as you need to know the basics, otherwise you will struggle all the way through. The command you need is "UPDATE"

ok got that working, but now i need to retreive data from one field only corresponding to what username I want, do I have to use mysql_fetch_array and then loop through everything? or is there a way to get access to the 1 field in 1 row only directly?