[PHP-DB] Dealing with Namespace/Colon in SimpleXML

2007-10-26 Thread Andrew Darby
Hello, all. I'm trying to use SimpleXML to loop through an .xml file, but when I try to do the following, it chokes on the colon: foreach ($xml_data-dc:title as $item) { [do whatever here] } The element in the XML has a colon in it, i.e., dc:titleInteresting Book/dc:title Anybody know how

[PHP-DB] Processing google calendar feed (prefixed namespace issue)

2007-06-15 Thread Andrew Darby
Hello PHP people. I'm trying to use simplexml to gather info from a google calendar feed, and I've run into a problem where the google xml has a namespace prefixed to some fields, and I don't know how to deal with this colon. For instance: $xml_data = simplexml_load_file($xml); foreach

[PHP-DB] Permissions for mkdirs

2006-10-28 Thread Andrew Darby
Good people of php-db: Forgive me, this is more of a php than a php-db question, but here goes: In a little php/mysql application, I have users ftp over a folder full of images. When they register a folder that's not already in the MySQL db, it creates three different folders (thumb, medium,

Re: [PHP-DB] Permissions for mkdirs

2006-10-28 Thread Andrew Darby
the permissions (0777) to allow you to delete them before you can delete the folder... bastien From: Andrew Darby [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Permissions for mkdirs Date: Sat, 28 Oct 2006 17:18:47 -0400 Good people of php-db: Forgive me, this is more of a php than a php

[PHP-DB] Help! With MySQL CASE problem

2006-10-15 Thread Andrew Darby
Hello, all. I'm having a problem with a php/mysql app which is probably in the SQL, so please don't get angry at me. Basically, I have a CASE statement that works on my localhost, but doesn't seem to get recognised on the production server (i'm running php/mysql 5.x on my localhost, 4.x of both

[PHP-DB] Re: Help! With MySQL CASE problem

2006-10-15 Thread Andrew Darby
'heading', e.end_date, special FROM exhibition e WHERE e.end_date = UNIX_TIMESTAMP( ) ORDER BY CASE WHEN UNIX_TIMESTAMP( ) = e.begin_date THEN 'Coming Up' ELSE 'Now Showing' END , e.begin_date ASC I don't know why, however. Thanks for your indulgence, Andrew On 10/15/06, Andrew Darby [EMAIL

Re: [PHP-DB] Vexing Cookie Problem

2006-08-15 Thread Andrew Darby
Thanks, Chris. I tried this; no dice. On 8/14/06, Chris [EMAIL PROTECTED] wrote: Andrew Darby wrote: Hello, all. This is more of a php problem, but i'm not on the general list and um the cookie problem is part of a php/mysql application . . . . So, I have an application where university

Re: [PHP-DB] Vexing Cookie Problem

2006-08-15 Thread Andrew Darby
Chris, I retract that no dice. It did work after all. Thank you so very much. FYI, I was encountering the problem in both Firefox (1.5) and IE (6) on the PC. Again, thanks a lot. Andrew On 8/15/06, Andrew Darby [EMAIL PROTECTED] wrote: Thanks, Chris. I tried this; no dice. On 8/14/06

[PHP-DB] Vexing Cookie Problem

2006-08-14 Thread Andrew Darby
Hello, all. This is more of a php problem, but i'm not on the general list and um the cookie problem is part of a php/mysql application . . . . So, I have an application where university faculty can enter their publications in a scholarly database, but this data can also be entered by a proxy

[PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Andrew Darby
Hello, all. I don't know if this is a php-mysql question or just a mysql, but here goes: I have a list of DVDs that my library loans out, and I'd like to allow people to add comments to each item. Since this list gets regenerated periodically (it's extracted from another system, the library

Re: [PHP-DB] MySQL/PHP Left Join Question

2006-05-25 Thread Andrew Darby
Thanks to Bastien and TG for their suggestions. I'd been looking at it Bastien's way, but TG's is probably better suited to what I want to do. I'd forgotten about that possibility, cramming it all into an array . . . . Again, thanks for the help, Andrew p.s. I'd be curious about the relative

Re: [PHP-DB] Unable to Send Mail

2006-03-15 Thread Andrew Darby
maybe it's due to register_globals being set to off: http://www.phpnoise.com/tutorials/2/1 On 3/15/06, Paul Anderson [EMAIL PROTECTED] wrote: Please forgive me if this comes through twice. I am a new subscriber and the first send did not seem to work. We recently moved all our websites to a

[PHP-DB] stripslashes etc.

2006-03-02 Thread Andrew Darby
Hello, all. I'm getting a bit confused figuring out the best way to insert data into a db via web forms and then pull it out again safely. I know there's lots of information out there, but I was hoping someone could suggest a current, [easy!] best practice. Specifically, I have the following

[PHP-DB] Help with Variable Variables in Array

2006-02-20 Thread Andrew Darby
Hi, all. I can't quite figure out how to call the contents of a variable variable in a mysql_fetch_array result and was hoping someone could help . . . inside the fetch all rows while loop, i have the following: $right_row = $ . myrow . [' . $type . _title']; ($type is assigned elsewhere, but

Re: [PHP-DB] Help with Variable Variables in Array

2006-02-20 Thread Andrew Darby
[$tmp_fldname]; This should work, I haven't tested it. Naintara -Original Message- From: Andrew Darby [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 10:19 PM To: php-db@lists.php.net Subject: [PHP-DB] Help with Variable Variables in Array Hi, all. I can't quite figure out how