spenceddd Posted December 27, 2009 Share Posted December 27, 2009 Hi I keep getting this error when trying to update a row in my database: Unknown column 'xxx' in 'field list' the line of code which must be responsible for this is: $query="UPDATE PortfolioItems SET PortfolioItems.name=$name WHERE id=$id"; ...even though there is a colomn called name in my database. Can anyone help? Thanks Spencer Quote Link to comment Share on other sites More sharing options...
darkfreaks Posted December 27, 2009 Share Posted December 27, 2009 try: <?php $query="UPDATE PortfolioItems SET PortfolioItems.name='$name' WHERE id='$id'"; ?> Quote Link to comment Share on other sites More sharing options...
spenceddd Posted December 27, 2009 Author Share Posted December 27, 2009 Great! That worked. Thanks a lot. Spencer Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.