MySQL has xml support...have you looked at the docs at mysql.com for anything that might help you input the data directly...
B i g D o g ----- Original Message ----- From: "Peter Lovatt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 3:03 PM Subject: [PHP-DB] XML > Hi > > I am looking at a project using XML to import and export data into MySql > directly or using php. The datasets are quite large (40-50 million records) > > I haven't used XML before. > > Does it take long to work out how to use php/XML? Are there any problems > working with large datasets? > > Thanks > > Peter > > > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: 27 June 2002 17:43 > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: [PHP-DB] Re: PHP and msql Error > > > > > > The error is in your MySql statement. Sounds like you are calling the > > wrong data field / column. Check you spelling and syntax to make sure > > all of that is in order. If you can't find it, copy it and post it. > > We'll help you out > > > > gl -- Seth > > > > Comp Boy wrote: > > > > > I am getting the following error: > > > > > > Warning: Supplied argument is not a valid mSQL result resource in > > > /usr/local/apache/htdocs/inc/listings.inc on line 24 > > > > > > listings.inc: 24 > > > $numRows = msql_numrows( $result ); > > > > > > The manual on php.net says that it takes no variables > > msql_numrows(void) > > > however it says it is another version of msql_num_rows(int msql); > > > > > > The code I am trying to run, runs perfectly fine on another one of our > > > systems. I was just setting up a development server and now I > > am getting > > > this problem. The specs are the same except for the version of Apache > > > production is 1.3.9 and development is 1.3.26 > > > > > > PHP vesrion 4.1.2 > > > > > > ./msqladmin version > > > Version Details :- > > > msqladmin version 2.0.11 > > > mSQL server version 2.0.11 > > > mSQL protocol version 23 > > > mSQL connection Localhost via UNIX socket > > > Target platform Linux-2.2.14-5.0-i686 > > > > > > PHP was configured: > > > ./configure --with-apxs=/usr/local/apache/bin/apxs --with-msql > > > > > > msql was a default install. > > > > > > Does anyone know what I did wrong? Do I need to recompile with some > > > different options? > > > > > > TIA > > > Jason > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php