Re: [PHP] PHP: mysql_query()

2001-08-14 Thread Alnisa Allgood
At 5:25 PM +0200 8/14/01, _lallous wrote: >I have PHPMyAdmin 2.21 >I only see "GO" button, where can I upload my SQL file? > Well my ISP uses PHPMyAdmin 2.10, which I can't imagine would be that different from 2.21. Basically, if I load, and click on the database name in the left top corner:

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread _lallous
I have PHPMyAdmin 2.21 I only see "GO" button, where can I upload my SQL file? "Alnisa Allgood" <[EMAIL PROTECTED]> wrote in message news:p05100309b79edae8263f@[63.202.15.82]... > At 4:05 PM +0200 8/14/01, _lallous wrote: > >Basically I have PHPMyAdmin... > >If I am to paste the 33,000+ lines SQL

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread Alnisa Allgood
At 4:05 PM +0200 8/14/01, _lallous wrote: >Basically I have PHPMyAdmin... >If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more >than 30secs to execute it which will make everything fail! >Anyway, I solved it. Check the recent post in the same thread about SQL2PHP >script. >

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread _lallous
Basically I have PHPMyAdmin... If I am to paste the 33,000+ lines SQL query the PHPMyAdmin would take more than 30secs to execute it which will make everything fail! Anyway, I solved it. Check the recent post in the same thread about SQL2PHP script. "Alnisa Allgood" <[EMAIL PROTECTED]> wrote in m

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread Alnisa Allgood
At 2:21 PM +0200 8/14/01, lallous wrote: >I can't execute MySql via system() I have no rights! > Generally ISPs either give you shell rights or access to PHPMyAdmin, if they give access to a MySQL database. Otherwise, you'd never be able to add tables, or modify data. If PHPMyAdmin is installe

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread lallous
om file and > execute it. > > do > system ( "mysql < sql.fie"); > or > `mysql < sql.fie`; > > dont forget to use -D and -p if User is required. > > - Original Message - > From: "lallous" <[EMAIL PROTECTED]> > To: <[EMAIL

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread Ben-Nes Michael
lt;[EMAIL PROTECTED]> Sent: Tuesday, August 14, 2001 1:29 PM Subject: Re: [PHP] PHP: mysql_query() > No actually I have a .SQL file that is a complete dump of my database. > All i want to do is the execute with mysql_query() the whole .SQL which will > create databases and tables a

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread lallous
No actually I have a .SQL file that is a complete dump of my database. All i want to do is the execute with mysql_query() the whole .SQL which will create databases and tables and fillin fields! "Ben-Nes Michael" <[EMAIL PROTECTED]> wrote in message 004701c124a0$e690c860$[EMAIL PROTECTED]">news:0

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread Ben-Nes Michael
You cant do this. Its even recommended to drop the `;' from the end of the sql command. You can go around using array to store the sql statements and use foreach to run mysql_query with thee sql statement. But I don't think its right way to do thing ! If you intention was to do update one afte