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 s
ssage-
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
27;$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.
___
Yes, I did not receive any replies to that message yesterday. Here is my
code (condensed) as well. What ends up happening is that when I write a
variable for a field that did have data, for example "cus034a", to the db it
shows a value of "0" when I intended it to be "NULL".
Thanks.
Zach
# pa
o NULL values before iterating the loop
again. However, if I do this and the next record does not have a value for
"cus034a", the value in the db still ends up being "0".
$data_array["cus034a"] = NULL;
$data_array["sat01"] = NULL;
I must be doing something
o NULL values before iterating the loop
again. However, if I do this and the next record does not have a value for
"cus034a", the value in the db still ends up being "0".
$data_array["cus034a"] = NULL;
$data_array["sat01"] = NULL;
I must be doing something
my
knowledge and experience increases I hope to help those with questions. And
the wheel goes round and round.
Zach
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 2:02 AM
To: Zach Curtis
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records
more likely I am to get a reply. Then details can be given if needed, in
further correspondences.
I will give that AUTO_INCREMENT and SELECT MAX() a try as well.
Zach
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 3:27 PM
To: Zach Curtis
Cc
Excellent. That is more efficient (one select statement) than what I was
trying to do.
Zach
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 2:20 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
The key field is the password field, which is also the field that I would
like to retrieve for that last record.
Zach
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 2:08 PM
To: Zach Curtis
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of
houghts?
Zach
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 1:11 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
Zach,
> What syntax can I use to determine how many records are in a MySQL table
and
> then
, January 23, 2002 1:10 PM
To: Zach Curtis; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] # of Records in Table
does the table have an autoincrement column?
Jim Lucas
- Original Message -
From: "Zach Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Jan
ining their
password.
Zach
-Original Message-
From: matt stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 2:19 AM
To: 'Zach Curtis'; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Decrypting PASSWORD() from MySQL
I would go for the "
/decipher
Thanks,
Zach
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12:56 PM
To: Zach Curtis
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Decrypting PASSWORD() from MySQL
Yet another example of ted's out-to-lunchness...
Use the m
PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12:29 PM
To: Zach Curtis
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Decrypting PASSWORD() from MySQL
Well, it's (intended to be) difficult. Perhaps you can NULL it out and
have them put in a new password...
On Wed, 19 Dec
ot;Could not execute database query:" .
mysql_error() . "";
$row = mysql_fetch_array($result);
$userName = "$row[userName]";
$password = "$row[password]";
$email = "$row[email]";
Thank you.
Zach Curtis
Programmer/Analyst
POPULUS
--
PHP Database Mailing Lis
Ah, the join function...I see implode() will also perform the same task.
That was what I needed to do.
Thanks!
Zach
-Original Message-
From: matt stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 9:06 AM
To: 'Zach Curtis'; [EMAIL PROTECTED]
Subject: R
birthDate
with field type DATE (-MM-DD)? The part I do not know how to accomplish
is taking these form fields and then combining them into a date
field/format.
Thank you.
Zach Curtis
POPULUS
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
18 matches
Mail list logo