[PHP-DB] spell checking and "did you mean?"

2006-03-23 Thread peter lovatt
Hi All I am looking to check whether a keyword a user has entered already exists in the database I can find exact matches, but I am having trouble with typos. I am looking for something like Google's "did you mean" if you type in a close match. SO if someone types in saet it returns "did you me

Re: [PHP-DB] PHP + OCI en Debian

2006-03-23 Thread SJL
I was surfing in the web, and I found this: http://www.akadia.com/services/ora_php_linux.html Describe how to recompile php with oci8 librarys, in apache2 under Linux or Solaris. May be it will be usefull for someone else. Thanks anyway, Sebastian On 3/23/06, SJL <[EMAIL PROTECTED]> wrote: >

[PHP-DB] Re: Weird ORDER BY problem with PHP an MS ACCESS

2006-03-23 Thread Constantin Wolber
Constantin Wolber wrote: SELECT table1.col1, table1.col2, table2.col1, table3.col1, table3.col2 FROM (table1 LEFT OUTER JOIN table2 ON table1.fkcol=table2.idcol) LEFT OUTER JOIN table3 ON table1.fkcol2=table3.idcol WHERE table2.idcol=id ORDER BY table2.col1,table1.col2 Th

[PHP-DB] Weird ORDER BY problem with PHP an MS ACCESS

2006-03-23 Thread Constantin Wolber
Hi, I searched quite a while for a solution but I just don't find one. I use: - MS ACCESS as the database (I know there are better solutions but I have to use MS ACCESS 2002) - PHP Version 5.0.5 - Windows 2000 - Apache/2.0.54 I've got the following query: SELECT table1.col1, table1.c

Re: [PHP-DB] PHP + OCI en Debian

2006-03-23 Thread SJL
Ok, I think that you say to me that´s is not possible to compile oci8.c separate... When you say "compile with extra option --with-oci8", you mean something like: make --with-oci8 makefile? Sorry for the ignorance... Thanks again, Sebastian On 3/22/06, Chris <[EMAIL PROTECTED]> wrote: > SJL w

Re: [PHP-DB] PHP + OCI en Debian

2006-03-23 Thread chris smith
On 3/24/06, SJL <[EMAIL PROTECTED]> wrote: > It´s true. I find the sources of oci8.so. > > But in my first try to compile it, It failed because the it have calls > to php.h and info.h, so I try to move the sources files to the path > where I have this files (taking care with the relative path in th

Re: [PHP-DB] PHP + OCI en Debian

2006-03-23 Thread SJL
It´s true. I find the sources of oci8.so. But in my first try to compile it, It failed because the it have calls to php.h and info.h, so I try to move the sources files to the path where I have this files (taking care with the relative path in the source code), but it fail again with more than 100

[PHP-DB] Re: MySQL Query Help

2006-03-23 Thread João Cândido de Souza Neto
Mark Dyer wrote: > > Hello, I'm unsure how to write the follow query, Please can someone > assist. > > I am writing in short hand the basis of the two queries I would like to > combine. The object is to select all the products that have not meet the > min sale requirements so I can send myself a

[PHP-DB] MySQL Query Help

2006-03-23 Thread Mark Dyer
Hello, I'm unsure how to write the follow query, Please can someone assist. I am writing in short hand the basis of the two queries I would like to combine. The object is to select all the products that have not meet the min sale requirements so I can send myself a reminder email. The first tabl

[PHP-DB] Re: Return values from mysql_query

2006-03-23 Thread João Cândido de Souza Neto
David Killen wrote: > I'm just beginning with PHP and came across something which is > frustrating me no end. I have a really simple script which given a > username will query the database and if it doesn't find a match will > then insert into the database. The problem I find is that even when > t

[PHP-DB] Return values from mysql_query

2006-03-23 Thread David Killen
I'm just beginning with PHP and came across something which is frustrating me no end. I have a really simple script which given a username will query the database and if it doesn't find a match will then insert into the database. The problem I find is that even when there is no data in the database