[PHP-DB] anonymous select error

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 )

Re: [PHP-DB] Oracle Client Libraries for Linux

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

[PHP-DB] Re: Delete Subquery

"...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

[PHP-DB] Beta Testers Needed

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

RE: [PHP-DB] Beta Testers Needed

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

[PHP-DB] Re: anonymous select error

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

Re: [PHP-DB] anonymous select error

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 ); >

[PHP-DB] php5 & mysql

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

[PHP-DB] Connecting to Oracle DB on antother server

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

Re: [PHP-DB] Connecting to Oracle DB on another server

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

Re: [PHP-DB] Beta Testers Needed

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

Re[2]: [PHP-DB] Beta Testers Needed

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

RE: [PHP-DB] Beta Testers Needed

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

Re: [PHP-DB] Beta Testers Needed

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

Fwd: [PHP-DB] anonymous select error

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

[PHP-DB] Sample Code

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

[PHP-DB] Re: Sample Code

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

RE: [PHP-DB] Sample Code

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

[PHP-DB] Erroneous date and time

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

[PHP-DB] delete a record not working

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

[PHP-DB] ADOdb db abstraction library moving to sourceforge

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

Re: [PHP-DB] Connecting to Oracle DB on another server

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/