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
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
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
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
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
-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
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.*
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
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
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
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
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.
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
13 matches
Mail list logo