MYSQL Error help - Please

[Drezard]

Hello, What does this error mean?

 

You winError in query: UPDATE user_currents SET hp_cur='172', hp_max='176', mp_cur='176', mp_max='176' exp_cur='1', exp_max='120' WHERE user='drezard'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'exp_cur='1', exp_max='120' WHERE user='drezard'' at line 1

 

It relates to this line of code:

 

				$query ="UPDATE user_currents SET hp_cur='$this->hp_cur', hp_max='$this->hp_max', mp_cur='$this->mp_cur', mp_max='$this->mp_max'    		                    exp_cur='$this->exp_cur', exp_max='$this->exp_max' WHERE user='$user'";

				$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

 

Cheers, Daniel

[skali]

',' is missing after

 

mp_max='176'