Hi CK,
I always fetch the Date like SELECT UNIX_TIMESTAMP(Timestamp) AS Timestamp
so you can manipulate it with all the PHP Date- and Timefunctions like
date(). So you can display the date the way you asked with:
$Timestamp = ; // fetch the Timestamp the way you like =8)
echo date( d-m-Y,
Recently i have faced the following issue:
I have a site running Apache 1.3.19 under Windows 2000 pro/PHP 4.0.6./Oracle
8i
After a little load Apache crashes with ORA-00020 error - maximum number of
Ora connections exceeded. This problem seems to be faced very often by other
people. Limit in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a way to encode a string in PHP exactly like MySQL does it
in its PASSWORD() Function?
Reason being Is I have a table with PASSWORD() encoded fields
that I need to
compare from PHP.
just include PASSWORD() in your query ie.
Sorry to ask this here, but I don´t know where to ask else ...
Does someone know a good mailinglist about
specific sybase questions? I have some questions about BCP ...
MfG
Marcel Walter
Dresdner Kleinwort Wasserstein
Foreign Exchange Money Market
Address:Jürgen-Ponto-Platz 1, 60301
This is only a guess but for Windows 2000, is there a file in your oracle
directory called init.ora? The x's would be the instance name. You
might have a maximum number of users defined in that file which is limiting
your persistent connections. Check license max users
Hi folks,
I have a requirement to show records in a certain standard
format from a database. This requires first/previous/
next/last buttons, sorting on the column name, searching
and filtering using text entered into a text box etc etc.
This page would be continuously calling itself when
asked
Hey
I'm kinda rookie here, but i rekon you'd have to double escape the
escape char like:
'select * from $table where primary-key=\'1\\' '
and maybe replace the single quotes ' ' with double quotes
I couldn't test this because I got my web/php server down.
Markus Wagner wrote:
Hi there,
Thx Stathis,
I get the same response as before:
Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in
c:\program files\apache group\apache\htdocs\dna\dna_oci_sys_list.php on line
20
Anything else I can try?
Barry
Rouvas Stathis [EMAIL PROTECTED] wrote in message
This is saying that your request to connect to Oracle via php and apache is
failing because it cannot find the tnsnames.ora file. Is apache setup
correctly to access Oracle?
Also, if you want detailed information on an error message from Oracle,
logon to the Oracle server with owner id of
The best tool is MS Access. It has an export facility to ODBC data source.
Export to a MySQL odbc dsn.
Regards, John
Taylor Cody Fletcher [EMAIL PROTECTED] wrote in message
001401c11098$25cf98c0$[EMAIL PROTECTED]">news:001401c11098$25cf98c0$[EMAIL PROTECTED]...
yeah, cut and paste, jk, im
Thx Peter,
I have spent some time on the oracle site. They focus on troubleshooting
the Net8 connection, which works fine.
I am not sure what you mean when you ask if apache is setup correctly to
access Oracle. When running a phpinfo() environment query it shows that oci8
is enabled. Is ther
Hello,
I'm hoping that this error is clear to someone who is familiar with MySQL errors
(cause it sure doesn't make sense to me):
Database error:
Invalid SQL:
UPDATE
WLPbib, WLPpublisher,WLPprofile,WLPbib2profile
SET
WLPprofile.firstName = 'asdf',
WLPprofile.middleName = '',
UPDATE
WLPbib, WLPpublisher,WLPprofile,WLPbib2profile
I think you can only update one table at a time...
I could be wrong, though...
Chris
Chris: The MySQL documentation would make you think so...
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
Note there isn't a tbl_name [, tbl_name2, ...]. It's just tbl_name...
Cheers!
My 2 ¢
John Pickett
Chris: The MySQL documentation would make you think so...
I don't think so
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
Note there isn't a tbl_name [, tbl_name2, ...]. It's just tbl_name...
Right... that means just *one* table. Your query is updating
4 tables.
Chris
write a small script that you can include on each page. this script
will update the field that holds the record for that page:
update page_count_table set page_count=page_count+1 where
url=$url_visited;
Pranot Kokate wrote:
Hi friends,
I am using PHP - MySQL. I need a button which is
Chris,
My first sentance was in response to your I think you can only update one
table at a time... statement, not I could be wrong, though... Supported
by the example I gave. Sorry for the confusion...
My 2 ¢
John Pickett
http://www.bvstudios.com/
Co-Author: Inside Dreamweaver 4
Hi,
I created a searchable members directory that probably dealt with some of
the issues you're dealing with ... though from your email I can't really
tell what exactly your application is for.
I'm not sure how professional or maintainable mine is, but here are some
basics of how I laid it
Hi Chris,
I think you are onto something here.. However, this has produced another problem.
Boget, Chris wrote:
UPDATE
WLPbib, WLPpublisher,WLPprofile,WLPbib2profile
I think you can only update one table at a time...
I could be wrong, though...
I seperated this out into 3 update
Tony pressed the little lettered thingies in this order...
I am trying to figure out how to read data base(Mysql) with rows of item
number (item) and quantity, so that when item number was given, it searched
for the quantity of the item number. If the quantity number is 0 or less,
it will
Mike Gifford pressed the little lettered thingies in this order...
Hi Chris,
I think you are onto something here.. However, this has produced another
problem.
Boget, Chris wrote:
UPDATE
WLPbib, WLPpublisher,WLPprofile,WLPbib2profile
I think you can only update one table at a
Thanks for your attention to this matter Christopher,
Christopher Ostmo wrote:
If you do not list a table in the UPDATE parameter, you cannot
reference that table from anywhere else within your query. The same is
true of SELECT statements - you cannot reference a table that is not
listed
When I execute a pg_connect() in a .php file, I get an error indicating that
the function is not defined...
That's because, in the Apache error log I'm getting the following:
PHP Warning: Unable to load dynamic library '/usr/lib/pgsql.so' -
libpq.so.2.0: cannot open shared object file: No such
Results for 200.197.121.100:
This IP has been verified clean within the last 15 days.
It will not be checked again until this period expires
and another check request is made.
Results for 216.92.131.4:
This IP is already in queue for checking.
Results for
Thanks for your quick respond and your help.
This is great.
I have one more favor to ask you. As you know I am a beginner of PHP
Mysql, do I put that language on all my product pages? It seems to be too
much work.
Is there way that I can save main language that you wrote in to one file as
Tony pressed the little lettered thingies in this order...
Thanks for your quick respond and your help.
This is great.
I have one more favor to ask you. As you know I am a beginner of PHP
Mysql, do I put that language on all my product pages? It seems to be too
much work. Is there way
26 matches
Mail list logo