Mysql Help Unknown Column 'name' In 'where Clause'

[Hypersource]

Whats wrong with this i know its obvious : (

 

$cash=mysql_query("UPDATE potions SET color='$color',pet='$pet' WHERE owner='$tik' and name=' $name ' ") or die(mysql_error());

 

i get

Unknown column 'name' in 'where clause'

[Psycho]

Well, if the error is what you have put into the title of the post then the error is just as it says - there is no column with the name of "name". When debugging such errors it is always helpful to echo the actual query to the page. Otherwise you can spend hours trying to figure out a problem with a query that is actually a problem with a variable:

$query = "UPDATE potions
	  SET color='$color', pet='$pet'
	  WHERE owner='$tik'
	    AND name=' $name '";

$result = mysql_query($query) or die("Query: $query<br>Error: " . mysql_error());

[Jessica]

What is the structure of the potions table? And why aren't you updating based on a primary key?

[Hypersource]

Whoops new this was obvious! its the wrong table i need to do the pets table sorry for wasti

ng your time