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:004701c124a0$e690c860$[EMAIL PROTECTED]...
> 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 after other then you should use
locks
> or use Postgres :)
>
> --------------------------
> Canaan Surfing Ltd.
> Internet Service Providers
> 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_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 multiple commands seperated with ';' ? (as if using the Mysql
command
> > prompt)
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
