Re: [PHP-DB] Thanks for answer jjeffman, but...

Hi, Have you tried Interbase 6 ? It's possible that the module your working for was compiled with IB6's headers and libraries. Meir Kriheli MKsoft computer systems 'There's someone in my head but it's not me" - Pink Floyd - Original Message - From: "Kyoungsub, Wee" <[EMAIL PROTECTED]

[PHP-DB] select with parentID field into multidimensional array?

Hi I have a table which is set out like this ID name parentID I "select * from table" into $result. I then wish to walk through the result such that it creates a multidimensional array sorted with children under parents. Here is a basic eg. ID nameparentID 1 books 0 2 m

Re: [PHP-DB] select with parentID field into multidimensional array?

I am having most of my problems because I am trying to do this walking through the data a single time, with the assumption any records parentID has an ID less than the child and therefore would already be populated in the array... On Sun, 21 Jan 2001, Stephen wrote: > Date: Sun, 21 Jan 2001 23:

Re: [PHP-DB] select with parentID field into multidimensional array?

Hi, Maybe it would be better not to use a multidimentionnal array in a db. You should create to additionnal columns that stores the ParentID of the row. It's the easiest way to do it. Also you can create another table that would translate from numbers to text, or just put the text. Stephen w

Re: [PHP-DB] select with parentID field into multidimensional array?

Im not putting the array data back intoi the db, it is just to structure the data coming out of the db before i create a tree like structure with it on the page The data going into the db will always be a simple ID name parentID. Its the neatest way to do it I can think of including using the arra

[PHP-DB] Access & MS SQL idnetical thru ODBC ??

I have written a small program which uses ODBC to connect to a Access Database. I am simply wanting to know if this would also work with MS SQL without any modifications what so ever, or does ODBC not really accomplish what it was designed for ? The SQL statments used are very simple; the INSER

Re: [PHP-DB] Access & MS SQL idnetical thru ODBC ??

Siggy, It should work fine, as long as you use SQL92 syntax (or SQL89, depending on the ODBC driver). The only problem comes when you use SQL syntax that Access accepts that is not really valid in the SQL specification. I believe 'limit' is one example, but I'm sure someone will correct me if I

RE: [PHP-DB] Cookies on a Macintosh

No luck with that I'm afraid. The Mac IE still refuses to use the cookie. Cookies are on, it will use cookies on other sites, just not on the one I've created using PHP. I've tried making other cookies to test it, but still no go. There's no bugs in PHP3 with respect to making cookies are there

[PHP-DB] Message Boards

Hi all, Apologies if this is off-topic .. I am looking for a simple message/news board for a non-profit association(Surf Lifesaving Club in fact). I have tried Nope but cannot get it running and have had no response from posting to their install messageboard. i just want something that the

Re: [PHP-DB] Message Boards

http://www.phorum.org is a good way to go. On Mon, 22 Jan 2001, Steve Farmer wrote: |Date: Mon, 22 Jan 2001 14:00:15 +1100 |From: Steve Farmer <[EMAIL PROTECTED]> |To: [EMAIL PROTECTED] |Subject: [PHP-DB] Message Boards | |Hi all, | |Apologies if this is off-topic .. | |I am looking for a simpl

Re: [PHP-DB] select with parentID field into multidimensional array?

Well don't forget to use the order by and group by and where commands in SQL they could be quite useful in making a tree Stephen wrote: > > Im not putting the array data back intoi the db, it is just to structure > the data coming out of the db before i create a tree like structure with > it on

[PHP-DB] Error connect to SYBASE

Hi, While I try to connect to SYBASE server i recieve "Message from server is invalid" Where I can get description of retrieved error ? Thanks, wangjing