RE: [PHP-DB] subdate

2003-02-05 Thread John W. Holmes
> please note the time "intervals" that are working. what i > want is to select only data that is two weeks old or younger. i did a > test with one day and it worked great. i inserted the two-week/14days > and neither of them worked. 1 month worked. i could not find anything > on php.net that

[PHP-DB] subdate

2003-02-05 Thread Addison Ellis
hello, thank you for your time. please note the time "intervals" that are working. what i want is to select only data that is two weeks old or younger. i did a test with one day and it worked great. i inserted the two-week/14days and neither of them worked. 1 month worked. i could not find an

[PHP-DB] PHP Database Abstraction Layer

2003-02-05 Thread Luke Woollard
I once read a great article in the first or second issue of http://www.phparch.com/ on database abstraction layers. At which point I used the tutorial as a starting point for creating a very similar structure I named dbWave. There are only minor differences and a postgresql driver is now included f

RE: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-05 Thread John W. Holmes
> I am a novice PHP dev having a strange issue with mysql_fetch_array. > For some reason, it is keeping data from previous queries in the array, > and > displaying it in the web page. > My development platform is Win2k SP2, Apache 1.3.23, PHP 4.3.0, > MySQL-MAX 3.23.47-nt. > Here is the

RE: [PHP-DB] Use php with sequel server2000?

2003-02-05 Thread John W. Holmes
> I have a situation where I have a network at work with only Sequel Server > 2000 on a Microsoft IIs Server. Is php a viable option for accessing a > sequel database? Sure... ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch

RE: [PHP-DB] Re: php-db Digest 5 Feb 2003 17:13:51 -0000 Issue 1661

2003-02-05 Thread John W. Holmes
> I would like to know how to get error messages to > appear if something goes wrong. Like if the mysql > finds the database account but fails to update the > table, finds the table but a unique entry is inputted > so can't add. I'd like to be able, if possible, to > customize the error message.

[PHP-DB] ``List-Unsubscribe''

2003-02-05 Thread Bruce Levick
``List-Unsubscribe''

[PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

2003-02-05 Thread Mike Hilty
Hello, I am a novice PHP dev having a strange issue with mysql_fetch_array. For some reason, it is keeping data from previous queries in the array, and displaying it in the web page. My development platform is Win2k SP2, Apache 1.3.23, PHP 4.3.0, MySQL-MAX 3.23.47-nt. Here is the code t

[PHP-DB] Re: php-db Digest 5 Feb 2003 17:13:51 -0000 Issue 1661

2003-02-05 Thread JeRRy
Hi, I would like to know how to get error messages to appear if something goes wrong. Like if the mysql finds the database account but fails to update the table, finds the table but a unique entry is inputted so can't add. I'd like to be able, if possible, to customize the error message. Could

[PHP-DB] Use php with sequel server2000?

2003-02-05 Thread Terry L. Ensley
I have a situation where I have a network at work with only Sequel Server 2000 on a Microsoft IIs Server. Is php a viable option for accessing a sequel database? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Jeff Pauls
try : if (strlen($products) == 0) { echo "nothing entered in field"; } http://www.php.net/manual/en/function.strlen.php Jeff - Original Message - From: "Aaron Wolski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 3:03 PM Subject: [PHP-DB] check

[PHP-DB] Oracle + PHP + Linux Red Hat {again}

2003-02-05 Thread Alberto Grájeda C.
Please, any idea to resolve my problem!!! I have the output: Connected to DataBase Oracle! Warning: OCIStmtExecute: ORA-03106: fatal two-task communication protocol error in /var/www/html/ora2.php on line 21 Warning: OCIFetchStatement: ORA-24374: define not done before fetch or execute and fetc

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Aaron Wolski
Well well well.. with the help of someone else pointing me in a different direction altogether here's what we came up with that totally works! $PRODUCT_SELECTED = TRUE; foreach($products as $value) { if(empty($value)) { $PRODUCT_SELEC

AW: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread [EMAIL PROTECTED]
hallo, look like here? http://www.php.net/manual/en/function.sizeof.php echo sizeof($HTTP_POST_VARS["myArrayObject"]); a.v.l -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 5. Februar 2003 02:54 An: Aaron Wolski Cc: [EMAIL PROTECTED] Be

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Hutchins, Richard
Somebody else replied with isset($varname). Try that. The count() function is working as expected (see http://www.php.net/manual/en/function.count.php). So maybe it's not the best choice for trying to find out what you want. > -Original Message- > From: Aaron Wolski [mailto:[EMAIL PROTECTE

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread jay
to find out if an array is empty use: empty() it must be unset NULL returns false 0 returns false it must be truly empty to return true... > Ok... well > > When I select the "select product" which has a option value="" it tells > me the count is one (1). If I select an ACTUAL product it tells

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Aaron Wolski
Ok... well When I select the "select product" which has a option value="" it tells me the count is one (1). If I select an ACTUAL product it tells me one(1) was select.. if I select two ACTUAL products it tells me two (2) products were selected. For SOME reason it doesn't seem to be recognizing t

Re: [PHP-DB] checking for empty array from a form field?grrrrrrrrrrr!

2003-02-05 Thread Mignon Hunter
I usually use: while(list($key,$value) = each($products)) { echo "$key:$value"; } On Wed, 2003-02-05 at 15:03, Aaron Wolski wrote: > Argh > > > HOW does one check for an array being empty from a form field?? > > Tried a billion different things and NOTHING works

RE: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Hutchins, Richard
What about: count($arrayname) Should tell you how many items are in an array. > -Original Message- > From: Aaron Wolski [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 05, 2003 4:04 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] checking for empty array from a form field? > gr

[PHP-DB] calendário

2003-02-05 Thread Rui Miguel Palma
Eu tenho dois um para os meses e outros para os anos, como faço para garantir que o utilizador não possa escolher um ano já passado, e durante o presente ano apenas os meses seguintes e o actual. Desde já obrigado __ Rui Palma ICQ#

Re: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Mark
First try isset($product) to see if it's being POSTed or GETted properly. You might need to use $_POST['products'] or $_GET['products']. --- Aaron Wolski <[EMAIL PROTECTED]> wrote: > Argh > > > HOW does one check for an array being empty from a form > field?? > > Tried a bi

Re: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread jay
if empty($products) echo "its empty"; else echo "its not empty"; jay merritt [EMAIL PROTECTED] [EMAIL PROTECTED] Quoting Aaron Wolski <[EMAIL PROTECTED]>: > Argh > > > HOW does one check for an array being empty from a form field?? > > Tried a billion different t

[PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

2003-02-05 Thread Aaron Wolski
Argh HOW does one check for an array being empty from a form field?? Tried a billion different things and NOTHING works I've tried: if ($products == "\n") { echo "hello"; } else { echo "bye"; } if ($products == "") { echo "hello"; } else {

[PHP-DB] $_FILES missing path

2003-02-05 Thread Squirrel User
print_r($_FILES) doesn't show full path of the filename I selected. I'm not trying to upload but just need to be able to open the file for viewing. Help. - This mail sent through ISOT. To find out more about ISOT, visit http://isot.com -- P

Re: [PHP-DB] Argh ! array help required :(

2003-02-05 Thread Jason Wong
On Thursday 06 February 2003 01:13, Aaron Wolski wrote: > Hi All, > > Again.. a little off topic - sorry (again!). > > Have a form that allows me to select a bunch of product names from a > drop down combo box. > > I'm trying to create code like "in ('Product name1','Product Name2) to > be inserted

RE: [PHP-DB] odbc query with single quote in string

2003-02-05 Thread Squirrel User
The 1st one didn't work, but the 2nd one did work. Fantastic! Thanks alot, you saved me from frustrations. Quoting "John W. Holmes" <[EMAIL PROTECTED]>: > > I'm having problem querying a table with a field value containing an > > appostropy, please help. Using ODBC to connect MSAcess database

[PHP-DB] Argh ! array help required :(

2003-02-05 Thread Aaron Wolski
Hi All, Again.. a little off topic - sorry (again!). Have a form that allows me to select a bunch of product names from a drop down combo box. I'm trying to create code like "in ('Product name1','Product Name2) to be inserted into an SQL statement. I figured that since $products was ALREADY

Re: [PHP-DB] UPDATE doesn't work

2003-02-05 Thread Le Hoang
Thank Jason! It counts now. So if i want to make something like Most view tutorial is $row[title] << How can i do this? Regards, - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 1:44 PM Subject: Re:

Re: [PHP-DB] Help with select box - multiple...

2003-02-05 Thread Jeffrey_N_Dyke
You can take the selected items posted to your page and use in_array() to search for the current item as your code creates the list. this is a chunk of code that i use to do the same thing. I wrote this a long time ago, so there may be better ways to do thisbut it works. ;-) <> if (in_array

[PHP-DB] Help with select box - multiple...

2003-02-05 Thread Aaron Wolski
Hi All, Sorry to be a pain on this one as it is sorta off topic.. but any help would be awesome. I'm creating a report for Product Popularity in which the Admin is present with a form and they have the ability to select A product or multiple products from a drop down combo box. The form is su

[PHP-DB] Re: vaiable from one page to another

2003-02-05 Thread J.Veenhuijsen
Try p.php: //Not echo($fname); ?> Jochem Bismi Jomon wrote: hi, i hav two programs , p.php: echo($fname) ?> i tried these programs and i didnt get the value of the variable in another php program. butit is not getting. one our friend told to put like echo $_post(fna

[PHP-DB] Re: vaiable from one page to another

2003-02-05 Thread Bastian Vogt
Hi, you have to write it exactly like this: echo $_POST['fname']; HTH, Bastian > > echo $_post(fname) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] vaiable from one page to another

2003-02-05 Thread Jason Wong
On Wednesday 05 February 2003 16:36, bismi jomon wrote: > hi, > > i hav two programs , > > > > > > > > > > > > > > p.php: > > > > echo($fname) > > ?> > > i tried these programs and i didnt get the value of the variable in another > php program. butit is not getting. one our friend told to

[PHP-DB] vaiable from one page to another

2003-02-05 Thread bismi jomon
hi, i hav two programs , p.php: echo($fname) ?> i tried these programs and i didnt get the value of the variable in another php program. butit is not getting. one our friend told to put like echo $_post(fname) but it is also not working. now getting the error about post ar