[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 commands

Re: [PHP-DB] Help ! MySQL Problem

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 > requestroubr) > > " Try this: insert into roubr(id,pos,name) values select id,pos,name from requestroubr I hope this will work ! Best rega

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 yourt

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,po

[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: http://www.xml.com/lpt

Re: [PHP-DB] Help ! MySQL Problem

Thanks, but the idea is to transfer data between two tables with same structure. Rosen Marinov ""karakedi"" <[EMAIL PROTECTED]> wrote in message 987ggc$mca$[EMAIL PROTECTED]">news:987ggc$mca$[EMAIL PROTECTED]... > ok you must get your variables like row1, row2 etc from anywherelse then try > th

[PHP-DB] Re: [PHP] Help ! MySQL Problem

Sorry Rosen ! I mean: insert into roubr(id, pos, name) select id,pos,name from requestroubr This will definitively work ! Constantin Brinzoi Dept. Sondaje IRECSON -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [E

[PHP-DB] PHP4 and ORACLE8i

Hi, I'm having some troubles connecting php with a oracle8 DB. Even the extensions are a problem. I uncomment extension=php_oci8.dll in the php.ini file (yeah yeah php and apache on win32, company rules you know), but it's giving a error like "cannot find extension .". You have to know th

[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] Select just the first two letters in a column (MySQL)

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 statement return TT, PR, RD. Any ideas? John Guynn This

[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 followin

[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 i

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 dir

[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 instruc

[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): The value of $result

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 PROTECT

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 e

[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 s

[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 s

[PHP-DB] PHP+Oracle+Sessions

Hi. Is there any way to store an OCI8 connection resource $conn = ociplogon("",""); in a session like session_register('conn') and then use this connection by accessing the var in the other pages? I've tried this but it doesn't work... Thanks -- PHP Database Mailing List (http://www.php.ne

[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 matte

[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 d

[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 Files\Borland\Interbase\

RE: [PHP-DB] Interbase

if you are running a local webserver, why not just use $db=ibase_connect('localhost' , user, pass); ? Chad -Original Message- From: Martin Meca [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 3:06 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Interbase I am trying to connect to

[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:

Re: [PHP-DB] Interbase

And which database will I open, using this? First prameter in ibase_connect should be database file name, I think. Martin -- 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 adminis

[PHP-DB] PHP: Good for articles?

Hi everyone. I am a freelance html web designer - and I am new at it. I have also learnt Javascript. I have a customer - a local newspaper - who wants me to update their site weekly with newspaper articles. I have been doing this in html. I recently changed ISP - and my new ISP allows me to r

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 9E35C54B0C7AD411B5C1009027DE539940B515@MSPMX01">news:9E35C54B0C7AD411B5C1009027DE539940

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 d

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

I am also very knew at PHP/MySQL and have been busy populating my MySQL databases with tables (phpMyAdmin is a snap-LOL!). I am currently reading 3 different books on PHP, which also discuss use of MySQL as the back end: Essential PHP (Julie Meloni), Beginning PHP (Wrox), and Essential PHP for

[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 PROTECTE

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 addition

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] Sybase character set warning

To all the experts, I have a small problem with PHP4 connecting to Sybase. Everytime when I connect to a sybase database, the following warning comes up: Warning: Sybase message: Cannot find the requested character set in Syscharsets: name = 'ܮX'. (severity 11) Looks like there is a char

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

dont bother reading books...if you have coded any c,c++,java, these books are 80% fluff. All you need is the php manual, a project to start dabbling and this listreally. AndrewH - Original Message - From: "olinux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 09, 2

[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 wit

[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 wit

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 i

[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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

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 ce

[PHP-DB] How to migrate Oracle 4.01 database?

Hi, I have a database based on Oracle 4.01. Now I want to migrate it to Oracle 8i. Does anyone have reference to me? thanks. Sincerely, Weiping Tsen [EMAIL PROTECTED]

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? >

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

This one was solved by an accident. Linux version of MySQL seems to be case sensitive what it comes to table names and Windows version is not. SQL standard prefers the case insensitive way. Lasse ""Lasse Laurila"" <[EMAIL PROTECTED]> wrote in message 9885sf$99u$[EMAIL PROTECTED]">news:9885sf$99