Step through your code. What value does $rexpiry have? What do you see when you do print_r($Date) ?? Troubleshoot...
---John Holmes... > -----Original Message----- > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 10:36 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] Extracting from an Array > > Hi John, > > <?php > /* Using PostgreSQL: it needs $numrows and $row=0 to work. Also set it to > choose only one record in db to simplify testing. Date was set to 10 > May > 1998*/ > // $db conect stuff > > $query = "SELECT rexpiry FROM rap WHERE rid = '1024'"; > $result = pg_exec($db, $query); > if (!$result) {printf ("ERROR"); exit;} > $numrows = pg_numrows($result); > $row = 0; > > $Row = pg_fetch_array($result,$row); > $rexpiry = $Row['rexpiry']; > $Date = explode(" ", $rexpiry); > $Year = $Date[3]; > pg_close($db); > print $Year; > > /* 'Year' returns something like "1" */ > ?> > > Btw, according to the error message, there's no such function as 'RIGHT' > in > PostgreSQl. (Sorry about referring to the string as an array in a session > variable -- I've extracted the code from some other stuff that I had been > working on.) > > Sigh. I'd like to know why this doesn't work: how I can extract the last > few > characters from the array. > > Regards, > Andre > > On Wednesday 12 June 2002 09:34 pm, you wrote: > > I don't understand why you keep referring to the string as an array in a > > session variable. Can you show me how you are issuing the query, > > fetching the result, assigning it to the session, etc... > > > > It should be as easy as this: > > > > <? > > $result = MySQL_query("SELECT RIGHT(date_column,4) AS Year FROM > > tablename"); > > while($row = MySQL_fetch_array($result)) > > { > > echo $row['Year']; > > } > > ?> > > > > You know you could write a simple little script to convert this into the > > correct format for a date column. > > > > If you want to do sorting by year, you can try this: > > > > SELECT date_column FROM table ORDER BY RIGHT(date_column,4) ASC > > > > ---John Holmes... > > > > > -----Original Message----- > > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, June 12, 2002 9:32 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: [PHP] Extracting from an Array > > > > > > Hi John, > > > > > > Yup. I know now that I've caused myself all sorts of grief when I set > > > > it > > > > > to > > > varchar. If I recall correctly (and I set this up four months ago when > > > > I > > > > > began coding) I couldn't get it format without the crummy little > > > > dashes. > > > > > So I > > > set it to a string. > > > > > > Much coding later, I realize that I could solve this problem by > > > > changing > > > > > it > > > back to 'date' type, but as i'm writing, I remember that this > > > > particular > > > > > array has only one use - and in a string format it's easier to > > > > manipulate. > > > > > [Bad reason, I guess with hindsight -- perhaps it's a hangover from my > > > Paradox PAL days where I needed to format the string for 'other > > > purposes'.] > > > > > > Your last point is precisely what I'm writing about: it IS all messed > > > > up! > > > > > So, > > > the upshot is - live with it, and don't use it; or change it. Hmmm. I > > > > had > > > > > planned to sort a column by 'Year', but it might be a case of > > > > 'overkill' - > > > > > - > > > the form is already loaded with enough options. > > > > > > Now that being said, this is more a problem of why can't I get ALL of > > > > the > > > > > last part of the array? Suppose I wanted to extarct something that was > > > > not > > > > > a > > > date like: $_SESSION['odd'] which was varchar in the format of > > > > "Session is > > > > > closed". Now if I wanted to extract the last part: 'closed' what I've > > > tried > > > wouldn't work. It would give me: "c" -- how would I get the rest of > > > > the > > > > > characters? > > > > > > Thanks for the advice, > > > Regards, > > > Andre > > > > > > On Wednesday 12 June 2002 08:25 pm, you wrote: > > > > What are the possible reasons that you "need it to be a varchar" ?? > > > > Do > > > > > > you realize how much extra work you are creating for yourself? Do > > > > you > > > > > > realize that you can have your users enter data in one format, and > > > > convert it to another format for MySQL? Do you realize you can use > > > > DATE_FORMAT() in your query to re-format the date back to dd-mm-YYYY > > > > if > > > > > > you want to? Do you realize that if you ever wanted to sort by this > > > > column, you'd be all messed up? It'll sort as a string, where "10" > > > > is > > > > > > less than "2". Do you realize what I'm trying to say?? > > > > > > > > ---John Holmes... > > > > > > > > > -----Original Message----- > > > > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > > > > Sent: Wednesday, June 12, 2002 8:15 PM > > > > > To: Lazor, Ed > > > > > Cc: [EMAIL PROTECTED] > > > > > Subject: Re: [PHP] Extracting from an Array > > > > > > > > > > Thanks Ed, > > > > > > > > > > Slight change -- I forgot that the delimiter was a 'space'. > > > > Anyway, I > > > > > > > still > > > > > get the first letter of the last part of the array. I guess what I > > > > > > > > need is > > > > > > > > > something that specifies a range as in something like this: > > > > > > > > > > $Year = $Date[3-whatever?]; > > > > > > > > > > Seems rather odd that with the string as varchar it does this. > > > > I've no > > > > > > > problem extracting various parts of a date from type 'date' but > > > > this > > > > > > wierd > > > > > > > > > date-thingy. . . how I wish I didn't need it as varchar. > > > > > > > > > > Anyway, thanks -- I plug away at it. > > > > > > > > > > Regards, > > > > > Andre > > > > > > > > > > On Wednesday 12 June 2002 07:09 pm, you wrote: > > > > > > $sql = "select fieldname from tablename"; > > > > > > $Results = mysql_query($sql, $DBLink); > > > > > > $Row = mysql_fetch_array($Results); > > > > > > $fieldname = $Row["fieldname"]; > > > > > > $Date = explode("-", $fieldname); > > > > > > $Year = $Date[2]; > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > > > > > > Sent: Wednesday, June 12, 2002 4:11 PM > > > > > > > To: [EMAIL PROTECTED] > > > > > > > Subject: [PHP] Extracting from an Array > > > > > > > > > > > > > > > > > > > > > I have a db field, type varchar, that is actually a 'date' > > > > > > > string formatted > > > > > > > as dd-mm-YYYY. I used type 'varchar' (rather than type > > > > > > > 'date') since I had to > > > > > > > accomplish other things with it. > > > > > > > > > > > > > > Now, however, I do need to extract the Year (the last four > > > > > > > digits in the > > > > > > > array). I've tried to access the array $_SESSION['expiry'] > > > > > > > but I don't know > > > > > > > how to explode this array to extract all characters in last > > > > > > > item after the > > > > > > > last separator : i.e. '-YYYY'. I've used "-" as the > > > > > > > separator, but I just > > > > > > > get the first number of the last part of the array, i.e.: > > > > '-Y'. > > > > > > > > > Is there a way of extracting all characters in that array? > > > > > > > > > > > > > > I've tried a bunch of combinations, but I obviously don't > > > > > > > understand the > > > > > > > basic mechanics of array manipulation or 'slicing'. If > > > > > > > someone could point me > > > > > > > to a good resource, or explain what I'm doing wrong, I would > > > > > > > greatly any > > > > > > > assistance. > > > > > > > > > > > > > > Tia, > > > > > > > Andre > > > > ************************************************************************ > > > > > > ** > > > > > > > > > * > > > > > > > > > > >* This message is intended for the sole use of the individual and > > > > > > > > entity > > > > > > > > > to > > > > > > > > > > > whom it is addressed, and may contain information that is > > > > > > > > privileged, > > > > > > > > > > confidential and exempt from disclosure under applicable law. > > > > If > > > > > > you > > > > > > > > > are > > > > > > > > > > > not the intended addressee, nor authorized to receive for the > > > > > > > > intended > > > > > > > > > > addressee, you are hereby notified that you may not use, copy, > > > > > > > > disclose > > > > > > > > > or > > > > > > > > > > > distribute to anyone the message or any information contained in > > > > the > > > > > > > > message. If you have received this message in error, please > > > > > > > > immediately > > > > > > > > > > advise the sender by reply email and delete the message. Thank > > > > you > > > > > > very > > > > > > > > > > much. > > > > > > > > > > -- > > > > > Please pray the Holy Rosary to end the holocaust of abortion. > > > > > Remember in your prayers the Holy Souls in Purgatory. > > > > > > > > > > May God bless you abundantly in His love! > > > > > For a free Cenacle Scriptural Rosary Booklet: > > > > > > > > http://www.webhart.net/csrb/ > > > > > > > > > -- > > > > > PHP General Mailing List (http://www.php.net/) > > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > > > Please pray the Holy Rosary to end the holocaust of abortion. > > > Remember in your prayers the Holy Souls in Purgatory. > > > > > > May God bless you abundantly in His love! > > > For a free Cenacle Scriptural Rosary Booklet: > > > > http://www.webhart.net/csrb/ > > -- > Please pray the Holy Rosary to end the holocaust of abortion. > Remember in your prayers the Holy Souls in Purgatory. > > May God bless you abundantly in His love! > For a free Cenacle Scriptural Rosary Booklet: http://www.webhart.net/csrb/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
