it going out 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
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]>
S
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
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: Saturda
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, Ja
