of sync from ad hoc update queries).
- Original Message -
From: [EMAIL PROTECTED]
To: Douglas Forrest [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 7:54 AM
Subject: Re: TIMESTAMP not acting as I'd like
At 07:43 06/03/2002 -0500, you wrote:
Thanks, I think I am complicating things too
You can't in a single SQL statement in MySQL: MySQL does not allow updates
based upon joins.
Program around it using whatever language (perl, php, etc.) that you're
running the SQL statements from.
- Original Message -
From: Vadim Kulikov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
No closing quotes in prepare.
Also, I've never seen code that's looks quite like that; this may be
cleaner:
$sth=$dbh-prepare(SELECT Contacts FROM Info WHERE Name=%$sname%);
$sth-execute();
- Original Message -
From: Dan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday,
Oops! And switch = to like and add quotes:
$sth=$dbh-prepare(SELECT Contacts FROM Info WHERE Name like '%$sname%' );
$sth-execute();
- Original Message -
From: Douglas Forrest [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 12, 2002 4:16 PM
Subject
single quotes must be proceded by \ -- use PHP's addslashes function on
the field before insert:
field = addslashes(field);
see http://www.php.net/manual/en/function.addslashes.php
- Original Message -
From: Tim Thorburn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January