Re: XML

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" <pjln1@sunmaia.net> To: <php-db@lists.php.net>; <mysql@lists.mysql.com> 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 > info@sunmaia.net > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: user@domain.invalid [mailto:user@domain.invalid] > > Sent: 27 June 2002 17:43 > > To: php-install@lists.php.net; php-db@lists.php.net > > 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