[PHP-DB] MySQL creating new tables using wrong engine...

I have run into an issue where I keep getting InnoDB tables everytime I create a new table in PHPMyAdmin, and I want MyISAM tables. It's very annoying. Anyone got any suggestions as to what I might have done that made MySQL or PHPMyAdmin do this? -- Mark Benson http://homepage.mac.com

[PHP-DB] Forms...

Does anyone know if it is possible to have 'checkbox' elements in a form appear 'checked' or 'unchecked' when a page loads data from a MySQL data source? Can I use an attribute in the input tag to switch that? -- Mark Benson AIM - SilValleyPirate MSN - [EMAIL PROTECTED] Visit FlatPackMacs

[PHP-DB] Hyphens and MySQL

with an error in the syntax. I can't get around it by putting a slash in front of them (using 'addcslashes'), it will just not at all accept them. Are they the 'wrong' type of slash? Is there an easy way to search and replace/remove characters in a string in PHP? -- Mark Benson http

[PHP-DB] Re: MySQL version issue

perspectiuve on these things, I was stuck in my mysql_query brackets. Putting mind to matter using your tips it would actually be fairly simple to do that. Again thank you for providing an exit() to my stuck loop ;o) -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing

[PHP-DB] MySQL version issue

for the 'ON DUPLICATE KEY UPDATE' Query action? -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: HTTP Auth for PHPMyAdmin

into the MySQL server as either my normal 'dbadmin' user OR 'root' as only 'root' has alteration rights on the grant tables so stuff that is outside the auspices of normal admin is easier to carry out (i.e. doesn't involve me hacking the config.inc.php all the time). -- Mark Benson http

[PHP-DB] HTTP Auth for PHPMyAdmin

What do i need to do to enable proper HTTP authorisation for PHPMyAdmin? I enabled it in the config file, but it rejects my attempts to login. -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] PHP, MySQL and phpMyAdmin versions...

for the help on the 'ON DUPLICATE KEY UPDATE' thing, I didn't realise it was a new thing in MySQL 4.1.0! goes away to kick himself ;-) -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Spot the deliberate mistake...

]', nla_tag='0' This is passed in a PHP script so the line ending ';' is not present. I'm getting better at writing SQL statements but sometimes it just throws me a total curved ball! -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] Spot the deliberate mistake...

guess something doesn't work there. I also tried it with and without the line ending and it didn't work either way :). -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Using a loop on a result destroys array??

On Wednesday 24 November 2004 20:31, Mark Benson wrote: From the above code, Actually the above code would result in a parse error. There are no where-loops in PHP but there are while-loops. This is not being pedantic. If you're going to post code, make sure it's verbatim by using copy

RE: [PHP-DB] Using a loop on a result destroys array??

it needs to go. OK, sounds like a plan... Sorry (again) about the code gaffs :-S -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Currency and number types...

the trailing zero on numbers that comne out as, for example '12.10' or '12.00'. Does anyone know a way to force PHP to print numbers to a set number of significant figures (i.e. 2) and stop the trailing zero suppression? -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List

[PHP-DB] Parsing CSV files into a MySQL Table

no odds. I've also tried dumping the list of single variables and using '($data[0], $data[1] etc...) and that has no effect. It's probably something glaringly obvious to an expert but as I say I'm learning as I go so any help would be great :) Thx. -- Mark Benson http://homepage.mac.com