Trying to change a value mysql database

Question

I am very new to MySQL database but I have some PHP knowledge
I want to update a value for all wp_s2member_login couter field in a table.
I am getting this error when I try to update the table:

Connected successfully Unknown column 'wp_s2member_login_counter' in 'where clause'

<?php
// Connect to MySQL
$link = mysql_connect('mywebsite.com', 'wrd6rEDgggy', 'mypassword'); 
if (!$link) { 
die('Could not connect: ' . mysql_error()); 
} 
echo 'Connected successfully'; 
mysql_select_db(wrd_47io4f3a6l);

$result = mysql_query("UPDATE wp_usermeta SET meta_value='0' WHERE          wp_s2member_login_counter<>'0'") 
or die(mysql_error());  

?>

Thank you very much for your help!

Forgive me for pointing out the obvious but... Do you have a `wp_s2member_login_counter` column? — George, Mar 22 '13 at 14:15
You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Mar 22 '13 at 14:15
it is saying that there is no column named as "wp_s2member_login_counter" in table wp_usermeta. Check column name, via executeing select * from wp_usermeta limit 5 — Vinit Prajapati, Mar 22 '13 at 14:16
@Lisa Could you please tell me what happens if you type: desc wp_s2member_login_counter — Khanh Tran, Mar 22 '13 at 14:17
wp_s2member_login_counter is not column name, column name is meta_key. — Bojan Kovacevic, Mar 22 '13 at 14:18
i think this is what you actually want UPDATE wp_usermeta SET meta_value='0' WHERE meta_key != '0' — Suyash, Mar 22 '13 at 14:20
@Lisa can you list what do you see when you do: desc wp_usermeta — Khanh Tran, Mar 22 '13 at 14:27

score 0 · Answer 1 · answered Mar 22 '13 at 14:17

0

From what you posted above, is your wp_s2member_login couter Table supposed to be be wp_s2member_login counter?

With the "n" in counter?

answered Mar 22 '13 at 14:17

Blunderfest

1,854
1
28
46

I'm guessing this was downvoted because it should be a comment, not an answer. – Reinstate Monica -- notmaynard Mar 22 '13 at 14:19
He can't add comment because of his reputaion – Khanh Tran Mar 22 '13 at 14:20
What will be the proper code to change that value for all wp_s2member_login counter fields? – Lisa Betancourt Mar 22 '13 at 14:21
All I want to do is set the value to 0 for all fields named "wp_s2member_login counter" in the table. – Lisa Betancourt Mar 22 '13 at 14:24
UPDATE wp_usermeta SET meta_value='0' WHERE meta_key = 'wp_s2member_login_counter'; ? – Bojan Kovacevic Mar 22 '13 at 14:26
Vinit,I believe this is a field that belongs to meta_key column – Lisa Betancourt Mar 22 '13 at 14:27
does my query do what you wants? set meta_value to all field that have wp_s2member_login_counter as meta_key value? – Bojan Kovacevic Mar 22 '13 at 14:29

Alexander Voronin · Answer 2 · 2013-03-22T14:46:20.763

0

$result = mysql_query("UPDATE wp_usermeta SET meta_value='0' WHERE          wp_s2member_login_counter<'0' OR wp_s2member_login_counter>0")

or

$result = mysql_query("UPDATE wp_usermeta SET meta_value='0' WHERE          wp_s2member_login_counter != 0")

edited Mar 22 '13 at 14:46

answered Mar 22 '13 at 14:37

Alexander Voronin

1
1

Trying to change a value mysql database

2 Answers2