Mchl

FOr exampe simplexml has attributes() method: http://www.php.net/manual/en/simplexmlelement.attributes.php

See: simplexml, xmlreader and xmlwriter extensions

That's exactly what I'm hinting at with these numbers (in case that's not clear)

For your consideration: There are 95 printable ASCII characters. To store all possible 50 character long strings you need (50^95)*50 = 1.26*10^163B = Do you have that much storage avialable?

mysqli and PDO are both PHP extensions (just like mysql library you used is). They can be enabled and disabled on demand, but very often are enabled by default. The php manual has relevant instructions in each case. To see what extensions you have currently enabled use phpinfo

WE've an irc channel at irc.phpfreaks.com. Join in.

Welcome and thanks for sharing. You might be interested to learn about mysqli which is currently recommended API for connecting to MySQL from PHP.

What's that even supposed to mean??

Use mysql_error to see if/what about mysql complains.

These are not ASCII codes. These are HTML entities. Use html_entity_decode

This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=308048.0

The phrase you need to google search for is 'database replication'. Not sure if SQLite is capable to do it though. Maybe there's some other solution for mobile apps. Definitely app design board, moving there.

What is the column datatype?

Note: You can also use YYYYMMDD format without quotes. SELECT needs_id, email_id, status, name, email FROM needs WHERE created_sort BETWEEN 20100701 AND 20100805

Put dates in quotes, otherwise MySQL will do the substraction (2010-07-01 = 2002) SELECT needs_id, email_id, status, name, email FROM needs WHERE created_sort BETWEEN '2010-07-01' AND '2010-08-05'

Go to your profile, select 'Modify Profile' > 'Look and Layout', check 'Return to topics after posting by default.'

Regenerate session id on each request

Yes you can use it. It uses MySQL's LAST_INSERT_ID() function, and as such is very reliable (as long as you know about it's limits as described in manual)

echo sprintify($urls['default'], 46, 464, 46);

You can also declare argument to be passed by reference, which makes it sort of IN/OUT argument http://www.php.net/manual/en/language.references.pass.php

It's not problem with MySQL, but with your PHP code (which you should paste here). Alsp please familiarise yourself with how arrays are used in PHP Click here: array

Load both files into database and do comparing using SQL features.

First of all you should ask your host if they even allow for such changes. It might be, that they block all ports except 80 and 443 on their firewall.

Start here: http://en.wikipedia.org/wiki/Index_%28database%29 http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html

My inner child. Your inner child is hairy