Re: db sql issue from var

Hi Rasmus I think it an issue with including multiple sql commands in one var... as i see it...: the drop table bit is one coomand and the create table is one command. When i run these with or with the seperating ; it comes back with the mysql error. What i am trying to do is in thery simple. Dump structure and dat from a table with drop table command to a .txt file then load it back in via my script. I have tried infile, file() and straight forward global var to no avail. 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. Thank You Dave C -------Original Message------- From: Rasmus Lerdorf Date: Sunday, May 26, 2002 16:20:39 To: Dave Carrera Cc: php List Subject: Re: [PHP-DB] db sql issue from var Well, where is your ';'? At the end of the statement? You don't terminate queries with semi colons when talking directly to the database. Just remove it. -Rasmus 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 it. > > Example sql var: > > $sql > When i run the script i get > > Mysql error near ';' create table...... > > So how do i run this command from my script to include the ; as part of the > sql. > > 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/) > To unsubscribe, visit: http://www.php.net/unsub.php > .