php-general Digest 27 Nov 2010 13:57:29 -0000 Issue 7057

2010-11-27 Thread php-general-digest-help
php-general Digest 27 Nov 2010 13:57:29 - Issue 7057 Topics (messages 309692 through 309709): Re: code quest 309692 by: Bastien 309705 by: Ashley Sheridan Re: preg_match fails to resolve variable as a subject 309693 by: Da Rock 309695 by: Tamara Temple

php-general Digest 28 Nov 2010 06:14:04 -0000 Issue 7058

2010-11-27 Thread php-general-digest-help
php-general Digest 28 Nov 2010 06:14:04 - Issue 7058 Topics (messages 309710 through 309733): Re: Possible issue in mail() function? 309710 by: Tom Hendrikx Re: Problem with RegEx for BBCode 309711 by: Daniel P. Brown 309714 by: Asmann, Roland 309716 by:

Re: [PHP] code quest

2010-11-27 Thread Ashley Sheridan
On Fri, 2010-11-26 at 20:27 -0500, Bastien wrote: On 2010-11-26, at 7:33 PM, Adam Richardson simples...@gmail.com wrote: On Fri, Nov 26, 2010 at 7:03 PM, Kirk Bailey kbai...@howlermonkey.netwrote: Hello all, my name is Kirk Bailey, and I am new to php, so please be

RE: [PHP] PHP Add +1 mysql updates by 2?

2010-11-27 Thread Ashley Sheridan
On Fri, 2010-11-26 at 22:29 -0800, Tommy Pham wrote: -Original Message- From: Richard West [mailto:p...@cbnisp.com] Sent: Friday, November 26, 2010 9:40 PM To: Peter Lind Cc: Tommy Pham; Tamara Temple; PHP General Mailing List Subject: Re: [PHP] PHP Add +1 mysql updates by 2?

Re: [PHP] PHP Add +1 mysql updates by 2?

2010-11-27 Thread Richard West
First let me say thanks to everyone who replied! Ashley, I got it fixed but I have not a clue what did it :) RD On Nov 27, 2010, at 6:49 AM, Ashley Sheridan wrote: On Fri, 2010-11-26 at 22:29 -0800, Tommy Pham wrote: -Original Message- From: Richard West [mailto:p...@cbnisp.com]

Re: [PHP] PHP Add +1 mysql updates by 2?

2010-11-27 Thread Richard West
PS: PEBKAC I figure :) On Nov 27, 2010, at 6:49 AM, Ashley Sheridan wrote: On Fri, 2010-11-26 at 22:29 -0800, Tommy Pham wrote: -Original Message- From: Richard West [mailto:p...@cbnisp.com] Sent: Friday, November 26, 2010 9:40 PM To: Peter Lind Cc: Tommy Pham; Tamara Temple;

[PHP] Problem with RegEx for BBCode

2010-11-27 Thread Asmann, Roland
Hi all, I am playing around with PHP and BBCodes and have found some regex's that should transform my BBCode into correct HTML when rendering. However, I have found that if the BBCode is not correct (eg missing closing tag), the regex completely eats my input and my page is empty! The regex

Re: [PHP] Possible issue in mail() function?

2010-11-27 Thread Tom Hendrikx
On 26/11/10 16:54, Richard Quadling wrote: On 26 November 2010 15:12, Tom Hendrikx t...@whyscream.net wrote: On 26/11/10 15:54, Richard Quadling wrote: On 25 November 2010 21:30, Tom Hendrikx tom+php@whyscream.net wrote: Hi, I noticed that the mail() function in php 5.3.3 on gentoo linux

[PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
Hi gang, I am executing a query via PHP that gives me a PHP error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.`Preferred_First_Name` LIKE 'Don' AND m.`Preferred_Last_Name` LIKE 'Wielan' at

Re: [PHP] code quest

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 12:36, Daniel P. Brown daniel.br...@parasane.net wrote:   If you want something more powerful - and often quicker - check into SPL: specifically FilesystemIterator[1], DirectoryIterator[2], and RecursiveDirectoryIterator[3].  A quick example to link all child files and

Re: [PHP] Problem with RegEx for BBCode

2010-11-27 Thread Asmann, Roland
On 27-11-10 18:44, Asmann, Roland wrote: On 27-11-10 17:24, Daniel P. Brown wrote: On Sat, Nov 27, 2010 at 08:57, Asmann, Roland roland.asm...@adesso.at wrote: Hi all, I am playing around with PHP and BBCodes and have found some regex's that should transform my BBCode into

Re: [PHP] Problem with RegEx for BBCode

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 12:50, Asmann, Roland roland.asm...@adesso.at wrote: Besides, what I don't really understand is WHY does this happen? Any other language that has RegEx doesn't match a thing in my example and just returns the original input. Why is PHP different in this regard? All

Re: [PHP] Strange Query Error...

2010-11-27 Thread Bastien
On 2010-11-27, at 12:30 PM, Don Wieland d...@dwdataconcepts.com wrote: Hi gang, I am executing a query via PHP that gives me a PHP error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND

Re: [PHP] Strange Query Error...

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 12:30, Don Wieland d...@dwdataconcepts.com wrote: Hi gang, I am executing a query via PHP that gives me a PHP error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND

Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 10:07 AM, Bastien wrote: Try removing the backticks around the table names. If you do use them, then all values (field names and table names) need it. I tried that and still chokes... select m.* from Members m inner join Member_Years my on m.aucciim_id = my.member_id

Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 10:08 AM, Daniel P. Brown wrote: one primary question: are you using the mysql_* family, mysqli_* family, or another method of interfacing with MySQL? mysql_ $results = mysql_query($query) or die(mysql_error()); Don -- PHP General Mailing List (http://www.php.net/) To

RE: [PHP] Strange Query Error...

2010-11-27 Thread Tommy Pham
-Original Message- From: Don Wieland [mailto:d...@dwdataconcepts.com] Sent: Saturday, November 27, 2010 10:18 AM To: Bastien Cc: php-general@lists.php.net Subject: Re: [PHP] Strange Query Error... On Nov 27, 2010, at 10:07 AM, Bastien wrote: Try removing the backticks around

Re: [PHP] Strange Query Error...

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 13:18, Don Wieland d...@dwdataconcepts.com wrote: On Nov 27, 2010, at 10:07 AM, Bastien wrote: Try removing the backticks around the table names. If you do use them, then all values (field names and table names) need it. I tried that and still chokes... select m.*

Re: [PHP] Problem with RegEx for BBCode

2010-11-27 Thread Daniel P. Brown
Please be sure to hit Reply-All so that the list is CC'd on each response as well. On Sat, Nov 27, 2010 at 13:55, Asmann, Roland roland.asm...@adesso.at wrote: I'm currently running this on a default XAMPP installation on my PC, because I was told something similar is running on the

Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 10:44 AM, Daniel P. Brown wrote: Note how you keep changing case here. For example, m.aucciim_id vs. m.AUCCIIM_ID. Also note that all of this is cAsE-sEnSiTiVe. You are right. But it still chokes in PHP: select m.* from Members m inner join Member_Years my on

Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 10:39 AM, Tommy Pham wrote: Don, Have you tried to run the query in either MySQL workbench or the command line to ensure that query is SQL syntax error free? From the error message, it sounds more like a SQL syntax error. If you're able to run the query fine in the

Re: [PHP] Strange Query Error...

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 14:30, Don Wieland d...@dwdataconcepts.com wrote: Strange...  I have no idea what to do. I got to run it via PHP. Don, on which table is the column `member_year` located? Is that on `Members`? -- /Daniel P. Brown Dedicated Servers, Cloud and Cloud Hybrid

Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 11:35 AM, Daniel P. Brown wrote: Strange... I have no idea what to do. I got to run it via PHP. Don, on which table is the column `member_year` located? Is that on `Members`? it is Member_Years. I thought of that. I change the query: select m.* from Members m

Re: [PHP] Strange Query Error...

2010-11-27 Thread Daniel P. Brown
On Sat, Nov 27, 2010 at 14:45, Don Wieland d...@dwdataconcepts.com wrote: Pretty please - I just want to get this working and move on ;-) At this point, can you just send the whole related snippet? The cases keep changing and there's a lot of other suggestions that you said you've tried.

Re: [PHP] Strange Query Error...

2010-11-27 Thread Don Wieland
On Nov 27, 2010, at 12:09 PM, Daniel P. Brown wrote: At this point, can you just send the whole related snippet? The cases keep changing and there's a lot of other suggestions that you said you've tried. Just doing that on my local machine works without error, so it's likely the result of