[PHP] Re: CDATA in PHP DOM

2005-12-01 Thread Guy Brom
worked!! "Rob Richards" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Guy Brom wrote: >> Any idea what's wrong with the following? ($this_item['description'] has >> some html text I would like to paste as a CDATA section) >> &g

[PHP] CDATA in PHP DOM

2005-12-01 Thread Guy Brom
Any idea what's wrong with the following? ($this_item['description'] has some html text I would like to paste as a CDATA section) $item->appendChild($dom->createElement('description', $dom->createCDATASection($this_item['description']))); Thanks! -- PHP General Mailing List (http://www.php.n

[PHP] Good user comment system?

2005-11-13 Thread Guy Brom
Hi all, Anyone familiar with a good user-comment system for PHP, preferably one that works with adodb and has thread-like design (where users can answer each other). Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Small regex help?

2005-10-13 Thread Guy Brom
I ended up using the rewriteCountQuery from PEAR::DB_Pager (attached). Thanks all! function rewriteCountQuery($sql) { if (preg_match('/^\s*SELECT\s+\bDISTINCT\b/is', $sql) || preg_match('/\s+GROUP\s+BY\s+/is', $sql)) { return false; } $queryCount = preg_replace('/(?:.*)\bFROM

[PHP] Small regex help?

2005-10-12 Thread Guy Brom
Can anyone suggest the correct regex to replace col1,col2... with count(*) and strip out everything just before ORDER BY? so for this: SELECT col1,col2... FROM tbl WHERE filter1 filter2 ORDER BY order1,order2 I would get this: SELECT count(*) FROM tbl WHERE filter1 filter2 Thanks! -- PHP Gener

Re: [PHP] Any good free easy converting tool?

2005-10-12 Thread Guy Brom
Why don't you just import from Access to CSV and use LOAD DATA query on MySQL? ""Gustav Wiberg"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > - Original Message - > From: "Joe Harman" <[EMAIL PROTECTED]> > To: > Cc: "Gustav Wiberg" <[EMAIL PROTECTED]> > Sent: Wednesd