[PHP-DB] Converting Date Form Fields

2001-11-16 Thread Zach Curtis
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 additional

RE: [PHP-DB] Converting Date Form Fields

2001-11-16 Thread Zach Curtis
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: RE: [PHP-DB

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread Zach Curtis
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 generate new random

Re: [PHP-DB] # of Records in Table

2002-01-23 Thread Zach Curtis
-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 retrieve the value

RE: [PHP-DB] # of Records in Table

2002-01-23 Thread Zach Curtis
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

RE: [PHP-DB] # of Records in Table

2002-01-23 Thread Zach Curtis
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

RE: [PHP-DB] # of Records in Table

2002-01-23 Thread Zach Curtis
, the 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

RE: [PHP-DB] # of Records in Table

2002-01-24 Thread Zach Curtis
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

[PHP-DB] NULL Values

2002-01-31 Thread Zach Curtis
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 wrong? Thank you. Zach Curtis POPULUS -- PHP Database Mailing List

[PHP-DB] Why NULL?

2002-02-01 Thread Zach Curtis
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 wrong? Thank you. Zach Curtis POPULUS -- PHP Database Mailing List

RE: [PHP-DB] Why NULL?

2002-02-01 Thread Zach Curtis
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 # partial

[PHP-DB] Insert, Arrays, Null

2002-04-05 Thread Zach Curtis
]' ; 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

RE: [PHP-DB] Insert, Arrays, Null

2002-04-05 Thread Zach Curtis
- 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

RE: [PHP-DB] Insert, Arrays, Null

2002-04-05 Thread Zach Curtis
. 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