[PHP-DB] RE: [PHP] question ! show binary

2001-01-30 Thread Maxim Maletsky
... Hope this is something that helps. Cheers, Maxim Maletsky -Original Message- From: Yui Hiroaki [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 2:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] question ! show binary HI! I am using PHP in mySQL. I cr

[PHP-DB] RE: [PHP] Passing vars

2001-02-15 Thread Maxim Maletsky
you can use sessions .. php.net/sessions the session are cookies which will remember the user and will copy what you need on your system, making these 30 lines available only to him for the time you specify. Cheers, Maxim Maletsky -Original Message- From: Tanya Brethour [mailto:[EMAIL

[PHP-DB] Re: [PHP] PHP and databases? ...without MySQL and such

2002-10-23 Thread Maxim Maletsky
contention is: always use a database as the base for your data or Always use 'files' to store the things to include in files -- Maxim Maletsky [EMAIL PROTECTED] www.PHPBeginner.com // PHP for Beginners www.maxim.cx // my Home // my Wish List: ( Get me something! ) http://www.amazon.com

Re: [PHP-DB] sort by date

2002-11-06 Thread Maxim Maletsky
Great! But, many people cannot *understand* the manuals for their own reasons, that is why they ask - they hope to get some sample code. Shall we? -- Maxim Maletsky [EMAIL PROTECTED] Peter Beckman [EMAIL PROTECTED] wrote... : Hey, there are a lot of new people who are starting with PHP

Re: [PHP-DB] sort by date

2002-11-06 Thread Maxim Maletsky
into this mailing list or we answer mostly with the links to FAQs. There is really no other way. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] oci function

2002-11-07 Thread Maxim Maletsky
you need to compile it with oci8 extension: http://uk.php.net/manual/it/ref.oci8.php -- Maxim Maletsky [EMAIL PROTECTED] Maziar [EMAIL PROTECTED] wrote... : Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I

Re: [PHP-DB] session variables

2002-11-07 Thread Maxim Maletsky
the screen? Is it possiable that it is the way i have my query set up? It can be mySQL's bug. To get rid of that error just add at-mark (@) infront of the function call: @mysql_connect(... or whatever -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria

2002-11-07 Thread Maxim Maletsky
. -- Maxim Maletsky [EMAIL PROTECTED] Ruprecht Helms [EMAIL PROTECTED] wrote... : Hi kristina, [...] I can see that phpMyAdmin does this, which is great but I need it for joe public to be able to use. so I don't want them using phpMyAdmin. If you can't use phpMyAdmin try to make

Re: [PHP-DB] How to list Oracle table names

2002-11-08 Thread Maxim Maletsky
SELECT * FROM user_tables; will give you the list of tables and properties. I think the table name's columns is called: 'table_name' so this should be: SELECT table_name FROM user_tables; -- Maxim Maletsky [EMAIL PROTECTED] [EMAIL PROTECTED] wrote... : I'm very new at this. Can I list

Re: [PHP-DB] Array question

2002-11-08 Thread Maxim Maletsky
to precise: $array = Array('name'='Maxim', 'surname'='Maletsky'); unset($array['name']); // now array has this structure: // Array('surname'='Maletsky') -- Maxim Maletsky [EMAIL PROTECTED] Jason Wong [EMAIL PROTECTED] wrote... : On Friday 08 November 2002 17:25, nikos wrote: Does

Re: [PHP-DB] ROugh idea of speed

2002-11-08 Thread Maxim Maletsky
holding around one million of records with mySQL. PostgreSQL worked well for me on 5-10 mils and Oracle works smoothly on 3.5 Terrabytes of data. Cheers -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] indexing on existing DB

2002-11-08 Thread Maxim Maletsky
Index is always re-indexing itself on INSERT/UPDATE. Roughly, I don't think there is any difference in when you create an index before or after table is populated. -- Maxim Maletsky [EMAIL PROTECTED] Jason Vincent [EMAIL PROTECTED] wrote... : (I know this is more of a mySQL question than

Re: [PHP-DB] Re: ROugh idea of speed

2002-11-08 Thread Maxim Maletsky
d.. 20 GB traffic/month e.. RedHat LInux 7.2 Red Hat Advanced Server is better - it has Oracle patches for better asynch i/o performance. If for Oracle, I'd then recommend SuSe. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] indexing on existing DB

2002-11-08 Thread Maxim Maletsky
the index when server is not busy. However, this is rare. Most often you will need to make your SQL smarter to inject data all at once like SELECT INTO. This (supposly) will do indexing only once as it is only one operation. Well, even if mySQL is not THAT relational. -- Maxim Maletsky

Re: [PHP-DB] ROugh idea of speed

2002-11-09 Thread Maxim Maletsky
set on it - mySQL or pgSQL - as long as you can keep both HTTP and DB separate. Especially because you're using DB layers in PHP etc. -- Maxim Maletsky [EMAIL PROTECTED] On Sat, 9 Nov 2002 10:18:22 - Peter Lovatt [EMAIL PROTECTED] wrote: Hi I have been following the thread and I am

Re: [PHP-DB] Optimizing

2002-11-10 Thread Maxim Maletsky
add an index on both of them, and, if this is the most common (heaviest) query for you do it together sequentially: (name, surname) I hope you get the idea. -- Maxim Maletsky [EMAIL PROTECTED] On Sun, 10 Nov 2002 13:46:33 -0500 Chris Payne [EMAIL PROTECTED] wrote: Hi there everyone, How

Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Maxim Maletsky
I can already say that Oracle is faster. But official benchmark I have never seen. Have you wondered aboout ACID test results for both? -- Maxim Maletsky [EMAIL PROTECTED] Manos Papagelis [EMAIL PROTECTED] wrote... : Hello to all, I have searched enough to find some official benchmarks

Re: [PHP-DB] Are there any Oracle vs Postgresql official benchmarks

2002-11-11 Thread Maxim Maletsky
is a lot of money... So, if there are no budget problems (means you spend no cent extra) go for Oracle, otherwise choose pgSQL as it is also very powerfull. -- Maxim Maletsky [EMAIL PROTECTED] Manos Papagelis [EMAIL PROTECTED] wrote... : Any kind of results are precious although I would

Re: [PHP-DB] Access a Flat File DB - How?

2002-11-12 Thread Maxim Maletsky
that is currently being written and would not write the data that is currently being read. -- Maxim Maletsky [EMAIL PROTECTED] Crony [EMAIL PROTECTED] wrote... : I have written a few small apps in PHP and MySQL. These were mostly copy, paste and change and fairly easy. I now wnat ot connect to a flat

Re: [PHP-DB] PHP and ORACLE conection error

2003-01-30 Thread Maxim Maletsky
-strike, hosting gratuit, servicii internet... Fii cu un pas inaintea celorlati! -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] page splitting

2003-02-02 Thread Maxim Maletsky
you should get a class that does that. PHP Classes (phpclasses.org) is a good place to start -- Maxim Maletsky [EMAIL PROTECTED] On Sun, 2 Feb 2003 17:37:12 +0200 Shahar Tal [EMAIL PROTECTED] wrote: Hello all! First of all i'd like to say thanks. many of you helped me here a lot, and I

Re: [PHP-DB] print

2003-02-02 Thread Maxim Maletsky
with php: echo $result['field_number_of_bedrooms'] . Bedrooms; wih SQL: SELECT CONCAT(field_number_of_bedrooms, ' Bedrooms') as field_number_of_bedrooms from table; echo $result['field_number_of_bedrooms']; -- Maxim Maletsky [EMAIL PROTECTED] On Sun, 2 Feb 2003 12:46:16 -0600 Addison

Re: [PHP-DB] select

2003-02-03 Thread Maxim Maletsky
Yes, option value=? echo $row-id; ? ? echo $selected; ? selected You've hardcoded selected there and also expect it to be set dynamically. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] heredoc and coding standards

2003-02-03 Thread Maxim Maletsky
heredoc is the fastest way to get lazy. use inline php then, easier and can use tabs, no? Tabs of 4 spaces are, normally, the most prefered. -- Maxim Maletsky [EMAIL PROTECTED] On Mon, 3 Feb 2003 11:47:12 -0600 Rob Day [EMAIL PROTECTED] wrote: I try to write very clean code. However

Re: [PHP-DB] Oracle 9.2 + IIS 5.0 + Win2k server + PHP 4.3 + ADODB 3.10

2003-02-04 Thread Maxim Maletsky
for your case. Can you please test ADODB 2.5 and tell me the results? Also, try the latest CVS at snaps.php.net (php4) and see whether this error persists there. Thanks -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PHP Database Abstraction Layer

2003-02-06 Thread Maxim Maletsky
', 'yourdbname', 'yourdbuser', 'yourdbpass' ); ? ZoomStats uses it: http://sf.net/projects/zoomstats P.S: I wrote that phparch article, and I based it on my ZoomStats experoence which I also founded. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] PHP - Oracle 7.3.4 - ORA-12154

2003-02-06 Thread Maxim Maletsky
add the failover directive in tnsnames.ora. Find how to on the web (not sure right now) -- Maxim Maletsky [EMAIL PROTECTED] On Fri, 07 Feb 2003 02:15:43 + Maron Kristófersson [EMAIL PROTECTED] wrote: Hello! I set up PHP on a Sun Solaris box a week ago (see phpinfo output below

[PHP-DB] Re: Help me!

2003-09-01 Thread Maxim Maletsky
Maletsky [EMAIL PROTECTED] On Sun, 31 Aug 2003 22:32:21 +0800 (CST) Zhixiang Wang [EMAIL PROTECTED] wrote: Dear Maxim Maletsky: Recently I install oracle 9.2.0.1 on RedHat Linux 9.0. It seems working well! But I encountered many problems, please help me! The parameter is here: ORACLE