pugboy

I have an XML file that is ~50MB, and is likely to grow to 100MB+ in the next 6 months... I basically need to take this XML file and read the entries and store them in a database for access in a website. I know how to use SimpleXML to do the reading/writing to the database, but apparently loads the entire thing into an object-- less than ideal for huge files. I have a dedicated server which I can do the processing on if needed and it has a memory limit of 32MB. It has 1GB of RAM, so I assume I can probably increase the memory limit if needed... I am not very familiar with server administration, but that is for another topic... What would be the best way to process this XML file? I have looked around a bit and it looks like a SAX parser or XMLReader could work... If possible, I would like to use SimpleXML (because it is a lot easier to use), but I guess I could go for any framework or parser that worked.

Ok, thanks. Looking at the error log now... EDIT: No errors in the log... The command seems to not be executing or something....

Where could I find the error logs? I have tried using exec and system with and without full paths.

Oh, sorry. Can you edit the title, or am I able to?

Can anyone help? Not getting any response on IRC either

I have a dedicated server running Apache and OpenVZ, and would like to run a simple start/stop VPS script through exec, system, or whatever. I have tried ALL of the commands, putting the actual start command inside of a SH file, and CHMODing the files to 777. No luck. How do you execute a command like VZCtl through the PHP functions? Thanks!

It was that simple? Wow. Thanks!

I have two columns: order AND orderid How can I get all of the pages (which is what I am trying to order) to be ordered by the order column, then ordered by their ID? I tried ORDER BY `order` ASC, `orderid` ASC but it does not come out correctly... An example of what I want but can't seem to get to work: Page ID name - Order - Order ID: home - / - 1 docs - / - 2 user - /docs/ - 1 developer - /docs/ - 3 administrator - /docs/ - 2 I can't get the array to be ordered like this: home docs user administrator developer Is there a better way to do what I am trying to achieve, or am I not using the multiple order by thing correctly?

http://www.htmlite.com/mysql011.php The following code would return anything that has Thomas in it. SELECT name, num, sup FROM mytable WHERE name LIKE '%Thomas%'

Hmm... Thanks. Time to change what character I use :/

Anyone know what the "order" of the characters are when using MySQL's order by feature? The "-" character seems like it is before "/", and I would like to know if I can change the order in which the rows are ordered. If it doesn't make much sense to you: "A" comes before "B" when using ORDER BY, but how do the other non-Alphanumeric characters get ordered?

if ( $check == "PASSWORD" ) { define('INCLUDED', true); ?> <div width="100%"><?php include 'userprofile.php'; ?></div> <div width="100%"><?php include 'index.php'; ?></div> Of course, you can change this by using stylesheets, etc. Real iFrames would not work without some session stuff because you cannot pass INCLUDED to either of the pages through an iFrame.

Like others have recommended, an external HDD is the way to go: http://www.google.com/products?q=1TB+external+hard+drive http://www.google.com/products?q=fireproof+safe The safe is for the HDD to go in-- that way, it is safe from fires, theft, etc.

An IFrame Of course, if you don't want scrollbars or for them to behave like separate pages, just create 2 DIVs inside the page.

Duh. How could I forget about that Thanks!