[PHP] open source content management systems?

hi all does anyone have any recommendations for good open source content management systems for websites? - preferably, written in php... i have about a 5 page site running on a freebsd/apache server. it gets a fair number of hits a day. right now, the great majority of my pages are statical

[PHP] need help with mysql union

hi, i'm trying to select * through 3 tables - is the following syntax correct? $sql="(SELECT * FROM mjp_cc)"; $sql="UNION"; $sql="(SELECT * FROM imc_cc)"; $sql="UNION"; $sql="(SELECT * FROM pmp_cc)"; $sql.=" ORDER BY savedccactivity DESC"; i basically just want to spit out the contents of these t

[PHP] PEAR

hi i'm interested in learning more about the PEAR project, and the possibility of incorporating PEAR code in my future projects. i was wondering if anyone can recommend some good PEAR tutorials. i also wanted to get an idea as to the percentage of people who use PEAR on a regular basis in

[PHP] need help w/ sql query - update and select at once

hi i'm trying to get this sql query to work, i'm trying to update and select at the same time, i'm not even sure if this is even possible update db.tablename set field1='yes' where (select * from db.tablename,db.tablename2 where db.tablename.userid=db.tablename2.userid); basically i have a colum

[PHP] need help with while loop/rtf generator page

hi all i'm having trouble with the this page. not sure if i'm approaching the problem the right way. i'm basically passing search criteria to a page. i'm using the search criteria to construct a sql query dynamically. i'm using the sql query in a while loop that cycles through the db and finds