[SOLVED] update query

[deansaddigh]

Hi my code is failing at the if/update query

Whats wrong with it.

 

//See wether user allready has avatar in table
		if ($userid !==NULL)
				{
				$query= "UPDATE avatar SET Avatar_path, Avatar_name
				Where User_id=" .$userid;
				$result =mysql_query($query, $conn)
				or die ("unable to perform query");
				}

 

And help would be grately appreciated

[kickstart]

Hi

 

What do you want to set Avatar_path and Avatar_name to?

 

All the best

 

Keith

[deansaddigh]

Hi and thanks for the reply.

I want to set avatar_name and avatar_path to $filename and $path

how can this be done?

[kickstart]

Hi

 

Something like this

 

//See wether user allready has avatar in table
		if ($userid !==NULL)
				{
				$query= "UPDATE avatar SET Avatar_path = '$filename', Avatar_name = '$path'
				Where User_id=" .$userid;
				$result =mysql_query($query, $conn)
				or die ("unable to perform query");
				}

 

This assumes that $filename and $path are safe (ie, you have run mysql_real_escape_string()  on them).

 

All the best

 

Keith

[deansaddigh]

Thank you thats perfect and it works.

kind regards