ah hah someone got it right !! many thanks stephen ...
-Original Message-
From: Stephen Rhodes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 8:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: output problem
When you write the SQL statement write it as:
select
Hi there everyone,
On my linux server I am using:
MySQL 3.22.32
Whereas on my Local server I am using
MySQL 3.23.42 (Or 43.don't remember).
Anyway, I am having a wierd but major problem, if I do the code like the
following locally it WORKS, if I do it on the server with the slightly old
Thank you ALL!
It turned out that setting NLS_DATE_FORMAT environment variable is enough to
solve the problem. It's possible to get it worked right from PHP code, for
instance:
putenv(NLS_DATE_FORMAT=HH24:MI:SS DD.MM.);
PS
TO_DATE function didn't help
I didn't try to ALTER SESSION
hi,
i'm using a mssql-database. now i want update a record with the information
given in a form. i want use the following sql statement:
$SQL = update tablename set 'fieldarray[$index]' =
'HTTP_POST_VARS[$index]' WHERE PKID = 'HTTP_POST_VARS[0]';
mssql_query($SQL);
my problem is i cannot find a
use the function mysql_list_fields in url
http://www.php.net/manual/en/function.mysql-list-fields.php
Cheers
Steve
Hermann Otteneder [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
hi,
i'm using a mssql-database. now i want update a record with the
information
On Friday 24 May 2002 17:09, Stephen Rhodes wrote:
use the function mysql_list_fields in url
http://www.php.net/manual/en/function.mysql-list-fields.php
I'm sure you meant:
mssql_fetch_field()
Hermann Otteneder [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
I want to run a query to fetch out a navigation menu on a site I am
working on.
I always have paranoia of destroying the db with ineffecient queries...
Now, as I understand it, sub-queries is a bad thing. They are very slow
in MySQL??
This menu I am making will be displayed on each page the user
Hi
could anyone point me in the right direction please??
I needed to use php to upload some large files into mysql and reading
through previous posts saw that the php.ini file has a default entry
limit of 2M... this explained why small files were ok but not large
ones...
OK.. but I didnt
Hi
could anyone point me in the right direction please??
I needed to use php to upload some large files into mysql and reading
through previous posts saw that the php.ini file has a default entry
limit of 2M... this explained why small files were ok but not large
ones...
OK.. but I didnt
I want to run a query to fetch out a navigation menu on a site I am
working on. I always have paranoia of destroying the db with ineffecient
queries... Now, as I understand it, sub-queries is a bad thing. They are
very slow in MySQL??
This menu I am making will be displayed on each page the user
On Friday 24 May 2002 20:35, Daz wrote:
Hi
could anyone point me in the right direction please??
Yes, but there's no need to post twice.
I needed to use php to upload some large files into mysql and reading
through previous posts saw that the php.ini file has a default entry
limit of
You can just echo out during your while loop - or
build a display block and echo it all at once.
Not quite sure how to get this piece of code to loop
through the records and
echo them back one line per one record...
?php
session_start();
if (isset($HTTP_SESSION_VARS['var01']) ||
Is there any way to search *every*thing in my database (using mysql)? I
am thinking of a query somethng like select * from * where * LIKE
'%putsearchhere%'. This would help a lot when searching for
inappropriate language.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
13 matches
Mail list logo