[PHP-DB] Oracle Oci*Logon

2001-08-21 Thread Andrey Hristov
/8.1.5); /***/ but if my web server is an Apache under windows and the oracle is on other machine under Linux(RH), what have to be done to make my PHP work with the DB. Many thanks. Sincerely : Andrey Hristov -- PHP Database Mailing List (http

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

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

2001-08-22 Thread Andrey Hristov
use linux but think that the name of the executable is 'ab' Andrey Hristov http://www.icygen.com 99% - Original Message - From: haheho [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 6:23 PM Subject: [PHP-DB] how should i test my php program performance? Dear

Re: [PHP-DB] variable if statement

2001-08-23 Thread Andrey Hristov
$func_body = return ($a==1 or $b==2); $newfunc = create_function('$a,$b',$func_body); if ($newfunc($first_par,$second_par)){ } or if ($newfunc($a,$b,return (\$a==1 or \$b==2);)){ } or if ($newfunc($a,$b,'return (\$a==1 or \$b==2);')){ } Hope this will help. Andrey Hristov

Re: [PHP-DB] variable if statement

2001-08-23 Thread Andrey Hristov
==1) which given to eval() will work. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 8:27 PM Subject: RE: [PHP-DB] variable if statement eval will work

Re: [PHP-DB] Getting SQL queries from existing DB

2001-08-27 Thread Andrey Hristov
Get and install phpMyAdmin. It can dump to you, the stucture, the data or both. Then save them from the browser(better with lynx because you can get the source of a page piped). And pipe it to another mysql, or use it in another phpMyAdmin. Andrey Hristov IcyGEN Corporation http

Re: [PHP-DB] DISTINCT in SQL query

2001-08-27 Thread Andrey Hristov
will fork too much. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: Scott Mebberson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 9:33 AM Subject: [PHP-DB] DISTINCT in SQL query Hi Guys, I am retriving information based

Re: [PHP-DB] br appear in Text file

2001-08-27 Thread Andrey Hristov
See: 1)strip_tags 2)fgetss 3)preg_replace('|(.*?)(.*?)(/.*?)|','\2',$string); Example: ?php $string=a href=''alabala/a; $string=preg_replace('|(.*?)(.*?)(/.*?)|','\2',$string); echo htmlspecialchars($string); ? Produces : alabala Andrey Hristov IcyGEN Corporation http://www.icygen.com 99

Re: [PHP-DB] Getting SQL queries from existing DB

2001-08-27 Thread Andrey Hristov
phpMyAdmin can do this also. Can dump the data and structure to SQL Statements. The problem appears if the table for dumping is 100,000 rows or something bigger than the computer can get and start swapping. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message

Re: [PHP-DB] Special character on an INSERT statement

2001-08-28 Thread Andrey Hristov
Use addslashes() when inserting/updating the DB use stripslashes() when extracting. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: Jorge Giménez Mayorgas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 7:48 PM Subject: [PHP

Re: [PHP-DB] MD5 (' ')

2001-08-29 Thread Andrey Hristov
I'm not so sure, but there is another parameter to md5() - the salt. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: Ignat Ikryanov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 4:45 PM Subject: [PHP-DB] MD5 (' ') Hi! I

Re: [PHP-DB] Couldn't get all data using the mysql_fetch_array function, Pls Help!!!!

2001-08-29 Thread Andrey Hristov
while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { foreach ($row as $value){ print ($value |); } } - Original Message - From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 6:16 PM Subject: [PHP-DB] Couldn't get all data using the

Re: [PHP-DB] PHP and ms Access

2001-08-31 Thread Andrey Hristov
I think that by using ODBC you can connect to the MS Access server. Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: user [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 31, 2001 4:33 PM Subject: [PHP-DB] PHP and ms

Re: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-11 Thread Andrey Hristov
$my_arr= array(.); echo implode(' ',array_keys($my_arr)); Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 4:23 PM Subject: RE: [PHP-DB

Re: [PHP-DB] access my cgi-bin

2001-09-11 Thread Andrey Hristov
/test.php Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'its me' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 4:25 PM Subject: RE: [PHP-DB] access my cgi-bin yeah, that should

Re: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-11 Thread Andrey Hristov
, ok, sorry for the disturbance. greets. Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; Rick Emery [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 4:39

Re: [PHP-DB] How to write errorhandling??

2001-10-22 Thread Andrey Hristov
That's correct. I've seen a discussion on dev phorum about embeding SMTP code in PHP, but as I remember the final decision was that SMTP code will stay outside of PHP code. -- Andrey Hristov Web Developer Icygen Corporation BUILDING SOLUTIONS http://www.icygen.com On Monday 22 October 2001

Re: [PHP-DB] Embedding Perl

2001-10-24 Thread Andrey Hristov
: There is a solution but I don't know how good is it? I'm not sure but the name of the project is PHPerl or something about it. -- Andrey Hristov Web Developer Icygen Corporation BUILDING SOLUTIONS http://www.icygen.com On Wednesday 24 October 2001 12:05 pm, you wrote: I have a small

Re: [PHP-DB] TREE in a database

2001-10-29 Thread Andrey Hristov
to change by user). I think that this makes clear how to implement the tree. Have fun. -- Andrey Hristov Web Developer Icygen Corporation BUILDING SOLUTIONS http://www.icygen.com On Monday 29 October 2001 03:02 pm, you wrote: Is there an easy way to implement tree structure in a database

Re: [PHP-DB] Next

2001-11-14 Thread Andrey Hristov
Use sessions. (session_start() and session_register()), and at the start of the test save row_ids(question_ids) in arrray which you make with session_register a session variable. On other pages you do session_start() and after that you have access to the array. Regards, Andrey Hristov IcyGEN

Re: [PHP-DB] Query help

2001-11-16 Thread Andrey Hristov
it in USING Other problems? Write.. Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Matt Williams [EMAIL PROTECTED] To: Php-Db@Lists. Php. [EMAIL PROTECTED] Sent: Friday, November 16, 2001 5:20 PM Subject: [PHP-DB] Query help

Re: [PHP-DB] Query help

2001-11-16 Thread Andrey Hristov
Ooops SELECT count(f.room),WEEK(MAX(b.date),1), WEEK(MIN(b.date),1) FROM freerooms as f LEFT JOIN booking AS b USING(room); Apolgizes - Original Message - From: Andrey Hristov [EMAIL PROTECTED] To: Matt Williams [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 16, 2001

Re: [PHP-DB] Re: Html email

2001-10-24 Thread Andrey Hristov
-- Andrey Hristov Web Developer Icygen Corporation BUILDING SOLUTIONS http://www.icygen.com -=-=-=--==--==--=-=-=-=-=-=-=-=-=-==--=-=-=-=-==--=-= Hello-     I've always had this type of mail statement work for me: mail($to, $Subject, $Body, From: $From\r\nContent-Type: text/html; charset=iso

Re: [PHP-DB] gzip image files

2001-11-27 Thread Andrey Hristov
= gzencode($data, 9); $fp = fopen(bigfile.txt.gz, w); fwrite($fp, $gzdata); fclose($fp); ? Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Keith Whyman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 4:23

Re: [PHP-DB] gzip image files

2001-11-27 Thread Andrey Hristov
($fp, $gzdata); fclose($fp); // this is ok Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Keith Whyman [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 5:06 PM

[PHP-DB] [PHP] Coding methods (was RE: [PHP-DB] gzip image files)

2001-11-27 Thread Andrey Hristov
When you use the parser scans the string for variables. When ' is used it is not parsed. So you know what $variable to put, concatenate the strings with the variable(s). I think it's a faster method. IMO, yes it seems ugly, but I want to be faster not so readable as a novel. Regards, Andrey

Re: [PHP-DB] gzip image files

2001-11-27 Thread Andrey Hristov
Message - From: Keith Whyman [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 5:30 PM Subject: Re: [PHP-DB] gzip image files ha it works ! thanks ! now just one last question :-)) how can i name my png in the gz file so

Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?

2001-11-28 Thread Andrey Hristov
Try header('Content-type: image/gif'); Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: PaulC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 10:28 AM Subject: Re: [PHP-DB] Storing JPEG's in MySQL

Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?

2001-11-28 Thread Andrey Hristov
excuses, image/jpeg - Original Message - From: PaulC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 10:28 AM Subject: Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible? I am using this to read the uploaded file $attach_data =

Re: [PHP-DB] JOIN Very SLOW...

2001-11-28 Thread Andrey Hristov
. Regards, Andrey Hristov - Original Message - From: Martin E. Koss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 12:09 PM Subject: [PHP-DB] JOIN Very SLOW... The following does work but it extremely slow. $phselect = select COUNT(*) AS phTotal from properties LEFT

Re: [PHP-DB] query + loop problem

2001-11-28 Thread Andrey Hristov
echo table\r\n; while($row = mysql_fetch_assoc($result)) { // if assoc is not available - will work but double results foreach($row as $key = $value){ echo trtd$key/tdtd$value/td/tr\r\n; } }//end loop echo /table\r\n; HTH Regards, Andrey Hristov IcyGEN Corporation http

[PHP-DB] Re : alternate

2001-11-29 Thread Andrey Hristov
{ $forumlist .= forum($group, index_forum); } } Regards Andrey Hristov - Original Message - From: MrBaseball34 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 5:31 PM Subject: [PHP-DB] Alternating rows pulled from database I am trying

Re: [PHP-DB] Change value in the table

2001-12-23 Thread Andrey Hristov
Regards, Andrey Hristov - Original Message - From: Nagasea [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 23, 2001 4:56 PM Subject: [PHP-DB] Change value in the table I want to change all the text XXX to YYY in the posts_text table. I know i can do that in the phpMyAdmin

Re: [PHP-DB] Potential for optimizing a huge table for querries?

2001-12-27 Thread Andrey Hristov
Mysql has support for indexes on two or more fields. So you can create index on country_code AND province. At the moment I cannot remember the syntax but look at the docs www.mysql.com/doc/ to find it. HTH Regards, Andrey Hristov - Original Message - From: Andy [EMAIL PROTECTED

Re: [PHP-DB] Formated Results

2002-01-07 Thread Andrey Hristov
Try printing pre before and /pre after them Regards, Andrey Hristov - Original Message - From: Barry Rumsey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 07, 2002 2:19 PM Subject: [PHP-DB] Formated Results Hi I have a database that has lyrics in it. I can get them

Re: [PHP-DB] mysql.so

2002-01-08 Thread Andrey Hristov
Old modules (compiled for php 4.0.x) are not binary compatible with 4.1.x series. To compile oci8.so you need an oracle installation. More info on oracle from Thies Arntzen. I'm not sure but ./configure --enable-mysql make will produce the .so Regards, Andrey Hristov - Original Message

Re: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Andrey Hristov
try this : select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); - Original Message - From: Necro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 6:18 PM Subject: RE: [PHP-DB] MySQL Result Resource Same error...

Re: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Andrey Hristov
Resource Parse error: parse error in d:\htdocs\infekt\packages\auth.inc on line 104 $arg = select password, 1 as auth from acl where (username='andrewd' and password=MD5(andrewd.madonna)); Nope :( -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent

Re: [PHP-DB] Disable Right click w/ php?

2002-02-14 Thread Andrey Hristov
No way. PHP is server-side. Javascript is mostly clientside. Best regards, Andrey Hristov - Original Message - From: jas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 8:17 AM Subject: [PHP-DB] Disable Right click w/ php? I have been looking on php.net

Re: [PHP-DB] Getting the ID of the last inserted record possible?

2002-02-23 Thread Andrey Hristov
mysql_insert_id() Regards Andrey - Original Message - From: Andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 23, 2002 3:32 PM Subject: [PHP-DB] Getting the ID of the last inserted record possible? Hi there, I would like to name pictures I uploaded after the

Re: [PHP-DB] Shopping Cart ?

2002-02-24 Thread Andrey Hristov
instead of php4). Best regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: php List [EMAIL PROTECTED] Sent: Monday, February 25, 2002 9:50 AM Subject: [PHP-DB] Shopping Cart ? Hi All, I am

Re: [PHP-DB] Problem with symbol

2002-02-24 Thread Andrey Hristov
The problem is that you probably use phpMyAdmin for editing data. Regards, Andrey Hristov - Original Message - From: Marco Coletta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 25, 2002 10:08 AM Subject: [PHP-DB] Problem with symbol I have a problem with symbol

Re: [PHP-DB] Problem with symbol

2002-02-25 Thread Andrey Hristov
phpMyAdmin has changed to amp; and then put it in the DB. So it is better not to use phpMyAdmin or any toher web based tool for tasks which includes entering. Not sure for , Regards, Andrey Hristov - Original Message - From: Marco Coletta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: [PHP-DB] Problem with symbol

2002-02-25 Thread Andrey Hristov
I could not find with the PHP script the record I looked in with phpMyadmin. Andrey Hristov [EMAIL PROTECTED] ha scritto nel messaggio 010801c1bdd7$576e9dd0$0b01a8c0@ANDreY">news:010801c1bdd7$576e9dd0$0b01a8c0@ANDreY... phpMyAdmin has changed to amp; and then put it in the D

Re: [PHP-DB] Looking for a good MySQL db abstraction layer

2002-03-08 Thread Andrey Hristov
Try those provided in PEAR(in the distro). Best regards, Andrey Hristov On Friday 08 March 2002 08:04 pm, you wrote: I'm looking for a good MySQL db abstraction layer. I'm just coming back to PHP/MySQL and rather writing my own I figured I'd try to see if any are already out

Re: [PHP-DB] Is this possible in mysql?

2002-03-08 Thread Andrey Hristov
list($sum)=mysql_fetch_assoc(mysql_query('SELECT SUM(salary') FROM employes;')); Best regards, Andrey Hristov On Friday 08 March 2002 09:17 pm, you wrote: I need to add up the (integer) values of columns, and return the added up value as one column to php. Is this possible

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Andrey Hristov
select cat_id, count(prod_id) from some_table order by cat_id; Best regards, Andrey Hristov - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 12:46 PM Subject: [PHP-DB] a Count() ? Hi All I am trying to count how many

Re: [PHP-DB] Joining three tables

2002-03-16 Thread Andrey Hristov
using(parent_id); or select * from parents,parentlog left join students using(student_id) where parents.parent_id=parentlog.parent_id; Hope this helps. Andrey Hristov - Original Message - From: John Hughes, Jomari Works [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 16, 2002 8

Re: [PHP-DB] How to add 2 years to todays date ?

2002-03-18 Thread Andrey Hristov
In php $your_timestamp += gmmktime(0,0,0,1,1,1972); MySQL has INTERVALling options. Regards, Andrey - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 10:11 AM Subject: [PHP-DB] How to add 2 years to todays date ? Hi All I

Re: [PHP-DB] Selecting Alphabetically

2002-03-21 Thread Andrey Hristov
select * from sometable where (SUBSTRING(somefield,1,1) in ('a','b','c','d','f','g','h')) AND (SUBSTRING(somefield,2,1) in ('i','j','k','l','m','n','o','p')); Best regards, Andrey Hristov - Original Message - From: Jordan Elver [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday

Re: [PHP-DB] Relational database

2002-03-21 Thread Andrey Hristov
The info is not full but I'll try to help. Lets say the name of the field in the two tables is common_field. Then we do SELECT all_that_is_needed FROM table1,table2 WHERE table1.common_field=table2.common_field; And an optimized variant: SELECT all_that_is_needed FROM table1 LEFT JOIN table2

Re: [PHP-DB] Relational database

2002-03-22 Thread Andrey Hristov
Otidi tuk : http://www.php.net/unsub.php i vig kak se pravi Unsubscribe Andrey - Original Message - From: Stefan [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; 'Ron' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 10:37 AM Subject: RE: [PHP-DB

Re: [PHP-DB] Comparing Strings

2002-03-25 Thread Andrey Hristov
eregi(). Regards, Andrey Hristov - Original Message - From: John Fishworld [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 25, 2002 12:59 PM Subject: [PHP-DB] Comparing Strings Whats the best way to compare 2 strings (city names - one in db one user entry) At the moment

[PHP-DB] Re: [PHP] PHP and Oracle

2002-03-26 Thread Andrey Hristov
On Mon, Mar 25, 2002 at 02:49:07PM -0500, Scarbrough, Jeb (ISS Atlanta) wrote: Is it possible to create a transaction the involves multiple pages using PHP and oracle. For example, can I log onto oracle using OCIPLogon on one page named master, insert information, go to the next page

Re: [PHP-DB] variation on(Speed Up Code?)

2002-03-26 Thread Andrey Hristov
(RIGHT JOIN) is probably the best choice escpecially if you have very big tables). Regards, Andrey Hristov - Original Message - From: George Pitcher [EMAIL PROTECTED] To: [EMAIL PROTECTED]; PHP-DB [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:49 AM Subject: [PHP-DB] variation

Re: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215

2002-03-28 Thread Andrey Hristov
Do you receive ???s ? Regards, Andrey - Original Message - From: Igor Georgiev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 7:11 PM Subject: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215 PHP 4.1.2 Apache 1.3.23 Slackware 7.1

Re: [PHP-DB] Reading a file and inserting into Access

2002-03-28 Thread Andrey Hristov
Is it possible Access to load a bunch of SQLs and execute them? If it is possible it is better than CSV. Mysql has a command-line tool for table database dump into SQLs. Another solution is to look at PHPMyAdmin's code to view how it dumps tables. Best regards, Andrey Hristov - Original

Re: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215

2002-03-28 Thread Andrey Hristov
This seems a unicode problem to me. Here we have similar problem when PHP connects to Access 2000 and receives ???s. No problems with Access 97. Are you sure that the data is 1 byte not unicode format? Andrey - Original Message - From: Igor Georgiev [EMAIL PROTECTED] To: Andrey Hristov

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andrey Hristov
LIMIT limits only to output. So if a SELECT creates 1 million rows and you LIMIT 10, you got the first 10 rows but the full SELECT is done. To speedup consider adding some id columnt with unique ints in ascending order. Andrey P.S. I've to go. Have a nice evening. - Original Message

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andrey Hristov
Another suggestion - use explicit joins. SELECT c.*, p.province, co.country FROM test.cities AS c LEFT JOIN test.countries AS co USING(country_c) LEFT JOIN test.provinces AS p ON c.province_no=p.province_id ORDER BY country , province limit 0, 10; This might work. If not read the docs at

Re: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db?

2002-04-11 Thread Andrey Hristov
Get all table names in a db and lock them :show tables;; Andrey - Original Message - From: andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:37 PM Subject: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db? Hi there, I am

Re: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db?

2002-04-11 Thread Andrey Hristov
is closed. Andrey - Original Message - From: andy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:47 PM Subject: Re: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db? what if I have 50 tables?? Andrey Hristov [EMAIL PROTECTED] schrieb im

Re: [PHP-DB] database absraction layer

2002-05-06 Thread Andrey Hristov
Look at PEAR repository for userspace abstraction layer. Look at the dbx extension for compiled abstraction layer. Andrey - Original Message - From: adi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 4:08 AM Subject: [PHP-DB] database absraction layer dear all,

[PHP-DB] Re: Re:[2] [PHP-DB] database absraction layer

2002-05-06 Thread Andrey Hristov
want is, they don't have to --enable-dbx or enable pear in their php configuration to be able to use this class. Andrey Hristov [EMAIL PROTECTED] wrote on 5/7/02 9:29:24 AM: Look at PEAR repository for userspace abstraction layer. Look at the dbx extension for compiled abstraction layer

Re: [PHP-DB] Global variables, $_GET problem

2002-07-24 Thread Andrey Hristov
- Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 6:45 AM Subject: Re: [PHP-DB] Global variables, $_GET problem On Wednesday 24 July 2002 11:38, Ruth Zhai wrote: We just upgraded our PHP to version 4.2.1. I realized that

Re: [PHP-DB] Re: PicoSQL!

2002-07-24 Thread Andrey Hristov
There is another small RDBMS that supports subset of the ANSI-92 standart. It's name is SQLite there is a module for it here :http://sourceforge.net/projects/sqlite-php/ MOre info about SQLite here : http://www.hwaci.com/sw/sqlite/ Regards, Andrey - Original Message - From: Pentothal

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
Maybe it will help you but I've read that when using persistent connections PHP uses 2 on every request. So if in one moment you have 10 scripts,that use persistent connections, running you will have 20 connections used to the mysql. Regards, Andrey - Original Message - From: Paul

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
PROTECTED] Andrey Hristov [EMAIL PROTECTED] wrote in message 01cd01c237e8$7e1438b0$1601a8c0@nik">news:01cd01c237e8$7e1438b0$1601a8c0@nik... Maybe it will help you but I've read that when using persistent connections PHP uses 2 on every request. So if in one moment you have 10

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
the default of 100. [/snip] Andrey - Original Message - From: Rasmus Lerdorf [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: Paul Worthington [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 7:59 PM Subject: Re: [PHP-DB] mysql_fetch_array limit? - more details

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
Yeaah! I am a fool. My biggest excuses. Sorry Rasmus and everyone else. Andrey - Original Message - From: Rasmus Lerdorf [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 30, 2002 8:11 PM Subject: Re: [PHP-DB] mysql_fetch_array limit

Re: [PHP-DB] [mysql] query atomicity

2002-09-04 Thread Andrey Hristov
);'); you must have in the rollback array this $rollback_ar = array('DELETE FROM some_table WHERE k1=4 and k2=2;', 'DELETE FROM some_table WHERE k1=5 and k2=3'); Hope this is clear. Best regards Andrey Hristov - Original Message - From: :B nerdy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: [PHP-DB] Millions of records in MySQL

2002-10-25 Thread Andrey Hristov
Go to www.mysql.com and join their's general list. it's address is [EMAIL PROTECTED] Andrey - Original Message - From: Steve Vernon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 2:15 PM Subject: Re: [PHP-DB] Millions of records in MySQL Which is the MySQL

Re: [PHP-DB] Sessions Vs DB Access

2002-11-25 Thread Andrey Hristov
Quick hack for those who think that the MM handler is not stable is to use the standard handler and the directory where the session files will be to be mounted as tmpfs (even /tmp). This will give almost of the MM's speed without worrying whether MM is stable or not. Andrey - Original

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread Andrey Hristov
AFAIK he uses *nix, not windows. (.so-s are possible sollution but prebuilt ones are not shipped with php). Andrey - Original Message - From: xxx [EMAIL PROTECTED] To: Anthony Carlos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:32 PM Subject: Re: [PHP-DB]

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread Andrey Hristov
- Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; xxx [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:37 PM Subject: RE: [PHP-DB] Oracle/PHP question... Correct. I am working on Unix, specifically HP

Re: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread Andrey Hristov
Compile with --with-oci8 Andrey - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:56 PM Subject: RE: [PHP-DB] Oracle/PHP question... I am running Oracle 8.0.6.3. Do I need

Re: [PHP-DB] FW: Oracle connectivity question...

2002-12-18 Thread Andrey Hristov
Hey, A friend of mine told me that : kalo 19:02: trjanbva ti tnsping vdb.masq kalo 19:02: uf.. ne znam kak ce nastrojva tnslistaner-a..;( kalo 19:03: ima si programa s kojato se pipat nastraojkite na TNSListener-a kalo 19:03: ina4e ne mozesh ada se zaka4ish.. Translared to english : 19:02

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Andrey Hristov
Hi, Does mysql user has rights to write in this directory or permissions over this file? Andrey - Original Message - From: conbud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 03, 2003 11:00 AM Subject: [PHP-DB] MySQL Database connection Problem Hello can someone

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Andrey Hristov
http://www.alt-php-faq.org/local/74/ Question : I am trying to create a database and keep getting an error :- (Errcode: 28) Answer : errcode: 28 No space left on device This means that you are out of disk space. Try du to see how much space is free/used Best regards Andrey Hristov

Re: [PHP-DB] MySQL Database connection Problem

2003-01-03 Thread Andrey Hristov
on the server and about 17 gig of that is still alloted to the database. Andrey Hristov [EMAIL PROTECTED] wrote in message 010c01c2b309$8d8d7210$1601a8c0@andreywin">news:010c01c2b309$8d8d7210$1601a8c0@andreywin... http://www.alt-php-faq.org/local/74/ Question : I am trying t

Re: [PHP-DB] Help about printing an integer variable

2003-01-06 Thread Andrey Hristov
something like printf(%+4d, $int_var); Andrey - Original Message - From: Martín Agüero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 4:52 PM Subject: [PHP-DB] Help about printing an integer variable I need to print an integer varible using this format '',

Re: [PHP-DB] Special characters

2003-01-06 Thread Andrey Hristov
Fernando, try to store you data in unicode (utf8) for example. You iconv to transform if it is needed. Andrey - Original Message - From: Bernain, Fernando G. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 06, 2003 7:25 PM Subject: [PHP-DB] Special characters I'm

Re: [PHP-DB] Special characters

2003-01-06 Thread Andrey Hristov
to transform you iso-8859-1 strings to utf8. after retrieving from db just converted them fron unicode. Regards, Andrey - Original Message - From: Bernain, Fernando G. [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; Bernain, Fernando G. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday

Re: [PHP-DB] blob

2003-01-07 Thread Andrey Hristov
Keep in mind that BLOB is up to 64k thus you may need larger BLOB. Look at the mysql's documenations for more information http://www.mysql.com/doc/en/ Andrey P.S. Have a nice night. - Original Message - From: Natividad Castro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday,

Re: [PHP-DB] foreach($HTTP_POST_VARS as $key = $value)

2003-01-22 Thread Andrey Hristov
independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] ?php /** Definition file - defintions of various data. This module is part from PHPIntra system and is licensed under GPL. @author Andrey Hristov [EMAIL PROTECTED] @version$Id: pi-validate.defs.php,v 1.3 2002/07/09

Re: [PHP-DB] problem with copy()

2003-01-28 Thread Andrey Hristov
AFAIK none is put into tmp_file when the file upload wasn't successful. Andrey - Original Message - From: Bartosz Matosiuk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 2:07 PM Subject: [PHP-DB] problem with copy() hi can the string source in copy ()