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
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 1+1;
SHOW DATABASES;
USE database1;
SELECT * FROM table1;
);
Just
Original Message -
From: lallous [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 1+1
, 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 and fillin fields!
Ben-Nes Michael [EMAIL PROTECTED] wrote
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
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
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.
You
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 query the
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:
9 matches
Mail list logo