At 1:42 PM +1000 4/14/08, Chris wrote:
Your query should end up looking like:
$query = UPDATE phones set last_name='${last_name}',
first_name='${first_name}' ..., suffix=${suffix};
Why not this:
$query = UPDATE phones set last_name='$last_name',
first_name='$first_name' ...,
On Sun, Apr 13, 2008 at 10:24 PM, Bill Guion [EMAIL PROTECTED] wrote:
However, when I echo out this query, I get:
UPDATE 'phones' SET 'last_name' = Doe, 'first_name' = John, 'suffix' = ,
'phone' = 123-456-7890 WHERE 'phone_index' = 323;
Bill,
You're missing quotes around your data,
I'm trying to write a MySQL UPDATE query where one or more variables
may be NULL. So, I'm trying something like:
$last_name = $_POST['last_name'];
$first_name = $_POST['first_name'];
$suffix = $_POST['suffix'];
$suffix = empty($suffix) ? NULL : $suffix;
$phone = $_POST['phone'];
Bill Guion wrote:
I'm trying to write a MySQL UPDATE query where one or more variables may
be NULL. So, I'm trying something like:
$last_name = $_POST['last_name'];
$first_name = $_POST['first_name'];
$suffix = $_POST['suffix'];
$suffix = empty($suffix) ? NULL : $suffix;
$phone =
4 matches
Mail list logo
