Re: [PHP] S: function to remove & break URLs

2006-08-27 Thread Paul Scott
On Sun, 2006-08-27 at 20:31 -0400, Jon Anderson wrote: > In reference to the detection part; In my case, 95%+ of the spam entries > have links that contain one of about 5 words (casino, pharm, drug, > stock, or invest), so I could eliminate most spam by automatically > trashing all entries that

[PHP] Comparing strings... need advice. :)

2006-08-27 Thread Micky Hulse
Hi, I am looking for the most secure/efficient way to compare these two strings: /folder1/folder2/folder3/folder4/ /folder1/folder2/folder3/folder4/file.php Basically I am trying to setup as many security features as possible for a simplistic (home-grown/hand-coded) CMS... This appears to wo

Re: [PHP] S: function to remove & break URLs

2006-08-27 Thread Jon Anderson
RalfGesellensetter wrote: Dear list, does anybody of you know these spammers filling up your guestbook with URLs? With strip_tags, I managed to remove the html tags. But what I want is this: 1. Detect such entries (to hide them by default) 2. Destroy URLs As for 2. I am thinking of adding

Re: [PHP] display a single thumb per gallery

2006-08-27 Thread Alex Turner
Here is one way of doing it: Group by gallery and return max for image id. Place the resultant Gallery and Image values in an array of arrays. SELECT Gallery, Max(Image) FROM Thumbnails GROUP BY Gallery Then loop over the outer array returning the entire thumbnail row where gallery and image

Re: [PHP] display a single thumb per gallery

2006-08-27 Thread ross
$query = "SELECT distinct gallery FROM thumbnails"; that only returns the numbers 7 & 8. I need the all the info from the rows - id, binary data etcsomething like $query = "SELECT * FROM DISTINCT gallery FROM thumbnails"; any ideas? - Original Message - From: Dave Goodchild

Re: [PHP] display a single thumb per gallery

2006-08-27 Thread Dave Goodchild
To find out how many unique galleries: SELECT DISTINCT gallery FROM table Ross -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk

[PHP] display a single thumb per gallery

2006-08-27 Thread Ross
I have a database of images, http://www.thethistlehouse.com/db.jpg What I want to do is select ONLY ONE image to display as a the image link for that gallery. As you can see galleries are numbered dynamcially but galleries can also be added and deleted so the galleries no's I have now (7, 8) wi

[PHP] S: function to remove & break URLs

2006-08-27 Thread RalfGesellensetter
Dear list, does anybody of you know these spammers filling up your guestbook with URLs? With strip_tags, I managed to remove the html tags. But what I want is this: 1. Detect such entries (to hide them by default) 2. Destroy URLs As for 2. I am thinking of adding spaces after at least every 1

Re: [PHP] Email with pregmatch

2006-08-27 Thread Michael B Allen
On Sun, 27 Aug 2006 20:35:47 +0700 "Peter Lauri" <[EMAIL PROTECTED]> wrote: > Hi, > > I am trying to check if an email is an email or not, so I used this that I > found on the internet: > > preg_match("/^([a-zA-Z0-9])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", > $_POST['email']); This is what I us

RE: [PHP] Email with pregmatch

2006-08-27 Thread Peter Lauri
I found this on google, does this LONG function do anything more then your preg_match? function isEmail($emailstr) { // Make the email address lower case and remove whitespace $emailstr = strtolower(trim($emailstr)); // Split it up into befo

Re: [PHP] Email with pregmatch

2006-08-27 Thread Dave Goodchild
Try this: preg_match("/^([a-zA-Z0-9.])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", $_POST['email']); -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk

[PHP] Email with pregmatch

2006-08-27 Thread Peter Lauri
Hi, I am trying to check if an email is an email or not, so I used this that I found on the internet: preg_match("/^([a-zA-Z0-9])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", $_POST['email']); BUT, it returns false with the email [EMAIL PROTECTED] And ok for [EMAIL PROTECTED] What is the error here