Solutionabc
asked on
mysql Update a row with WHERE condition
MySQL
How do I update all the columns in a row using the WHERE clause? the WHERE is equal to a php variable.
thanks.
How do I update all the columns in a row using the WHERE clause? the WHERE is equal to a php variable.
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
UPDATE mytable SET myfield = 'newvalue' WHERE myotherfield = 'a value'
... if you need to update all rows, simply miss off from WHERE onwards.
... hope this helps...