Re: Update MYSQL command with PHP

2001-11-08 Thread DL Neil
> Question is there something wrong with this syntax when using the MYSQL > Update command in PHP , where I change the record by users editing the > fields on a web form then those are extracted to update a record in a > table. > Here's what I have tried I don't get any syntax errors with either

Re: Update MYSQL command with PHP

2001-11-08 Thread Kodrik
> $query1 = "UPDATE Qusers SET $field_str WHERE UserName='$username'"; > $result2 = mysql_query($query1); It should be: update Qusers set field_name='$field_str' where username='$username'"; - Before posting, please check: ht

Update MYSQL command with PHP

2001-11-08 Thread Kory Wheatley
Question is there something wrong with this syntax when using the MYSQL Update command in PHP , where I change the record by users editing the fields on a web form then those are extracted to update a record in a table. Here's what I have tried I don't get any syntax errors with either of these