On Nov 27, 2010, at 1:24 PM, Don Wieland wrote:
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.* fr
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 anot
On Sat, Nov 27, 2010 at 14:45, Don Wieland 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. Just doing that on my lo
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 inn
On Sat, Nov 27, 2010 at 14:30, Don Wieland 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`?
--
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://
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 w
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 m.AUCCII
Sorry people for not replying over the list...
On 27-11-10 20:08, Daniel P. Brown wrote:
> On Sat, Nov 27, 2010 at 14:05, Daniel P. Brown
> wrote:
> > On Sat, Nov 27, 2010 at 13:55, Asmann, Roland
> wrote:
> >>
> >> $s = preg_replace("/\[i\]((\s|.)+?)\[\/i\]/", "\\1", $s);
> >
> >This i
On Sat, Nov 27, 2010 at 14:05, Daniel P. Brown
wrote:
> On Sat, Nov 27, 2010 at 13:55, Asmann, Roland wrote:
>>
>> $s = preg_replace("/\[i\]((\s|.)+?)\[\/i\]/", "\\1", $s);
>
> This is exactly what I meant when I erroneously said, "library."
Without seeing the rest of your code, try adjus
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 wrote:
>
> I'm currently running this on a default XAMPP installation on my PC,
> because I was told something similar is running on the server. I thought
> this ha
On Sat, Nov 27, 2010 at 13:18, Don Wieland 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.* from Members m
> -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 backtick
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 un
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 wh
On Sat, Nov 27, 2010 at 12:30, Don Wieland 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
> m.`Preferred_First_Name` LIK
On 2010-11-27, at 12:30 PM, Don Wieland 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
> m.`Preferred_First_Name`
On Sat, Nov 27, 2010 at 12:50, Asmann, Roland 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 we've seen is your
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
> > wrote:
> > > Hi all,
> > >
> > > I am playing around with PHP and BBCodes and have found some regex's
> > > that should transform my BBCode into correct
On Sat, Nov 27, 2010 at 12:36, Daniel P. Brown
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 directories with rel
On 27-11-10 17:24, Daniel P. Brown wrote:
> On Sat, Nov 27, 2010 at 08:57, Asmann, Roland
> wrote:
> > 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 t
On Fri, Nov 26, 2010 at 19:03, Kirk Bailey wrote:
>
> I need a routine that will return a list of every directory immediately
> under the current directory- but nothing else, just a list of directories, 1
> level deep, NO FILES, no listing of current dir or prior dir either.
Simple:
'.$d
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 lin
On Sat, Nov 27, 2010 at 08:57, Asmann, Roland wrote:
> 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 rege
On 26/11/10 16:54, Richard Quadling wrote:
> On 26 November 2010 15:12, Tom Hendrikx wrote:
>> On 26/11/10 15:54, Richard Quadling wrote:
>>> On 25 November 2010 21:30, Tom Hendrikx wrote:
Hi,
I noticed that the mail() function in php 5.3.3 on gentoo linux triggers
a warning w
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 I'
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;
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...@cbn
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 upd
On Fri, 2010-11-26 at 20:27 -0500, Bastien wrote:
>
>
>
> On 2010-11-26, at 7:33 PM, Adam Richardson wrote:
>
> > On Fri, Nov 26, 2010 at 7:03 PM, Kirk Bailey
> > wrote:
> >
> >> Hello all, my name is Kirk Bailey, and I am new to php, so please be
> >> forbearing. I code in python, and am t
29 matches
Mail list logo
