[PHP-DB] Oracle OCI/Client install without OUI?

2001-08-22 Thread Paul Blacquiere
Hi, Does anybody have an idea on how I could install the oracle client/libraries required to build PHP with OCI support without using the OUI. The server is headless, and behind a firewalls, so X-Server is not an option, it also has no local CD-Rom, just to add to the problem. Platform :=

[PHP-DB] using A NAME ref

2001-08-22 Thread Howard Picken
Hi I'm trying to use the A NAME tag on a php4 generated page. The pages being generated are alphabetically list (e.g. Page just lists people with surname starting with A) a href=\/members/members.php?$memltr#$memb\$member/a It doesn't work of course. Anyone have any ideas? Howard Picken --

RE: [PHP-DB] using A NAME ref

2001-08-22 Thread Walter, Marcel
Where do you have this a href tag? ?php 1: in here (inside PHP) ? ? 2: or here (outside PHP) ? === If 1) print a href=\/members/members.php?$memltr#$memb\$member/a; if 2) a href=/members/members.php??= $memltr ?#?= $memb ??= $member ?/a

RE: [PHP-DB] using A NAME ref

2001-08-22 Thread Howard Picken
Thanks Walter Sorry. I should have thought about more details. I'm using echo a href=\/members/members.php?$memltr#$member\$member/a; (within php4 code) When I try this it just goes to the first letter (A) page because I've used an Isset on $memltr in members.php setting it to A if empty.

[PHP-DB] Oracle performance

2001-08-22 Thread Andrey Hristov
Can someone tell me where I can find already done benchmarks of Oracle compared to other RDBMSes like DB2, MySQL,PostgreSQL or how many connection will get oracle8i on a machine with 512 or 1024MB RAM, dual CPU PIII 500 or dual PIII 1.1Ghz. Sincerely : Andrey Hristov IcyGEN Corporation

[PHP-DB] Interbase : Double SELECT

2001-08-22 Thread Enrico Comini
With Interbase functions I have to make 2 select. SELECT count(*).. to count valid record and SELECT * .. to extract the records There is a simple solutions to have unique Select ? I use Pgsql too but here I Have the pg_numrows variable. Someone sau to me: just make the SELECT * .. to extract

[PHP-DB] Re: Photo Album Schema

2001-08-22 Thread Steve Brett
that would generally work on the assumption that many photos can belong to many albums. possibly a bad thing. table 1 -userid (primary key) -username -password -album_title -creation_date table 2 -photoid (primary key) -photo (jpg or gif) -date -photo_title -description

[PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Yves Glodt
Hello, I'm in trouble with my current project which uses Interbase as backend. (php.ini: magic_quotes_sybase = On) When I insert a string containing a ', like Beverly D'Angelo, php saves it with two ' When I insert it with two ', it gets saved with four ' Short: php multiplies all the ' by

Re: [PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Patrik Wallstrom
On Wed, 22 Aug 2001, Yves Glodt wrote: Hello, I'm in trouble with my current project which uses Interbase as backend. (php.ini: magic_quotes_sybase = On) When I insert a string containing a ', like Beverly D'Angelo, php saves it with two ' When I insert it with two ', it gets saved with

Re: [PHP-DB] Escaping queries in php using InterBase

2001-08-22 Thread Yves Glodt
On Wednesday 22 August 2001 14:34, Patrik Wallstrom wrote: On Wed, 22 Aug 2001, Yves Glodt wrote: Hello, I'm in trouble with my current project which uses Interbase as backend. (php.ini: magic_quotes_sybase = On) When I insert a string containing a ', like Beverly D'Angelo, php saves

RE: [PHP-DB] accents in mysql db?

2001-08-22 Thread Rick Emery
What do you mean when you say ...with accents out of the database, the charactes don't come out correctly? Can you show example of data in database and that which is output? Richard Emery Excel Communications, Inc. IT Sr. Project Manager (972) 478-3398 (972) 944-0542 (pager) There is no

[PHP-DB] Query construction (again)

2001-08-22 Thread Russ Michell
Hey there folks - similar problem - different project! I want to select some records for a period of 7days after their insert [dateFrom] date. Last time I asked you guys for help I was helped toward the following solution: $sql = SELECT * FROM $Tpostings WHERE now()=dateFrom AND now()dateTo;

RE: [PHP-DB] using A NAME ref

2001-08-22 Thread Rick Emery
The NAME indicator (#), must precede the data separator (?). I think what you want is: a href=\/members/members.php?$memltr=$memb\$member/a To use the NAME indicator, your line would read: a href=\/members/members.php#$memb?$memltr\$member/a which I doubt is what you want. Richard Emery

Re: [PHP-DB] Query construction (again)

2001-08-22 Thread Gremlins Mailing List
- Original Message - From: Russ Michell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 10:16 PM Subject: [PHP-DB] Query construction (again) Hey there folks - similar problem - different project! I want to select some records for a period of 7days after

Re: [PHP-DB] Query construction (again)

2001-08-22 Thread Jason Wong
- Original Message - From: Russ Michell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 10:16 PM Subject: [PHP-DB] Query construction (again) Hey there folks - similar problem - different project! I want to select some records for a period of 7days after

[PHP-DB] Interbase blob question

2001-08-22 Thread Yves Glodt
Hi, is there a way to treat the output of ibase_blob_echo? I want to do some str_replace with its content before displaying it. thank you, yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] latest MySQL

2001-08-22 Thread Venelin Arnaoudov
Hi Does anyone knows if the latest stable version of MySQL 3.23.41 can work smootly with a PHP 3.0.16 application? I have successfully upgraded the MySQL but the PHP application could not connect the DB. Venelin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] using A NAME ref

2001-08-22 Thread Justin Buist
I'm not sure what any of the posted sample code is really trying to get at ... but from what I gather you want: a) Links at the top of the page, allowing somebody to jump to the beginning of the section of people's who's last name begins with that letter. b) The names all come from the

[PHP-DB] Extensions on SuSE

2001-08-22 Thread Ridai Govinda Pombo
Does anyone know how to get the _binary_ extensions for PHP installed with SuSE 7.2 ? I think it needs to recompile... But I wanted a easier way to solve it... Thanks, Ridai Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] how should i test my php program performance?

2001-08-22 Thread haheho
Dear all: I have wrote a php program and use mysql database. Is there a way to test its performance? Thanks. haheho -- 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

Re: [PHP-DB] how should i test my php program performance?

2001-08-22 Thread Fernando Ferreras
Hi, You can get the time(); or microtime(); (in linux) in the beginning and in the endo of the code.. example: ? $t1 = time(); code... $t2 = time(); echo Total time is.($t2 - $t1).seconds.; ? []s Ferreras Dear all: I have wrote a php program and use mysql database. Is there a way to

Re: [PHP-DB] how should i test my php program performance?

2001-08-22 Thread Andrey Hristov
?php $starttime=explode(' ',microtime()); // code is here // // $endtime=explode(' ',microtime()); $starttime=$starttime[1]+$starttime[0]; $endtime=$endtime[1]+$endtime[0]; $parse_time=$endtime-$starttime; ? Try apache benchmarking tool to view what is the peak of executions per second. I don't

[PHP-DB] Oracle Jobs

2001-08-22 Thread Fernando Ferreras
Hi everyone, Does anyone knows how i can create a job in oracle to go to a specify url or send a email Thanks a lot. Fernando Ferreras -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] FreeBSD connecting to Access database on NT/2k

2001-08-22 Thread Jonathan Hilgeman
I'm not exactly sure how to go about using PHP on a FreeBSD box to connect to an Access database on a Windows NT/2000 machine. I tried odbc_connect and just got an undefined function error. But beyond that, all I have is a URL to the database file, and a username and password. I've heard some

[PHP-DB] Uploading files problem

2001-08-22 Thread Ian Grant
Hi, I have this code after a user submits a form with name, description and image file upload fields: images/people/preview is simply a unix link to /tmp/phptempimg-ian.grant The problem is, when this script is run, the image show is that from the previous operation. If you refresh the page,

[PHP-DB] Re: FreeBSD connecting to Access database on NT/2k

2001-08-22 Thread Jonathan Hilgeman
Also, I should mention that I have glanced at two methods: iODBC and OpenRDA, but I'd like to know if I can use PHP's dl() function to simply load them when needed, instead of having to recompile... - Jonathan Jonathan Hilgeman [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

RE: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Brunner, Daniel
Hello!!! Make sure that the ownership of the files are mysql.mysql This as happened to me too!!! I might be wrong but it worked for me Dan -- From: Jay Paulson Reply To: Jay Paulson Sent: Wednesday, August 22, 2001 11:29 AM To: [EMAIL

[PHP-DB] ORA-12541: TNS:no listener error

2001-08-22 Thread Tom Tsongas
Hi folks. My group recently switched from an 8i to a 9i database. I recompiled PHP4.0.6 against Oracle 9i and everything went smoothly. However, when I attempt to execute my PHP code, I get the following error: ORA-12541: TNS:no listener My database admin says that the connection information

Re: [PHP-DB] how should i test my php program performance?

2001-08-22 Thread Justin Buist
There are a few different things you can test here... I. Server Performance (overall) I don't have the name of any specific tool off hand, but basically you would request a slew of .php pages off of the server via HTTP and record how many pages/second actually are served up. This is really the

Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
actually the owner of the tables/files that all_databases.sql creates is mysql.mysql.. and it still says read only.. and they are chmod'ed to 660... like i said before i'm really lost as to why it's doing this. jay - Original Message - From: Brunner, Daniel [EMAIL PROTECTED] To: 'Jay

[PHP-DB] Re: ORA-12541: TNS:no listener error

2001-08-22 Thread Joe Casey
What module did you build PHP with? We tried rebuilding PHP 4.06 with oci8 after upgrading to 9i and apparently the client libraries were missing. Am I missing something? Tom Tsongas wrote: Hi folks. My group recently switched from an 8i to a 9i database. I recompiled PHP4.0.6 against

[PHP-DB] Please help!

2001-08-22 Thread Matt C
Thats my code! What I want to be able to do is have it so instead of one column there are two columns of pictures: pic1 | pic2 pic3 | pic4 etc.. How can I do this? Thanks in advance! ?php $mysql_access = mysql_connect(, **, *);

RE: [PHP-DB] What's the PHP function for clearing out the garbage code inside the variable?

2001-08-22 Thread Rick Emery
unset($variable); -Original Message- From: Scott Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 2:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] What's the PHP function for clearing out the garbage code inside the variable? Hi! When I receive the data from the

[PHP-DB] Access tables to PostgreSQL

2001-08-22 Thread Tim O'Brien
What is the best method to move data from access tables to postgreSQL? Are there are php functions that are available? -- 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

[PHP-DB] MySQL ERROR 1036: Table 'foo' is read only

2001-08-22 Thread Jay Paulson
Running on RH, Apache. I had this working on Win2K, then switched to Linux by running the mysqldump then moving over the dump file and runing the mysql -u root -p 'add_databases.sql'. It creates the database then the table and then it tries to populate the table and i get an ERROR 1036: Table

Re: [PHP-DB] Access tables to PostgreSQL

2001-08-22 Thread grant
On Wed, 22 Aug 2001, Tim O'Brien wrote: What is the best method to move data from access tables to postgreSQL? Are there are php functions that are available? Unfortunately, only Access reads Access very well, but you can use ODBC and linked tables in Access to copy it to PostgreSQL. --

Re: [PHP-DB] Please help!

2001-08-22 Thread Marios Moutzouris
use that counter variable. check if its equal to 2 before incrementing, if it is then BR and reset to zero, otherwise just increment. if ($counter==2) { echo BR; $counter=0; } else { $counter++; } marios - Original Message - Original Message - From: Matt C [EMAIL

Re: [PHP-DB] Please help!

2001-08-22 Thread Justin Buist
I realize this is trivial... but if you're using things like the code below alot it can clean things up a bit by using: if (($counter % 2) == 0 ($counter != 0)) echo BR; $counter++; echo img src=whatever...\n; Just reads easier... less branching, less code. In an ideal world it'd

[PHP-DB] Re: Query construction

2001-08-22 Thread Michael Kumar
select count(*), category from posts group by category or select count(*) from posts group by category where category = 'foobar' should do the trick. regards, mike. -- mfG, Michael Kumar (michael.kumar_at_nme.at, m.kumar_at_hushmail.com) PGP: 30FE 3AB9 5077 C554 5D9E B5CC 0B0F CFB2 55D6

Re: [PHP-DB] Please help!

2001-08-22 Thread phpnet
you do not need a counter, just use a 2 column table | Thats my code! | | What I want to be able to do is have it so instead of one column there are | two columns of pictures: | | | pic1 | pic2 | pic3 | pic4 | | etc.. | | | How can I do this? | | Thanks in advance! |

[PHP-DB] Please help!

2001-08-22 Thread Marios Moutzouris
try this :-) echo TABLE border=1 WIDTH=\80%\ ALIGN=CENTER; echo TR; $row= mysql_fetch_array($result); $count = 0; do echo TD ALIGN=CENTERa href=\http://www.charmed-guide.com/pictures/ . $row[pic] .jpg\ target=_blank\n; echo img src=\http://www.charmed-guide.com/pictures/; .

[PHP-DB] Informix - ifx_num_rows

2001-08-22 Thread Leila
Hi all, I have Php 4.0.6 on Linux with Informix Dynamic Server 7.31.UD1. I try to use the function ifx_num_rows after afx_query and the value returned is always 0, but i can see the result with ifx_fetch_row. Does Anyone know if there is a bug with this function ifx_num_rows ? Thanks in

[PHP-DB] Re: Query construction

2001-08-22 Thread Michael Kumar
dang, messed up the order of statements, sorry. of course it must read: select count(*) from posts where category = 'foobar' group by category regards, mike. -- mfG, Michael Kumar (michael.kumar_at_nme.at, m.kumar_at_hushmail.com) PGP: 30FE 3AB9 5077 C554 5D9E B5CC 0B0F CFB2 55D6 AA75 .:

[PHP-DB] Re: ORA-12541: TNS:no listener error

2001-08-22 Thread Tom Tsongas
Joe, I built PHP with oracle and oci8 extensions. I built it as a static module for Apache 1.3.20. If you are getting errors from running 'configure' (something like it can't locate the Oracle libraries) its because the Oracle 8 library searched for is hard coded as libclntsh.so.8.0

[PHP-DB] Getting key of row just inserted into mySQL

2001-08-22 Thread Grant Boggs
What's the best way to get the primary key of a row just inserted into a mySQL database? If the primary key is autoincrement, I insert a row. It's successful, but now how to do I read back the key of this table? Right now I'm adding a md5 hash of the session id into the row I'm

Re: [PHP-DB] Getting key of row just inserted into mySQL

2001-08-22 Thread Chris Hobbs
mysql_insert_id() Grant Boggs wrote: What's the best way to get the primary key of a row just inserted into a mySQL database? -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster:

RE: [PHP-DB] Getting key of row just inserted into mySQL

2001-08-22 Thread Matthew Loff
This has been covered countless times on the list... :) http://www.php.net/manual/en/function.mysql-insert-id.php -Original Message- From: Grant Boggs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 7:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Getting key of row just

Re: [PHP-DB] Getting key of row just inserted into mySQL

2001-08-22 Thread Grant Boggs
Matthew Loff [EMAIL PROTECTED] wrote in message 002b01c12b64$92e1cc80$0100a8c0@bang">news:002b01c12b64$92e1cc80$0100a8c0@bang... This has been covered countless times on the list... :) http://www.php.net/manual/en/function.mysql-insert-id.php I figured as much. Thanks guys! --

[PHP-DB] Re: how should i test my php program performance?

2001-08-22 Thread haheho
Dear all ^^ : Thank for help! The methods which had provided are test single php script page. If I want to test performance of hole site (the site was constructed by php) , how should I do? Thank for help again! haheho -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Installing mcrypt?

2001-08-22 Thread Brad Lipovsky
I am trying to install the mcrypt libraries on a Windows 98 computer running Apache1.3.20 and PHP 4.0.6. I cant really find anywhere on the net that goes over the installation process, and the readme doesnt describe installation. Does anyone know how to do this, or where I can find a site that

[PHP-DB] MySQL DB CleanUp Help!

2001-08-22 Thread Arcadius A.
Hello ! I'd like to automatically delete old entries from my MySQL Is there any special funcion in PHP or MySQl for doing that ? For that purpose, I've created a PHP script (form) that delete old entries when I submit a form ... but I'd like the scrip to do the job periodically(for instance

[PHP-DB] establish mysql server....install

2001-08-22 Thread haikal
Hello... I just installing RedHat linux 7.1, i have problem in starting mysql server the Mysql hadbeen installed throgh RedHatPackageManager...but when i start it and error message can't connect throgh port server. issued . when i use command safe_mysqld , it runs just a second

[PHP-DB] variables

2001-08-22 Thread J-E-N
Hello there. Is there a way to know whether a variable was passed by a form or just typed from the address bar?

RE: [PHP-DB] variables

2001-08-22 Thread Beau Lebens
if there is a value in $HTTP_POST_VARS[variable_name] then it came via a form with method=POST, if there's a value in $HTTP_GET_VARS[variable_name] then it came from querystring or a form with method=GET beau // -Original Message- // From: J-E-N [mailto:[EMAIL PROTECTED]] // Sent:

Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Jay Paulson
I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops... jay - Original Message - From:

Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Gabe da Silveira
I know nothing about this, but did you investigate 'SHOW TABLE STATUS' for any clues? In article 018601c12b3c$2c2970b0$6e00a8c0@webdesign, [EMAIL PROTECTED] (Jay Paulson) wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p

[PHP-DB] RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
On 22-Aug-2001 Jay Paulson wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops...

[PHP-DB] RE: [PHP] Re: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Don Read
On 22-Aug-2001 Jay Paulson wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops...

[PHP-DB] MySQL read only?

2001-08-22 Thread Jay Paulson
Anyone know why a MySQL table is set to read only? I'm logged in as the root user of MySQL and I have checked the privalages of the root user in the MySQL table and everything is set to Yes and I'm able to add and delete users in the MySQL table. Here's what I did... I had a database on my

[PHP-DB] Move recordset to first record problems...

2001-08-22 Thread Veniamin Goldin
Please help me ! How to move recordset to the first record (i use to connect to database using ODBC). Thank you ! -- 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

Re: [PHP-DB] Move recordset to first record problems...

2001-08-22 Thread Miles Thompson
I guess it depends on the ODBC driver. If it lets you pass commands directly to the database, something like s SQL_PASSTHRU, use that faciity. Otherwise use the SELECT command to fetch the first record. Normally this is a two step process: execute the select, then use a while loop to step

[PHP-DB] Re: MySQL read only?

2001-08-22 Thread Gabe da Silveira
This would probably be a better question for a MySQL newsgroup... Anyway, I am just talking off the top of myhead since I never did anything like this, but i don't think copying DB files is the proper way to move databases. I believe there is some MySQL dump utility you need to create one