To: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
I'm trying this query:
$link = mysql_connect( $site, $id, $pass );
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
$db = mysql_select_db( $dbname, $link);
if( !$db )
Peter Beckman wrote:
> How do I get connected from a remote PHP+Apache box to Oracle9i on linux?
The current Oracle Instant Client bundle is fine for using PHP on
Windows, but does not have headers for compiling PHP with Oracle
support on other platforms. An Instant Client SDK with headers is
comi
"...I want to be able to delete a rowid from the ROLES TABLE, but only if
the roleid does not exist in the USERS TABLE..."
DELETE FROM roles
WHERE roleid NOT IN ( SELECT DISTINCT roleid FROM users);
Rui
Chris Bolt writes:
How about:
DELETE FROM users WHERE userid IN (SELECT u.userid FROM
Hi All,
I am currently looking for beta testers to test my server monitoring
software,
Brief synopsis of what it entails,
Install a small (2.92 k) file on your web server
Add either a new db or use and existing db this will only be 1 table
with minimal information just basically holding your
Sorry all
The e-mail address is [EMAIL PROTECTED]
-Original Message-
From: Kenny [mailto:[EMAIL PROTECTED]
Sent: 15 June 2004 11:44
To: DBList
Subject: [PHP-DB] Beta Testers Needed
Hi All,
I am currently looking for beta testers to test my server monitoring
software,
Brief synopsis
Here is the lean, corrected code:
';
mysql_select_db( $dbname, $link) or die ("eror selecting db");
echo 'selected db ok';
$result = mysql_query( 'Select * From newsletter_subscribers',$link) or die
("error query");
// some here code to disply result
?>
It is easier to evaluate each time the return
I'm not sure you need a semi-colon after the table name.
$result = mysql_query( 'Select * From newsletter_subscribers', $db );
>>
>>To: [EMAIL PROTECTED]
>>MIME-Version: 1.0
>>Content-Type: text/plain; charset=us-ascii
>>
>>I'm trying this query:
>>
>>$link = mysql_connect( $site, $id, $pass );
>
I want to mysql on apache2 with php5 under winxp.
When I use apache 1.3 and start mysql in php.ini =>
extension=php_mysql.dll -> it is OK
but when I use apache2 -> then i see error "PHP Startup: Unable to load
dynamic library c:\php\ext\php_mysql.dll"
in php.ini is extension to c:\php\ext, and file
Hi,
I'm trying to connect to an oracle database which is itself on antother
server than php is running. on the php machine is an oracle client
succesfully installed.
i've tried the different functions to connect to oracle:
ociplogon('user','pass');
as well as ocinlogon, both with and without the op
Beni ... I am using the same setup as you are describing ... Here is my
connect information ...
OCILogon($username,$password,$tns_alias)
The error that you are getting ORA-12154 has the following text on a
lookup ... This leads me to believe that php is unable to find your
tnsnames.ora
Yeah, this is a joke, right?
You want people to intall your software on their webservers which will
send information about their servers accross the network to your server?
Can we just cut to the chase & I'll send you the root password on my severs?
Anyone interested in being alerted when their s
Hello Kenny,
Hans is right, but i'll take the challenge, send me the code
and I will look it for a while and tell you...
--
Best regards,
Pablomailto:[EMAIL PROTECTED]
Tuesday, June 15, 2004, 12:17:48 PM, you wrote:
HL> Yeah, this is a joke, right?
HL
Hi Hans,
Thanks for your concerns
I really have nothing to hide,
When I say software all it is, is a small script the generates a xml
file, most of the "Open source" software that does this type of
monitoring only pings your ports so there is no way of actually telling
if the service is really ru
Hi Kenny,
I'm not trying to trash, what might very well be a great product. I'm
just very wary (as everyone should be) about communicating private
server data to some remote host. Even things that seem trivial could
probably be used in creative ways. I'm a litlte paranoid, but not
without re
I agree about the semi-colon: not allowed. But also, specify '$link' in
your mysql_error(). This tells it explicitly what the error is
referring to, even though it should be able to figure it out on it's
own.
echo 'MySQL Error: ' . mysql_error($link);
Hope this helps - seems to work for me.
~Ph
Hello all,
I was wondering if anyone had some sample code that I could use for a
small project.
What I would like to do is select data in a date field, like:
From: 6-1-04
To: 6-15-04
Then output to a text file. I have other selections within this data
that I will make, and I think can figur
lots of sample code here
http://www.zend.com/codex.php
Mike Koponick wrote:
Hello all,
I was wondering if anyone had some sample code that I could use for a
small project.
What I would like to do is select data in a date field, like:
From: 6-1-04
To: 6-15-04
Then output to a text file. I have o
Here's a quick and easy one though:
"SELECT * from your_table WHERE your_date_field BETWEEN '2004-06-01' AND
'2004-06-15'";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message-
From: Mike Koponick [mailto:[EM
Hi all.
Maybe there's something I'm doing incorrectly, but I cannot get the
date() function to return the appropriate time. It's always 12 hours
off. I've tried using 24-hour time and 12-hour time (with AM/PM), but
they both give the wrong time. I even emailed the server admin to make
sure that
Hello, I have a simple script to retrieve and then delete a selected script, but it
does not work.
When I hit the button I get:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL
server version for the right syntax to use near 'id' at line 11064"
Any help woul
Hello,
ADOdb is a popular database abstraction library for PHP. It supports
a very large number of databases, including MySQL, PostgreSQL,
Firebird, Interbase, SQLite, Oracle, Frontbase, DB2, SAP DB, Sybase,
Informix, Netezza, Access, VFP, MS SQL, LDAP, ODBTP, ODBC, etc.
Due to system outages at
Beni,
You have two related problems: (i) the error ORA-12154 and (ii) Oracle
couldn't find its data file containing the error text to display with
ORA-12154.
Make sure the standard Oracle environment variables are set in the
environment that starts the web server. See
http://otn.oracle.com/tech/
22 matches
Mail list logo