Re: [PHP-DB] Connectivity PHP4 mysql

2004-01-16 Thread Georg Herland
Hi! That depends on what you mean... Mysql is listed in the config as --with-mysql=shared,/usr and also appears in Supported databases. It does not show in a seperate paragraph like it does on my working system. -Georg Micah Stevens [EMAIL PROTECTED] skrev i melding news:[EMAIL PROTECTED]

Re: [PHP-DB] Solaris apache 2.0.47 + php 4.3.4 + oracle 9i ( oci8 support in php as shared module )

2004-01-16 Thread Daniel Sand
Hiho Martin, Martin Marques wrote: If i make any DB connections from any Virtual Server that i configured in apache, PHP always takes the Main Ethernet Interface. Not The Virtual IP's of the card that are configure in the httpd.conf. This isn't a real problem, maybe it's allready solved. I'm

[PHP-DB] Embedded DB

2004-01-16 Thread GUIRAUDOU
Hi the List, Could somebody tell me if it exists embedded database . I would like to integrate a small database in a terminal that has not a big memory size. Please tell me if this kind of database exist and please give me some information / an Internet site where found it.

RE: [PHP-DB] Embedded DB

2004-01-16 Thread N . A . Morgan
You could try sqlite. http://www.sqlite.com/ would give you more details on sqlite, http://hu.php.net/sqlite is the PHP manual pages for the sqlite extension (PHP4). You can download the php_sqlite.dll extension for windows here as well. Neil Morgan -Original Message- From: GUIRAUDOU

RE: [PHP-DB] Embedded DB

2004-01-16 Thread GUIRAUDOU
Thank you very much I will look on this site. Regards Message Classification: [X] General Public Use [ ] Motorola Internal Use Only [ ] Motorola Confidential Proprietary Michel GUIRAUDOU -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:

[PHP-DB] Subselect ?

2004-01-16 Thread Christine Clerc
Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc. So two texts may have the same id_script but with different id_language. I need to retrieve the list (without duplicate) of

Re: [PHP-DB] Embedded DB

2004-01-16 Thread Artiom N. Matiuhov
You can also use text files for storing your info. On Fri, 16 Jan 2004 11:47:53 -, [EMAIL PROTECTED] wrote: You could try sqlite. http://www.sqlite.com/ would give you more details on sqlite, http://hu.php.net/sqlite is the PHP manual pages for the sqlite extension (PHP4). You can

Re: [PHP-DB] Embedded DB

2004-01-16 Thread Muhammed Mamedov
If you have enough time, wait till PHP5.0. They are going to embed sqlite into it. Regards, Muhammed Mamedov turkmenweb.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:47 PM Subject: RE: [PHP-DB] Embedded DB

Re: [PHP-DB] multi-language site

2004-01-16 Thread Muhammed Mamedov
Hello Ignatius, I am working on a project which requires a CLEAR seperation of code and appearance. Think of this: There is a page which lists news from DB in a specific manner (latest 10 added, and next,prev links on the bottom). Of course this requires some PHP code which will retrieve data

Re: [PHP-DB] multi-language site

2004-01-16 Thread Ignatius Reilly
Preliminary note: ALL projects should require a CLEAR seperation of code and appearance. Now: To do what you describe, if you present your data as a HTML table, I would suggest retrieving data from the DB as an arra, and using the PEAR HTML_Table class to display them. Very easy to learn and

[PHP-DB] ldap api synchronous but no timeout

2004-01-16 Thread Alban Médici (NetCentrex)
Hi all, I got a matter: I'm developping daemon in php stand alone mode. My application is designed to send same object on both ldap server (sort of replication) But once connected and bind on both server, I treat some ldap commands and IF one of the servers crash (simulating a network failure by

Re: [PHP-DB] multi-language site

2004-01-16 Thread Muhammed Mamedov
Thank you for your comments Ignatius. (just to note) : I do not agree that all projects SHOULD require CLEAR sepeartion of code and appearance. Further on this issue: Consider that there are lots of dynamic stuff like news, and there are thousands of users and all data is stored in a database.

Re: [PHP-DB] multi-language site

2004-01-16 Thread Ignatius Reilly
Usually it is the other way round: to assemble a page, a script will call successively several XSLT transformations: eg top, left nav bar, central content, footer... Each XSLT call returns HTML from content stored in XML. Ignatius I also wonder if XSLT can accept any php code? -- PHP

[PHP-DB] MySQL general Question...

2004-01-16 Thread Tristan . Pretty
What's teh diffence between 'LIKE' '=' EG: SELECT FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' I've just purchased an E-mail marketing piece of software, and was peakign in the code... Found that... Never seen it before (Have I been living in a box?) Cheers, Tris...

Re: [PHP-DB] MySQL general Question...

2004-01-16 Thread Alban Médici (NetCentrex)
with the like command you could made search such as : SELECT FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' and you could have several answer. = is for scrict equality [EMAIL PROTECTED] wrote: What's teh diffence between 'LIKE' '=' EG: SELECT FROM my_table WHERE 'email' LIKE

Re: [PHP-DB] MySQL general Question...

2004-01-16 Thread Ignatius Reilly
Standard SQL for comparing strings is LIKE '=' in lieu of 'LIKE' is a MySQL extension to SQL, therefore non-standard. Ignatius _ - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 16, 2004 15:39 Subject: [PHP-DB] MySQL general

Re: [PHP-DB] MySQL general Question...

2004-01-16 Thread John W. Holmes
[EMAIL PROTECTED] wrote: What's teh diffence between 'LIKE' '=' EG: SELECT FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' = is an equality (case insensitive). LIKE allows you to use the % character as a wildcard (will match any amount of characters) and the _ character as a wildcard to

Re: [PHP-DB] multi-language site

2004-01-16 Thread Dan Hewins
This is true. And another aspect I forgot to mention is an admin version of the whole site because the user wants to be able to update and change text in either the English or Spanish site. This way I only have to build (design, code HTML) the site once and then I essentially have four

[PHP-DB] passing a $_POST variable

2004-01-16 Thread dpgirago
Good day all, This may be easier than I'm imagining... The question: When using the header(location: ...) method for inserting or updating some $_POST['variable']'s into a MySQL db (preventing repeat insertions or updates when 'refreshing', etc...), is it possible to return a

Re: [PHP-DB] multi-language site

2004-01-16 Thread Ignatius Reilly
The same can be achieved in a much simpler way with Gettext! With gettext, you send a file to your translator, and receive the same file completed. Period. Instead of logging to a DB, the translator simply creates string translations with a user-friendly editor, such as the excellent POEdit

[PHP-DB] Re: Subselect ?

2004-01-16 Thread Justin Patrin
Christine Clerc wrote: Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc. So two texts may have the same id_script but with different id_language. I need to retrieve the list

[PHP-DB] Re: passing a $_POST variable

2004-01-16 Thread Justin Patrin
[EMAIL PROTECTED] wrote: Good day all, This may be easier than I'm imagining... The question: When using the header(location: ...) method for inserting or updating some $_POST['variable']'s into a MySQL db (preventing repeat insertions or updates when 'refreshing', etc...), is it possible to

[PHP-DB] Fw: informix problem

2004-01-16 Thread stefan bogdan
i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix clientfor nt ilogin demo works fine sql editor works fine but when i try to connect to informix via php i'get an error like Warning: ifx_connect(): E [SQLSTATE=S1 001 SQLCODE=-406] i have informix server 2000 installed

[PHP-DB] Re: PHP4.2.3 and Oracle 9.2

2004-01-16 Thread William Cheung
Sorry but I am not using Linux and Apache and also I didn't compile the source myself. My system is a Win2K server running IIS 4.0. I have just upgrade it to PHP 4.3.4 but it doesn't help. The test script has been used for Oracle 8i without problem. I have test the ODBC connection and also the

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Alban Médici (NetCentrex)
try this SELECT DISTINCT id-script FROM YOURTABLE where id_language = 'SELECTED LANGUAGE' ; no ? Justin Patrin wrote: Christine Clerc wrote: Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Christine Clerc
Well, I had tried this : SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; But then I have to do this with the selection : SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; but it cannot work since I get back the id_script from the first

Re: [PHP-DB] Re: L'utente Fabio Farinelli ha cambiato indirizzo di posta elettronica.

2004-01-16 Thread David T-G
Hi, all -- ...and then Justin Patrin said... % % Ignatius Reilly wrote: % % Somebody with admin rights to this list please castrate this Farinelli % user. % % +1 on that! for(;;++); :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] *

[PHP-DB] Unsubscribe User Fabio Farinelli - Headers Needed

2004-01-16 Thread Hutchins, Richard
PHP-List-Admin, Every time a user posts to the php-db list, the message below is automatically sent to the sender. This has been a problem for many months now and frequently sparks multiple requests from frustrated users to have [EMAIL PROTECTED] removed from the list. Can you please remove the

RE: [PHP-DB] Re: PHP4.2.3 and Oracle 9.2

2004-01-16 Thread William Cheung
I finally found out it is related to the permission of Oracle folder. After making Everyone to have full control to the folder, the ODBC connection works. William Cheung B.Sc, MCSE, MCDBA Databyte Corp. -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: January 15,

[PHP-DB] PHP 4.3.4, ADODB and Oracle9.2

2004-01-16 Thread William Cheung
Hi, I have a question if the following combination will work. Win 2K server IIS 4.0 PHP 4.3.4 ADODB 4.10 Oracle 9.2 I got the following error Warning: ociplogon():_oci_open_server: Error while trying to retrieve text for error ORA-12538 in

[PHP-DB] Re: Subject: MySQL general Question...

2004-01-16 Thread Neil Smth
There is no difference, in the way you wrote it. However, if you used wildcards you could match as follows : SELECT FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' // Match all addresses at hotmail.com SELECT FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' // Match all user names

[PHP-DB] Re: Unsubscribe User Fabio Farinelli - Headers Needed

2004-01-16 Thread Justin Patrin
Richard Hutchins wrote: PHP-List-Admin, Every time a user posts to the php-db list, the message below is automatically sent to the sender. This has been a problem for many months now and frequently sparks multiple requests from frustrated users to have [EMAIL PROTECTED] removed from the list.

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Martin Marques
Mensaje citado por Christine Clerc [EMAIL PROTECTED]: Well, I had tried this : SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; But then I have to do this with the selection : SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; but it cannot

Re: [PHP-DB] multi-language site

2004-01-16 Thread Martin Marques
Mensaje citado por Muhammed Mamedov [EMAIL PROTECTED]: Thank you for your comments Ignatius. (just to note) : I do not agree that all projects SHOULD require CLEAR sepeartion of code and appearance. Let me disagree with you! :-) I a multi-tiered design yuo have a client layer, a server layer