[PHP-DB] Re: Just can't get it to work.. variables

2005-03-30 Thread David Robley
Gavin Amm wrote: Hi All, I just can't for the life of me get the variable to output a value from the array: (all preceding script in place to make this work..) The start date retrieved from the database is, for example, 20050412 (mmdd). The example output for each variable (w/o

Re: [PHP-DB] Slow access Apache + PHP + MySQL

2005-03-30 Thread Martin Norland
Jennifer Goodie wrote: -- Original message -- From: Andre Matos [EMAIL PROTECTED] [snip] The system administrator told me that could be the PHP session, but again, he also was not complete sure about this. I have no idea what this even means. I take it to mean

Re: [PHP-DB] Re: Just can't get it to work.. variables

2005-03-30 Thread Martin Norland
David Robley wrote: Gavin Amm wrote: [snip] That would indicate that you are actually saying: $monthVal = $monthName[04]; where the 04 is actually a string; you have no element '04' in your array. Cast $monthInt to an integer before you use it as an array element. Alternatively, if you are using

[PHP-DB] MySQL Subquery problems...

2005-03-30 Thread NIPP, SCOTT V \(SBCSI\)
I am working with one of our Oracle DBAs to have him try and help me get a couple of queries working. The problem is that in looking at the documentation for MySQL it seems that what we are attempting should work. Unfortunately, it doesn't. Here is what we are trying... mysql SELECT

RE: [PHP-DB] MySQL Subquery problems...

2005-03-30 Thread Bastien Koert
only mysql 4.1+ supports subqueries..if you version is lower it won;t work Bastien From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] MySQL Subquery problems... Date: Wed, 30 Mar 2005 09:25:36 -0600 I am working with one of our Oracle DBAs to have him

RE: [PHP-DB] MySQL Subquery problems...

2005-03-30 Thread NIPP, SCOTT V \(SBCSI\)
Yup... Thanks, I just discovered that myself. Thankfully the docs have instructions on how to write a subquery for earlier versions that don't support subqueries. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -Original Message-

[PHP-DB] $_SESSION

2005-03-30 Thread veditio
To the Group: Can anyone recommend a good, thorough online tutorial concerning sessions? I'm trying to create a site that operates independently of cookies, using $_SESSION[variables] to pass information from page to page AND avoid using the SID in the URL. Nothing is working the way that I

RE: [PHP-DB] $_SESSION

2005-03-30 Thread Bastien Koert
can you post some code and give a better description than ' it doesn't work ' bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net (PHP) Subject: [PHP-DB] $_SESSION Date: Wed, 30 Mar 2005 21:41:09 + To the Group: Can anyone recommend a good, thorough online tutorial concerning sessions?

[PHP-DB] strtotime: Last Month problem

2005-03-30 Thread Shay
Hi, I'm trying to use strtotime(last month), strtotime(-1 month), or strtotime(1 month ago) to get the last month. However, it keeps returning March, not February. This started happening just yesterday, March 29th. This obviously has something to do with February's shorter amount of days, since

RE: [PHP-DB] Re: Just can't get it to work.. variables

2005-03-30 Thread David Robley
Gavin Amm wrote: Yeah, I ended up doing that (associative array) then reading your e-mail.. Oh well, thanks. I couldn't cast the var as an int. in the database it's setup as a timestamp(8) (mmdd), not sure why I set it up as such.. Cheers, Gavin I guess I didn't fully explain that I

RE: [PHP-DB] strtotime: Last Month problem

2005-03-30 Thread Bastien Koert
try the mktime function bastien From: Shay [EMAIL PROTECTED] Reply-To: Shay [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] strtotime: Last Month problem Date: Wed, 30 Mar 2005 15:02:27 -0700 Hi, I'm trying to use strtotime(last month), strtotime(-1 month), or strtotime(1 month ago)

RE: [PHP-DB] Re: Just can't get it to work.. variables

2005-03-30 Thread Gavin Amm
Yeah, I ended up doing that (associative array) then reading your e-mail.. Oh well, thanks. I couldn't cast the var as an int. in the database it's setup as a timestamp(8) (mmdd), not sure why I set it up as such.. Cheers, Gavin -Original Message- From: Martin Norland [mailto:[EMAIL