Page 1 of 1

UPDATE phpwcms_article SET article_public = '0';

Posted: Wed 13. Apr 2005, 16:17
by 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

Posted: Wed 13. Apr 2005, 16:48
by 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

Posted: Wed 13. Apr 2005, 20:54
by patoche
I just need to launch this action by click on a link
but i don't know how