I have attempted to insert data from an array into a table in which the
values are string and numeric or NULL. The string values are no problem
($password, $int_id), but when I try to insert a value which may be either
numeric or NULL (cusa, cusb, cusc) I can't produce a query that accounts for
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Insert, Arrays, Null
I have attempted to insert data from an array into a table in which the
values are string and numeric or NULL. The string values are no problem
($password, $int_id), but when I try to insert a value which may be either
numeric or NULL
-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 8:18 AM
To: 'Zach Curtis'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Insert, Arrays, Null
When you say ...account for either a numeric or NULL value ..., do you
mean SELECT a value that could be NULL?
If so, the query
; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Insert, Arrays, Null
The data being read dynamically into the array could contain values which
are NULL (the default) or numeric (if a numeric value exits). However, the
query is using a INSERT INTO and I can't seem to form this query to account
. Is there an advantage to
using the VALUES clause?
Thank you for your assistance.
Zach
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 8:42 AM
To: 'Zach Curtis'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Insert, Arrays, Null
Is there some reason you
Using VALUES() is faster
Nothing really wrong with SET clause, though
-Original Message-
From: Zach Curtis [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:34 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Insert, Arrays, Null
Terrific! I tried an example
