Re: [PHP-DB] PHP and Access to DB2.

Nicolas, Take a look of the following link: Hope this help. AS/400 Connection from a Linux Box to AS/400 DB2 Connection from a Linux Box to IBM DB2 Mainframes http://www.faqts.com/knowledge_base/view.phtml/aid/5613/fid/12 Can I use PHP to interface with an AS/400 database? http://www.faqts.com/

RE: [PHP-DB] updating database on internet server

I want to update the internet server from my local computer. I used MySQL both in local and internet server. Regards; Benny. -Original Message- From: Marko Lesnik [mailto:[EMAIL PROTECTED]] Sent: 03 Mei 2001 14:39 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] updating database on internet

Re: [PHP-DB] ora_logon receive ora-12154

Hi Miguel, try >if(!($conn=ora_logon("user","pass","SERVICE"))) it always works for me HTH Steve At 10:47 PM +0100 3/5/01, Miguel wrote: >Hi, > >I'am having serious problems in put php acessing a remote oracle 8 database, >i have tried several configurations but always end up with > >Oracle:

[PHP-DB] mp3 upload????

Hi, I want to setup a upload program thats only allow MP3 file type. So, this is my coding under the file . if ($imgfile_type == "audio/mp3") .. ... But when I upload my song, it said "mp3 is not the format type" What should I do? Please help. I will be

[PHP-DB] ora_logon receive ora-12154

Hi, I'am having serious problems in put php acessing a remote oracle 8 database, i have tried several configurations but always end up with Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in /var/www/htdocs/support/teste.php on line 5 I can access this database from sql

Re: [PHP-DB] Mystery variable query?

Cool! I'll give it a try. Thanks, Martin ""Gyozo Papp"" <[EMAIL PROTECTED]> wrote in message 02e601c0d3ff$d89a83a0$5145c5d5@jaguar">news:02e601c0d3ff$d89a83a0$5145c5d5@jaguar... > I wish there were a php debugger. maybe, this would satisfy you: http://dd.cron.ru/dbg/home.php best regards, Pa

Re: [PHP-DB] Mystery variable query?

Hi, ""martin helie"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9cs791$mn3$[EMAIL PROTECTED]">news:9cs791$mn3$[EMAIL PROTECTED]... [..] > > 1. There is such a function as "mysql" whose arguments are > mysql("database","query",[resource id]) > very useful as it avoids having to call mysql_

Re: [PHP-DB] Mystery variable query?

In article <9cs791$mn3$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("martin helie") wrote: > The problem, evidently, is that echoing the variable didn't show the html > formatting (it was something like "" in an obvious way! Look at it via source view next time. Echoing the content wrapped in a ta

Re: [PHP-DB] Mystery variable query?

> I wish there were a php debugger. maybe, this would satisfy you: http://dd.cron.ru/dbg/home.php best regards, Papp Gyozo - [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP-DB] Mystery variable query?

Hi guys, I'll answer this and the previous mail. First, thanks for the insight. 1. There is such a function as "mysql" whose arguments are mysql("database","query",[resource id]) very useful as it avoids having to call mysql_connect_db() As for printing the query, I had done that, and

Re: [PHP-DB] Newbie question

EXACTLY what I was looking for... Thanks! http://www.bustdustr.net Home of Radio Free Bd - Original Message - From: CC Zona <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 03, 2001 1:42 PM Subject: Re: [PHP-DB] Newbie question > In article <034101c0d3f3$0dd747e0$41041d

RE: [PHP-DB] interbase (?) field contents does not show

Beacuse u are using an object structure, Check OOP in PHP, the pointer $variable->name is for objects that why its used in the fetch object and not fetch row fetch row would be $rs["rowname"] or $rs[0]. Check the documentation for more detailed info -Original Message- From: GMansky [mailt

Re: [PHP-DB] Mystery variable query?

In article <9crr9l$4c4$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("martin helie") wrote: > assuming: > > $var="1234";(type does not seem to matter) > > this query returns no error, but no result either: > > mysql("database","SELECT * FROM table WHERE id='$var'"); When you call mysql_query is

Re: [PHP-DB] Newbie question

In article <034101c0d3f3$0dd747e0$41041dd8@winbox>, [EMAIL PROTECTED] ("~BD~") wrote: > at the end of my script, I run a set of closing and clean-up procedures.. > what I would like to be able to do is that when a user bails out of the > script by closing the browser or leaving the site/page, de

Re: [PHP-DB] interbase (?) field contents does not show

Meir, Thanks for the response. I believe I tried it with caps but did not get any message. Anyway, I tried it again, and it's now working. Why does $row->LASTNAME give me a result on an ibase_fetch_object() and not on ibase_fetch_row()? Thanks, George -- PHP Database Mailing List (http:/

[PHP-DB] Newbie question

I've gone thru everything I can find, and I'm sure I'm just missing it (it's happened before), but... at the end of my script, I run a set of closing and clean-up procedures.. what I would like to be able to do is that when a user bails out of the script by closing the browser or leaving the site

Re: [PHP-DB] Mystery variable query?

Hi, is there a function called mysql? You'll have to use mysql_query. The syntax isn't correct either. mysql_query("SELECT * FROM table" [, link identifier]); Look in the manual for more detailed information. hope it helps Johannes ""martin helie"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9c

Re: [PHP-DB] Excluding values of one array from another (sort of)

Hi Howard, you 'd love the in_array() function (>= PHP4). So you should add an extra condition to your if statement: (see below in code) > [...] > reset ($alphalist); > reset ($exemptlist); > > while (list ($val) = each ($alphalist)) { > // pay attention! if ($currltr <> $val && !in

Re: [PHP-DB] mysql/php select using date in where clause

IT works! Thanks! ""martin helie"" <[EMAIL PROTECTED]> skrev i en meddelelse 9crqud$voj$[EMAIL PROTECTED]">news:9crqud$voj$[EMAIL PROTECTED]... > Here's how I'd do it: > > SELECT * FROM customers WHERE Site='egebjergnet' AND > > TO_DAYS(NOW()) - TO_DAYS(date_column) <= '45' > > where date_colum

[PHP-DB] Mystery variable query?

Hello everyone, I hope this hasn't been discussed before (I've looked but haven't found any answers). This seems very, very strange, and maybe it's just me but here goes: PHP 4.0.4 mySQL 3.23.30(gamma) assuming: $var="1234";(type does not seem to matter) this query returns no error, but no

Re: [PHP-DB] mysql/php select using date in where clause

Here's how I'd do it: SELECT * FROM customers WHERE Site='egebjergnet' AND TO_DAYS(NOW()) - TO_DAYS(date_column) <= '45' where date_column contains record dates... Martin ""Dan Eskildsen"" <[EMAIL PROTECTED]> wrote in message 9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]..

Re: [PHP-DB] postgres tutorials?

There were some on www.postgresql.org, buried down in either documentation or users. I'd also try devshed or webmonkey for using it with PHP HTH - Miles At 10:26 AM 5/3/01 -0400, Jaxon wrote: >Hi, > >Can anyone point me towards tutorials for using postresql with PHP? > >cheers! >jaxon > >-- >P

[PHP-DB] mysql/php select using date in where clause

***NEWBIE ALERT*** (I am only very new at this) PHP and MySQL OK - I have a table with data and one of the fields is a Date field. Now I would like to SELECT all records where the date is less that 45 days old. Eh, How do I do that? I have tried this: #Declaring variables $today=date("Y-m-d

[PHP-DB] postgres tutorials?

Hi, Can anyone point me towards tutorials for using postresql with PHP? cheers! jaxon -- 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] Simple query problem

Suggestions: 1) Can you try this at the database console and see what is returned. 2) Have you echoed $sql to see if the statement looks right. I only ask this because I've been certain that I have a correct statement and then found out that nothing is coming back. 3) What happens if $aff_sp

Re: [PHP-DB] INSERT into mySQL over PHP (internet)

> I'd like to have some kind of a GUI on the internet Could you not use phpMyAdmin?? Download it for free from http://www.phpwizard.net/projects/phpMyAdmin/ Cheers. Russ On Thu, 3 May 2001 15:43:11 +0200 Nils Wetterich <[EMAIL PROTECTED]> wrote: > Hi NG > > Now that I finally realy work with

[PHP-DB] INSERT into mySQL over PHP (internet)

Hi NG Now that I finally realy work with the combination mySQL & PHP on a Windows-machine I began to just love it. There's only one problem I still have: How can I INSERT data from a HTML-form to the database on the server? I'd like to have some kind of a GUI on the internet so I could administer

[PHP-DB] Simple query problem

Hi all: I have a seemingly simple SQL problem when using the following PHP4/MySQL-3.22.32 query: $sql="SELECT * FROM $table_users WHERE usrName='$username' AND usrPswd=password('$password') AND affiliation='$aff_sport'"; $result = mysql_query($sql, $connection) or header("Location: error.php?e

[PHP-DB] SQL 2000

Nevermind... Silly Error on my part... (to tired) Thre are no problems with SQL Nick -- 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]

[PHP-DB] SQL 2000

I just upgraded to the latest 4.05 and was having trouble getting my old MSSQL pages to work. I run IIS in 2000 Server I overwrote my php.ini file figuring there was so little to do to it that all would be well.. Are there any pointes for loading the MSSQL extension again. it does not seem to wa

[PHP-DB] Excluding values of one array from another (sort of)

I have the following code "A", "B"=>"B", "C"=>"C", "D"=>"D", "E"=>"E", "F"=>"F", "G"=>"G", "H"=>"H", "I"=>"I", "J"=>"J", "K"=>"K", "L"=>"L", "M"=>"M", "N"=>"N", "O"=>"O", "P"=>"P", "Q"=>"Q", "R"=>"R", "S"=>"S", "T"=>"T", "U"=>"U", "V"=>"V", "W"=>"W", "X"=>"X", "Y"=>"Y", "Z"=>"Z"); $exemptlist =

[PHP-DB] LDAP : retrieving structure

Hi , I need to ask how to retrieving a LDAP db structure. I've reached this point: making a serach by ONE_LEVEL, and retrievind all objects in the first level using a base DN... after that , how i can see each structure of theese objects in their sub-levels? i've tried with a "ldap_first_entry( ..

Re: [PHP-DB] updating database on internet server

That's exactly I'm trying to do. It seems that if you supply an IP of the server instead 'localhost' in mysql_connect that you would connect directly to the Mysql database on the server. Where are you programming the update module and what database are you using on local computer? ""Benny"" <[EMA

Odp: [PHP-DB] Migrating from InterBase 4.0 to 6.0

Od: "Steve Farmer" <[EMAIL PROTECTED]> Temat: [PHP-DB] Migrating from InterBase 4.0 to 6.0 > I need to migrate a database from InterBase 4.0 to 6.0 . Question is > has anybody done this and what are the snafus !! > > The migration docs for 6.0 only seem to mention migration from 5.0 !! > > I wo