Re: [PHP-DB] XML From: B i g D o g (bigdog <email protected>)
Date: 06/27/02

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 <email protected>>
To: <php-db <email protected>>; <mysql <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
> info <email protected>
> tel. 0121-242-1473
> -----------------------------------------------
>
> > -----Original Message-----
> > From: user <email protected> [mailto:user <email protected>]
> > Sent: 27 June 2002 17:43
> > To: php-install <email protected>; php-db <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