Paul Chvostek writes:
> The only catch is ... it won't go in PHP. The code looks fine, and I > suspect it's just a permission problem. Indeed it seems that you need to have CREATE to do that. There might be a good reason for it, but the only thing I can think of is disk usage. > Do I *realy* need database CREATE permission on the db server even to > create TEMPORARY tables? Or would I be ahead to simply slurp all the > data into an array in PHP and sort it there? Well, I guess it depends on what you need to do. One possibility would be to have a database that you only use for temporary tables, and give the user CREATE on that. It's a pretty clean solution, except that it'd give you two rows in mysql.db instead of just one, and you'd have to use database.table[.column] when accessing it. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
