[PHP-DB] Re: How to connect and select data from Oracle 8 Database

2002-12-30 Thread Philippe Saladin
I also followed a guide showed on PHP website about ora_do functions. But when I tried that guide it did work. php_oracle.dll (deprecated) : for the ora_* function, like ora_logon for example. php_oci.dll : for the oci* functions, like ocilogon and friends. the oci functions are newest, and

Re: [PHP-DB] The ability of accessing DB

2002-12-30 Thread midheart
Hello, Everybody: Well, I didn't define my question well last time. My question is that when I try to reload a php page, I would sometimes get a warning mesg, Warning: 1 is not a Sybase result index , or I would be lucky to get the correct output. Even if the first time to open the php page,

[PHP-DB] How to Make a Pop Up Window and show there a mysql table for help input data?

2002-12-30 Thread José Luis
I need know if 's possible show a mysql table like when you are entering some code product, you press an icon with ? (by example) and there appear the window showing the table with the code and the description and the you choose and pick some item from that table and the code pass to the input

RE: [PHP-DB] How to Make a Pop Up Window and show there a mysql table for help input data?

2002-12-30 Thread Edward Peloke
I need to do roughly the same thing so I am interested to see if it is possible. I am writing an air charter app so I want to allow the users to select the airport codes from a popup and it will automatically fill the box. If I find anything I will pass it on. Eddie -Original Message-

RE: [PHP-DB] How to Make a Pop Up Window and show there a mysqltable for help input data?

2002-12-30 Thread Marco Tabini
I think you might be referring to data binding, which I think is only offered by Internet Explorer. A more browser-independent way is to use floating iframes that you can refresh depending on where the user has clicked. The iframe can point to a PHP script that extracts the data for you as needed.

Re: [PHP-DB] How to Make a Pop Up Window and show there a mysqltable for help input data?

2002-12-30 Thread José Luis
I am not sure what are you talking, but when you get some help (opening a windows) on others browser (netscape, opera, etc) appear a window using javascript or other technic you can show on that window a sql database (mysql, sqlserver, oracle, etc.) and choose some item (independent what is the

[PHP-DB] Searching DB and Printing Results

2002-12-30 Thread Mike Delorme
Hi, I have a table in DB Music that looks a little mike this: TABLE NAME _ SONG NAMESONG LYRICS | | | | | | | | |

Re: [PHP-DB] Searching DB and Printing Results

2002-12-30 Thread Jeffrey_N_Dyke
this can be done with Full Text Searchingdepending on DB compatability. if you use mysql - http://www.mysql.com/doc/en/Fulltext_Search.html HTH Jeff

[PHP-DB] Help with MySQL

2002-12-30 Thread Rodrigo Corrêa
I´m new with MySQL, i´m just wondering if there is a way to get the IP from a MySQL Server, since i acess this by localhost in the webserver Equipe Pratic Sistemas Rodrigo Corrêa Fone:

Re: [PHP-DB] The ability of accessing DB

2002-12-30 Thread Paul Burney
on 12/30/02 9:51 AM, midheart at [EMAIL PROTECTED] appended the following bits to my mbox: Well, I didn't define my question well last time. My question is that when I try to reload a php page, I would sometimes get a warning mesg, Warning: 1 is not a Sybase result index , or I would be

RE: [PHP-DB] Searching DB and Printing Results

2002-12-30 Thread Matthew Moldvan
Your company does PHP development, and you don't know how? Hmm ... I would say pick up a PHP book from Half.com or invest in hiring a good Script Programmer/Database Developer for your project (me, hehe). Regards, Matthew Moldvan --- System Administrator

[PHP-DB] Question about rollback in mysql

2002-12-30 Thread Arno Kruit (Stichting Eljakim)
I have php 4.2.3 and Mysql- Max 3.23.54b. If I use the rollback or Commit function it wil work until the scripts ends Is it possible to rollback or commit commands after the scripts ends with a another script? or is rollback only possible in the same script? A.J. Kruit -- PHP Database Mailing

[PHP-DB] SHOW PICTURE FROM DATABASE

2002-12-30 Thread Nikos Gatsis
Hello there and Marry Christmas! I have a php script that call binary data of pictures stored in database. The script works fine in IE but not in Netscape (ver 4.7, 6.01). Any ideas? - the html tag is like: img src=showpict.php?pro_id=1 where showpict.php:

Re: [PHP-DB] SHOW PICTURE FROM DATABASE

2002-12-30 Thread Steve Cayford
Some suggestions... On Monday, December 30, 2002, at 03:55 PM, Nikos Gatsis wrote: where showpict.php: $query=SELECT pict FROM pict WHERE pro_id= '$pro_id; (You're missing an end ' there, but apparently that's not the problem) $result=mysql_db_query($database, $query, $conn) or Die

RE: [PHP-DB] SHOW PICTURE FROM DATABASE

2002-12-30 Thread John W. Holmes
I have a php script that call binary data of pictures stored in database. The script works fine in IE but not in Netscape (ver 4.7, 6.01). Any ideas? - the html tag is like: img src=showpict.php?pro_id=1 where showpict.php: $query=SELECT pict FROM