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
rs > Ben-Nes Michael - Manager > Tel: 972-4-6991122 > http://sites.canaan.co.il > -- > > - Original Message - > From: "lallous" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 14, 2001 12:59 PM > Subject: [PHP] PHP: mysql

Re: [PHP] PHP: mysql_query()

2001-08-14 Thread Ben-Nes Michael
t;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 14, 2001 12:59 PM Subject: [PHP] PHP: mysql_query() > Actually the mysql_query() seems to accept only one statement at a time. > > Any work around so i can do query suchs: > > mysql_query(" > SELECT

[PHP] PHP: mysql_query()

2001-08-14 Thread lallous
Actually the mysql_query() seems to accept only one statement at a time. Any work around so i can do query suchs: mysql_query(" SELECT 1+1; SHOW DATABASES; USE database1; SELECT * FROM table1; "); Just multiple commands seperated with ';' ? (as if using the Mysql command prompt) -- PHP Gene