[PHP-DB] Help ! MySQL Problem

Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Help ! MySQL Problem

ok you must get your variables like row1, row2 etc from anywherelse then try this format too insert them at your db mysql_connect("localhost","username","password") or die ("cant connect database"); @mysql_select_db("databasename") or die("cant connect database"); mysql_query("INSERT INTO

Re: [PHP-DB] Help ! MySQL Problem

Thanks, but it doesn't work ! "Brinzoi Constantin Aurelian" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Thu, 8 Mar 2001, Rosen wrote: Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from

[PHP-DB] PHP vs. Perl for XML

Hi, I've been trying to find information on the interaction of XML and PHP recently (for a view of one day writing .cgi scripts that search my xml documents with a knowledge of their hierarchy, etc.) And I came across this recorded roundtable discussion on perl and xml at:

[PHP-DB] About MySQL connections

Hi, I use "mysql_pconnect" function to connect to MySQL server. When I call function second time I receive error: "Warning: MySQL Connection Failed: Too many connections in /website/transfer.php on line 17" Please HELP! Rosen MArinov -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] MySQL selects it's clients carefully?

Environment: Two servers, which another has Windows 2000 Server and another one runs Linux. Both of them has PHP (IIS/Apache) and MySQL installed. They seemingly share configuration and they have exactly the same database structure, data and PHP scripts as well. This combination works in

[PHP-DB] connecting to a sybase-database using php 4.04pl1 on win32

Hi! I am trying to connect a sybase-database using the php_sybase_ct.dll module, but all I get is a pop-up window telling: "Unable to load dynamic library './extensions/php_sybase-ct.dll' - The dynamic library could not be found.". I have really worked hard on this one. I'm sure that the path

Re: [PHP-DB] PHP4 and ORACLE8i

Hi, Maybe you should modify extension_dir in the php.ini file as following: extension_dir=path\to\you\extension\dll\ the extension dll such as php_oci8.dll should place in such a directory. Weiping Tsen [EMAIL PROTECTED] --Original Message-- Hi, I'm

[PHP-DB] password security on an isp

Hi all - I am using php/MySQL on an ISP in which there are other users. Everyone has SSH access and can therefore enter everyone else's directories and read any world-readable files. I have a config.inc file which contains my MySQL username and password. This file is located outside of my web

[PHP-DB] Newbie: dba_open error

Hi, I am currently running PHP 4.04/ Apache 1.3 on Windows 2000 and I still get the same error.(Fatal error: Call to undefined function: dba_open()) When I look at the PHP installation file I cannot find a line: "--enable-dba" anywhere in in there. I am not sure where one shld place this

[PHP-DB] Oracle Function Calls Redux

Problem solved! Thanks to everyone who helped out (and to our system DBA for reminding me that an Oracle function is just a type of stored procedure). For what it's worth, here is the code that I wound up using (sensitive company information 'ed out, of course): ?php // Establish

RE: [PHP-DB] About MySQL connections

mysql_pconnect() opens a persistent connection, that is, one that remains open for the duration of you session. Therefore, you don't need to re-open it. Either that, or you can use mysql_connect() to open a non-persistent connection. -Original Message- From: Rosen [mailto:[EMAIL

Re: [PHP-DB] About MySQL connections

From the PHP documention: "First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection." According to this, and my own

[PHP-DB] Re: Select just the first two letters in a column (MySQL)

On Thu, 8 Mar 2001 08:47:41 -0600, John Guynn wrote: Is there a way to select just the first two letters in a column? I have a column that contains values like TT1, TT2, TT3, TT4, PR1, PR2, RD1, RD2, RD3, and I'd like to SELECT DISTINCT the first two letters. In otherwords have the select

[PHP-DB] Too many includes?

Good Day All, I have my scripts in place and the website is running fine. When there's a surge in traffic, the pages take longer being served up. No big news there, I would expect that. My question is, several of my scripts have: require("file.php"); spread out all over the place. As a

[PHP-DB] 1 TNS error out of 25 connections

HI I have a strange behaviour of my remote Apache-PHP-Oracle-Client. Apache 1.3.14 mod SSL PHP 4.0.3pl1 (everything compiled from sources) Oracle 8.1.6 on remote Intel/Redhat 6.2 (100MBit, same subnet) The Oracle Server runs a Multi-Threaded-Server (successfully) and accepts

[PHP-DB] Interbase

I am trying to connect to local Interbase server, folowing exactly PHP online documentation. But I always get a warning: "InterBase: unavailable database in d:\program files\apache group\apache\htdocs\\tabulka.php on line 22" my script is: $db=ibase_connect('D:\Program

[PHP-DB] Ms SQL Server inserting image datatype with PHP??

How can I accomplish this?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Ms SQL Server inserting image datatype with PHP??

Althought the article addresses MySQL it may help http://www.phpbuilder.com/columns/florian19991014.php3 Good Luck! Kevin Leavell [EMAIL PROTECTED] P 406.829.8989 C 406.240.4595 --- -Original Message- --- From: j. vos [mailto:[EMAIL PROTECTED]] --- Sent: Thursday, March 08, 2001 2:13

RE: [PHP-DB] PHP: Good for articles?

Dan, I think it is a very powerful combination. PHP is easy to learn as is mySQL. They are both free and powerful. Question 2: Yes you can do about anything to a database with PHP including updating field data, adding field data, and even creating a new database from a web front end. Chad

[PHP-DB] Where do I get started?

Thanks for the comments. The server is running both MySQL and PHP. How do I get started that this? Can anyone recomment a good book? Thanks again. ""Angerer, Chad"" [EMAIL PROTECTED] skrev i en meddelelse

AW: [PHP-DB] PHP: Good for articles?

Another Question: Can users via PHP update field data in a MySQL database? I would really appreciate any comments. PHP and MySQL (at standard ISPs) is a good (the best) choice for your business. It's cheap, fast and reliable, although i would not take my mission critical parts to an ISP. check

[PHP-DB] RE: [PHP-INST] FW: I'm not sure where to begin...

Maybe I should have put "NEWBIE ALERT" as part of the subject :) All the same. I thought that the build had already been done in steps 9 and 10 (see manual exerpt). And then, right after that is the line about "building" the CGI executable (section following the steps). Has that not been

[PHP-DB] ftp upload

hi there, i want my users to upload their image files to a desired directory, i can handle that but... is it possible to make a "upload file" php script ? any example is high acceptable :) thx in adv. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] ftp upload

http://www.php.net/manual/en/features.file-upload.php -aaron At 3:03 AM +0200 3/9/01, karakedi wrote: hi there, i want my users to upload their image files to a desired directory, i can handle that but... is it possible to make a "upload file" php script ? any example is high acceptable :)

Re: [PHP-DB] ftp upload

At 03:03 AM 3/9/2001 +0200, you wrote: is it possible to make a "upload file" php script ? any example is high acceptable :) Read the supplied PHP documentation at: http://www.php.net/manual/en/features.file-upload.php The above link was from the table of contents of the manual which suggests

Re: [PHP-DB] ftp upload

nope i am aware of that manual, simply couldnt figure that out. i see the point of your warning anyway next time that d be more polite if you sent your special comments via email. thx anyway. btw there are tons of things here which is already at some manuels. and i apologise sending this to db,

[PHP-DB] php, netscape and sybase

I would just like to thank all of you for your help I have completed the install of php with netscape and sybase database. It was a hard road but your help made it enjoyable. Thanks again. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] Where do I get started?

I enjoyed FAST AND EASY PHP by Julie Meloni [ www.thickbook.com ] and the PHP4 BIBLE [ www.troutworks.com/phpbook ] has served as a good reference. I am new so these are the only two i've read. I just picked up SAMS Teach Yourself SQL in 10 minutes. I know I have heard the books are crap, but i

[PHP-DB] php-mySQL and an SQL query

Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing

[PHP-DB] php-mySQL and an SQL query

Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing

Re: [PHP-DB] php-mySQL and an SQL query

mysql doesn't support sub-queries unfortunately =( At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote: Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea:

[PHP-DB] odbc_columns problem with MSSQL

I am trying to get the column names of some tables with odbc_columns from MSSQL 2000. As I extract a particular column from the result set, the browser hangs. html body ? $con = odbc_connect("mydatabase", "christopher", ""); $result = odbc_columns($con, "mydatabase", "dbo",

Re: [PHP-DB] Where do I get started?

One of the best kept secrets (apparently) is to take a program that someone else has created (preferably a mature project that has undergone some growth and cleaning) and learn what it does...syntax is just that...you will see that there are about a million ways of doing any one thing, but only

Re: [PHP-DB] php-mySQL and an SQL query

And even without the subquery, the "like" keyword expects a wildcard character or two, for example: LIKE '$month%' " mysql doesn't support sub-queries unfortunately =( At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote: Hi, folks, Can someone insight me regarding this? I have a