Re: [nyphp-talk] Searching an Entire MySQL Database

2010-11-04 Thread ps
i will look at this type of solution. thanks. peter Original Message Subject: Re: [nyphp-talk] Searching an Entire MySQL Database From: Michael Southwell Date: Thu, November 04, 2010 6:11 am To: NYPHP Talk On 11/4/2010 08:32,

[nyphp-talk] Searching an Entire MySQL Database

2010-11-04 Thread ps
I am wondering if anyone has had to search an entire database and do a search and replace on a string. That is to search in every table, in every row, in every field.I am open to here about any or most effective method: Is there a unique MySQL query techniqueA SQL query that can do this? A SQL quer

Re: [nyphp-talk] Array-cersize

2010-10-22 Thread ps
it looks deceptively good at first for count.count($arr_countable_items) will count all the first dimension arrays, with the recursive param it seems it will count every element in every array.also if the array is an index array and not precisely indexed 0, 1, 2, 3, , the count will failPeter

Re: [nyphp-talk] REGEXP Solution Needed

2010-09-08 Thread ps
As usual lots of great inoput, but here is what seems to work for me testing it against some actula URLs:^http://www\\.example\\.com/events/events?.*size=[^10].*Just using size does not equal 10.  Original Message Subject: Re: [nyphp-talk] REGEXP Solution Needed From: John Camp

Re: [nyphp-talk] REGEXP Solution Needed

2010-09-08 Thread ps
I believe this is what I am looking for: ^http://www\\.example\\.com/events/events?.*size=[\d|\d\d^10].*If anyone can polish this more or if I am wrong, pls give a note. Thanks. Original Message Subject: Re: [nyphp-talk] REGEXP Solution Needed From: Date: W

Re: [nyphp-talk] REGEXP Solution Needed

2010-09-08 Thread ps
This is a great technique, thanks, Scott.But, I'm putting this into the Do Not Crawl front end of a google search appliance and it has to be done with gnu regexp. So I've been working on it and I got something like this for starters:^http://www\\.example\\.com/events/events\\?\.size=[\d|\d\d^10]\.W

[nyphp-talk] REGEXP Solution Needed

2010-09-08 Thread ps
Using GNU Regular Expressions I need to examine an URL like those below, checking the size key and value, I need to capture and block all URLs where 'size does not equal 10'. In other words "size=12", not acceptable. Here are examples...Good URL pattern (size=10): http://www.example.com/events/even

Re: [nyphp-talk] Undelete mysql records

2010-04-15 Thread ps
unfortunately, i am not familiar with the procedure on binlogs, but (if the feature is turned on) there is also a mysql query log that you could review that might allow you to reconstruct deleted data. Just a shot in the dark for you. Original Message Subject: Re: [nyphp-talk] U

[nyphp-talk] Peter Sawczynec Has a New Cell Phone Number in FL

2008-08-28 Thread ps
Dear Talk: My new cell phone number is (941)893-0396. This new number is already in effect now. NOTE: As early as Sat. Aug. 30th 2008, my old cell phone number service will expire and be turned off. I'd like to take this moment to say thank you for your friendship over the years. Warmest re