Terrific! I tried an example assigning the array to a variable using the
if-else statements before creating the query. Now the table contains values
and NULLs.

Is there something wrong about using the SET clause version? I like to see
the assignments for each column/value side by side. 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 are using the SET-clause version of INSERT?
Also, given that cusa, cusb, cusc are INTs, DO NOT enclose in single-quotes
You can do as I've done in the past; check for value of cusa and create
INSERT accordingly:

<?php
if (isset($data_array["cusa"]) ) $cusa = $data_array["cusa"];  \\ repeat for
each variable
else $cusa = "NULL";                    \\ repeat for each variable

$query = "INSERT INTO mytable (cusa,cusb,cusc) VALUES($cusa,$cusb,$cusc)";

?>

-----Original Message-----
From: Zach Curtis [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:29 AM
To: Rick Emery; [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
for either a NULL or numeric value.


Zach

-----Original Message-----
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 is "SELECT * FROM mytable WHERE cusa IS NULL || cusa >= 0"



-----Original Message-----
From: Zach Curtis [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 9:11 AM
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 (cusa, cusb, cusc) I can't produce a query that accounts for
either a numeric or NULL value. I have tried various combinations of queries
that include using ', ", and ., in the query, however those queries usually
result in either NULL values not be inserted into the table, a parse error,
or a failed query.


# partial mysql table definition
password CHAR(8) NOT NULL,
int_id VARCHAR(4) NOT NULL,
cusa TINYINT UNSIGNED NULL,
cusb TINYINT UNSIGNED NULL,
cusc TINYINT UNSIGNED NULL,
PRIMARY KEY(password, int_id)

// partial php script

// ***************************************
// the following (example) values are variable b\c the data are being read
into this script dynamically

// alpha values
$password = "test";
$int_id = "a";
// numeric or NULL values
$data_array = array();
$data_array["cusa"] = NULL; // can be numeric or NULL
$data_array["cusb"] = 0; // can be numeric or NULL
$data_array["cusc"] = 9; // can be numeric or NULL


// ***************************************
// this results in cusa = 0 in the table and not NULL
$query = "INSERT INTO s999dat SET
                password='$password',
                int_id='$int_id',
                cusa='$cus_array[cusa]',
                cusb='$cus_array[cusb]',
                cusc='$cus_array[cusc]'
                ";

Any thoughts on how I can create this query that can account for either a
numeric or NULL value coming from the dynamic array? Thank you.

_________________
Zach Curtis
Programmer Analyst
POPULUS
www.populus.com
_________________


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to