[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.ma

[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 tag to switch that? -- Mark Benson AIM - SilValleyPirate MSN - [EMAIL PROTEC

[PHP-DB] Hyphens and MySQL

p out 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 st

[PHP-DB] Re: MySQL version issue

imes one needs a new 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-DB] MySQL version issue

L3 compliant substitute 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

all times from all points of access. -- 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

inc.php and setup some other system or can i use the grant tables from my MySQL server? Ideally I would want to log 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 out

[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...

s for the help on the 'ON DUPLICATE KEY UPDATE' thing, I didn't realise it was a new thing in MySQL 4.1.0! -- 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] Spot the deliberate mistake...

t do an update statement with the data already >provided". If I try that it returns: You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE' at line 1 so I 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

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

;$data[1]', alt_no='$data[2]', descript='$data[3]', price='$data[4]', unit_sale='$data[5]', unit_issue='$data[6]', weight='$data[7]', brand='$data[8]', nla_tag='0'" This is passed in a PHP script so the

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

gt;then just grab all the data the first time through and put it where 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

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

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

p 2 returns a blank array, the output is simply "Array >()". If I remove the loop (by commentiung it out) that extracts $crab the >mysql $result array is suddenly full of the correct values. It seems to me >that loop 1 is destroying or somehow not resetting $result. Very odd...

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

2) but that cuts off 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.

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

'regular' users and also the 'root' user and it makes 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 l