Re: [PHP] Writing MySQL Update Query with NULL value

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

Re: [PHP] Writing MySQL Update Query with NULL value

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' ..., suffix=$s

Re: [PHP] Writing MySQL Update Query with NULL value

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 = $_PO