I think it an issue with including multiple sql commands in one
as i see it...:
the drop table bit is one coomand and the create table is one
When i run these with or with the seperating ; it comes back with the
What i am trying to do is in thery simple.
Dump structure and dat from a table with drop table command to a .txt
then load it back in via my script.
I have tried infile, file() and straight forward global var to no
4 hours of searching the net has'nt yeild any working light on this
issue and i am confident this is not rocket science just me giong about it
the wrong way.
The load from file would be the best result for me.
Any pointer and or code example would be most appreiciated.
Date: Sunday, May 26,
Subject: Re: [PHP-DB]
db sql issue from var
Well, where is your ';'? At the end of the statement? You
terminate queries with semi colons when talking directly to the
Just remove it.
On Sun, 26 May 2002,
Dave Carrera wrote:
> Hi All
> I have found the
problem from my last post and need to know how to solve
> Example sql var:
> When i
run the script i get
> Mysql error near ';' create
> So how do i run this command from my script to
include the ; as part of the
> phpmyadmin copes
with this ok so it must be able to be done.
> Thanks for any
help in advance
> Dave C
PHP Database Mailing List (http://www.php.net/)
unsubscribe, visit: http://www.php.net/unsub.php