? Bastien phps...@gmail.com wrote in message
news:962f0fd6-0eaa-495a-831e-da05bc1ab...@gmail.com...
On 2010-11-26, at 7:46 PM, None abcdef...@mailinator.com wrote:
?Could be a silly question, but i can't find a method to use placeholder
(MySqli) without passing by reference (bind_param) or
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: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 Database Mailing List (http://www.php.net/)
To
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 Database Mailing List
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
My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE `name` =
'$name'” occurs will $_SESSION['referral_clients_reference'] be populated with
the mysql_insert_id() value? If not, should I just query for it? Ron
mysql_query(INSERT INTO `referral_clients` ( `reference` , `name`
Read through this:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html, especially
the last 2 paragraphs.
On Sun, Nov 28, 2010 at 12:40 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE
`name` = '$name'”
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.*