View Single Post
  #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