also, i would check that the user you are using for your mysql_connect in php has the permissions to do the create table, etc.
On 7/2/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:
Brian Menke wrote: > MySQL version 5.0.16 > > Windows XP > > PHP 5. > > > > I have this query that when I run it in SQL Manager 2005, it runs > beautifully, but when I stick the same query in Dreamweaver using PHP - > MySQL I get an error. I did some research and most roads lead to version > compatibility. Okay, that's fine, but I'm not sure how to fix it? Both > Dreamweaver and SQL manager are being run on the same box so I don't get the > version difference?? It's obviously the same version of MySQL. > <snipped> You're sending multiple commands in the 1 query. Break it up into separate queries and execute them 1 after the other. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]