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]
