Re: UPDATE - MySQL having some trouble

hi, > I can't the UPDATE command in MySQL to work properly. Here is my > query.... > > $query = "update table set lastname=$lastname, firstname=$firstname ^^^^^ replace table with <table name> > where username=$username"; ($lastname, $firstname, $username ) should be enclosed by quotes, if all the fields are character. > > Anything wrong with my syntax here? Goodluck........! cheers, kishor Nilgiri Networks.