Re: [PHP-DB] Access db

2003-11-21 Thread Luke van Blerk
Thanks Michael. I'll check it out ;) - Luke Michael Mauch [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Luke Van Blerk wrote: I'll probably just extract the data with an access to mysql script and run it on mysql. This is probably the best approach if you have access to

[PHP-DB] Re: Subject: Strange bahavior with mysql_fetch_array($result)

2003-11-21 Thread Neil Smth
If $result is returning a resource ID, this is because you have also used $result in the mysql_connect call. You have probably also turned off error_reporting in your script, as it should throw an error for the 'if (! mysql_fetch_array...' line. The correct check is 'if (mysql_num_rows()==0)'

[PHP-DB] debugging / help required urgently.

2003-11-21 Thread JeRRy
Hi, I have a MAJOR problem with PHP mail() function, one that is odd and very frustrating as I have no idea what is causing it. I have used the one script to send emails out in the past and they have been sucessfully sent out, but as of a few days ago and now they are bouncing, some are actually

[PHP-DB] Re: debugging / help required urgently.

2003-11-21 Thread Kim Steinhaug
Not exactly your answer, but I remember having same problems one time. I switched and started using phpmailer, http://phpmailer.sourceforge.net/ This has in the past never given me problems, 1 time I had problems on the server using the php functions, but phpmailer even has SMTP support. Just

RE: [PHP-DB] Unsure of how to perform query and results..

2003-11-21 Thread Aaron Wolski
Hi John, Thanks for taking the time to respond. What am I trying to do? Well...I am trying to build a mailing list of previous customers WHO purchased product_id 1 but not product_id 14. I have the product items (id's) stored in the CartTable and I have customer info stored in the OrderTable.

Re: [PHP-DB] nested sets?

2003-11-21 Thread Cal Evans
Chapter 28 (or 29) in Joe Celko's SQL for Smarites. The chapter on nested sets alone is worth the price of the book. At the very end of the chapter (after taking you through the details of a nested set) he gives a very simple and easy to implement solution for nested sets. Let me know how I

Re: [PHP-DB] nested sets?

2003-11-21 Thread ma
hi! thx for the answer! in fact i'm just searching for a query to desend a defined path in the structure, but left others alone. e.g. path: about/company structure: about company history today employees intern extern products ... should end in about

[PHP-DB] Informix function

2003-11-21 Thread Juan Ringhetti
Hi, I have a problem with PHP ifx_num_rows function. Once is executed after a ifx_query function it always returns 0 value (even the ifx_query return a couple of rows). I know that is a PHP bug (I have a php4.1.1 version), but, how can I do to solve this bug in a standard way? Without use select

[PHP-DB] Re: nested sets?

2003-11-21 Thread Manuel Lemos
Hello, On 11/20/2003 12:28 PM, Ma wrote: i try to make a clickable menu. it should be outputed as XML. i found a solution to make it possible to decend only the selected menues. but is there a easier solution? my goal is to first show only the first (level=0) level. if the user clicks on the menu

[PHP-DB] Re: php apache freetds install difficulty

2003-11-21 Thread [EMAIL PROTECTED]
Wes Forster wrote: snip If I compile and install php without the freetds sybase support it all works fine. Its just when I introduce those variables that I run into trouble. /snip Wes, unfortunately I don't have an answer on your Apache problem because I'm still new at this too. I didn't think

[PHP-DB] How To Recompile For FreeTDS + MS SQL Support?

2003-11-21 Thread [EMAIL PROTECTED]
I have RedHat 9 and FreeTDS. I used tsql to test FreeTDS and it works great, connecting to my remote SQL 6.5, 7, and 2K servers, accessing pubs.authors. Now I want to connect PHP to it. I seem to be doing something wrong. RH9 ships with 4.2.2, so I went hunting for the file and got

[PHP-DB] Re: MSSQL, PHP, Linux, and FreeTDS???

2003-11-21 Thread [EMAIL PROTECTED]
Tim Nields wrote: Can someone please give me any kind of advice on what it is I need to do in order to configure a Linux box to talk to a MSSQL 2000 box. I have found various sets of directions, none of which resemble each other, and none of which work. I would greatly appreciate if any one could

Re: [PHP-DB] How To Recompile For FreeTDS + MS SQL Support?

2003-11-21 Thread Frank M. Kromann
Hi, When you have the PHP sources extracted from the tar-ball you can use configure --with-mssql,shared make Then you can copy the mssql.so file to your current php installations extension dir and either load the extension form php.ini or with the dl() function. This way tou don't have to