Re: [PHP] confused big time

2004-04-07 Thread Mark Ackroyd
I always found this way of inserting data into a database messy. Here is a handy function to do array inserts and it builds the sql for you. function arrayINSERT($a,$tablename) { $sql = INSERT INTO $tablename (; foreach($a as $key = $value)

Re: [PHP] confused big time

2004-04-07 Thread Mark Ackroyd
RD That .1% of the time being when you need to insert a value as now() ? RD (which will break the string check as it'll wrap it with '' which will RD cause MySQL to insert -00-00 00:00:00) or if it's an enum field RD with a numeric allowed value? :) Not really, since you usally format a

Re: [PHP] confused big time

2004-04-07 Thread Mark Ackroyd
RD But now() IS a DB friendly format for MySQL and is the recommended RD way of inserting the current time into a datetime or timestamp RD field. But what about MsSQL, Oracle and postgres to name a few. I have worked on a few projects where you read from one db and load into another db. Dates

Re: [PHP] PHP and XML.

2004-02-02 Thread Mark Ackroyd
that it wasn`t using expat. Wich I had time to look into all of these little things :-) -- Mark Ackroyd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP and XML.

2004-01-30 Thread Mark Ackroyd
) If I run the scripts from the Command lime they work fine ! anyone got any ideas? Mark -- Mark Ackroyd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP and Java

2003-12-11 Thread Mark Ackroyd
to the threads in java so I have set LD_LIBRARY_PATH=/usr/local/jdk1.3.1/jre/lib/i386/green_threads Either way this problem doesn`t seem to go away with the LD references? anyone got an ideas of what I am doing wrong? Mark -- Mark Ackroyd e: [EMAIL PROTECTED] -- PHP General Mailing List (http