To change all IP numbers of a single user

[borbole]

Originally Posted by Bob_R

Since PHP and MySQL have been updated in the last 2 years post #2 in this thread doesn't work.

It asked me to select at least 1 column/row (or something like that)

What is the way to do it now?

Thanks!

Updating of php and mysql has nothing to do with the query above. In order to troubleshoot your problem we would need to see the full error that you got.

But most likely as mentioned above, you are using a prefix for your db tables and you did not include it in the query as mentioned at my other post above.

[Bob_R]

Originally Posted by Lynne

That query is still correct. Make sure if you use a table prefix that you add that to the beginning of the table name.

Originally Posted by borbole

Updating of php and mysql has nothing to do with the query above. In order to troubleshoot your problem we would need to see the full error that you got.

But most likely as mentioned above, you are using a prefix for your db tables and you did not include it in the query as mentioned at my other post above.

OK, guys. Thanks. I'll check it out and get back to ya!

--------------- Added [DATE]1345592796[/DATE] at [TIME]1345592796[/TIME] ---------------

Here's what I entered:

UPDATE post
SET ipaddress = '66.28.139.242'
WHERE userid = 67;

And, here is the result

You have to choose at least one column to display

----------------------

What did I do wrong?

Thanks.

--------------- Added [DATE]1345593235[/DATE] at [TIME]1345593235[/TIME] ---------------

I figured it out. I was in the wrong window.

Thanks for your help.