UPDATE phpwcms_article SET article_public = '0';

[patoche]

I would like to put a link to make all article not public

I don't know the syntax on php to do what sql action
UPDATE phpwcms_article SET article_public = '0';

Thanks to help

[phwhitfield]

To execute an SQL command from php simply use this code:

Code: Select all

$result = mysql_query("SQL-Statement")

see this page for details: http://ch2.php.net/manual/en/function.mysql-query.php

[patoche]

I just need to launch this action by click on a link
but i don't know how