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
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
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
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
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
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
6 matches
Mail list logo