PDA

View Full Version : Activate entries in mysql


kloeppy
05-27-2010, 01:33 PM
Hi,

because of lot of entries i would like to activate all entries in myqsl. i found the entry PLD_LINK in myqsl. There is the table "Status and "Valid" If i change the Status from 1 to 2 in "Status in all entries all of them are activated ? How is the command in mysql ? I know something with "Update" but i dont know really how it works. Is it possible, that all of the activated entries get also the e-mail if i update the tables in mysql ? If not how can i activate all and sent also e-mail without klick at every entry in the backend of phpld ?

Thank you very much.

James
05-27-2010, 03:33 PM
not going to send email with a mysql command, sorry. We have posted in several placed what MySQL command to run to set them all active.