Running queries
 

Hey,

I tried running a query using phpmyadmin, when I enter;

"update user set usergroupid = 26 where posts >= 0 and posts <= 500 and usergroupid = 2"

It states this error;
#1146 - Table 'xxx_xxx.user' doesn't exist

I don't know what's wrong.

Help would be appreciated.

Thanks

It means exactly what it says - you dont have a table called "user" in your database.

Most likely you have a prefix, e.g. vb3_user.

Hey,

Thanks for the response.

I have the table in the database, I checked.

It says "mkt_mxm.user" doesn't exist.

But when I check if it exists, mkx_user does exist.

I'm confused =/