mysql Error message: Unknown column 'xxx' in 'field list'

[spenceddd]

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

[darkfreaks]

try:

 

<?php
$query="UPDATE PortfolioItems SET PortfolioItems.name='$name' WHERE id='$id'";   
?>

 

 

[spenceddd]

Great! That worked.

 

Thanks a lot.

 

Spencer