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)
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
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
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
)
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
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
6 matches
Mail list logo