Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Jan 2010, 16:43
paintballer.ie's Avatar
paintballer.ie paintballer.ie is offline
 
Join Date: Jan 2009
Help with creating a short SQL Quiery Please

Hey lads, I have the community news letter by Provb but I can not get proper support from them

The installation creates a profile option to subscribe to the community news letter. However this option yes or no are blank by default. I need to run an sql query to set all members to 'yes'.

What I got so far was:
PHP Code:
UPDATE userfield set fieldX = 'yes'

If you have a table prefix, include it. Replace X with the profile field ID Make sure you've double checked what you replaced, otherwise you may change the wrong one
Here is where I am stuck and have not got help. I use the prefix vb_ , so where where to I put this?

Thanks in advance for pointing me in the right direction
__________________
The Paintball Resource

Critic My site HERE
Reply With Quote
  #2  
Old 03 Jan 2010, 17:16
051119 051119 is offline
 
Join Date: Jan 2008

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #3  
Old 03 Jan 2010, 17:39
paintballer.ie's Avatar
paintballer.ie paintballer.ie is offline
 
Join Date: Jan 2009
Thanks
__________________
The Paintball Resource

Critic My site HERE
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:09.

Layout Options | Width: Wide Color: