Re: [PHP-DB] 2 queries --> 1 array

2007-01-12 Thread tg-php
Ok, in your original message you said something about using the name as dominant key (or whatever you want to call it). All the SQL does is gather all the data together in an associated fashion. You can use the array you build to organize the data. I'm still not 100% sure what you're doing,

Re: [PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Frank M. Kromann
Hi Claudio, bugs.php.net would be the place to report the bug. As both the MSSQL and Sybase extensions are using the same FreeTDS library I would think the bug is in the Sybase extension. You will get more mssql_* functions with the MSSQL extension, and much better support for storred procedures

Re: [PHP-DB] 2 queries --> 1 array

2007-01-12 Thread Matthew Ferry
query1 = SELECT * FROM egw_addressbook query2 = SELECT contact_id, contact_value FROM egw_addressbook_extra WHERE contact_name='Supplier' query3 = SELECT contact_id, contact_value FROM egw_addressbook_extra WHERE contact_name='RANO' query4 = SELECT contact_id, contact_value FROM egw_addressbook_ex

Re: [PHP-DB] 2 queries --> 1 array

2007-01-12 Thread Matthew Ferry
yeah..that is what i'm trying to do, but I need to query WHERE contact_name='Supplier' and bring back the value for contact_value query WHERE contact_name='RANO' and bring back the value for contact_value query WHERE contact_name='Dynamic' and bring back the value for

Re: [PHP-DB] 2 queries --> 1 array

2007-01-12 Thread tg-php
Not sure if this is exactly what you're looking for, Matt, but I think it is. If that's not right, please re-describe the problem and let's see what we can figure out. If you have questions about what/how/why/etc... feel free to ask. -TG = = = Original message = = = Hello, I need to que

RE: [PHP-DB] Session Problem

2007-01-12 Thread Nur_Adman
I don't think that the problem is on the browser setting... Cause I've tried to browse the other web application (that using session too) on other server, and its running well... Forget to tell you, that if I used http://localhost , the session running well... But if I cha

Re: [PHP-DB] 2 queries --> 1 array

2007-01-12 Thread Matthew Ferry
I tried a buch of JOINs, but with no luck The problem comes in with I have to do a different query for each contact_name values for every record. SELECT contact_value FROM egw_addressbook_extra WHERE contact_name='Supplier' and contact_id=' 1' SELECT contact_value FROM egw_addressbook_extra WHE

Re: [PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Claudio Saavedra
Hi Frank, El vie, 12-01-2007 a las 10:49 -0800, Frank M. Kromann escribió: > 1) Check the version of FreeTDS on both systems. It proved irrelevant. See above. > 2) Check the freetds.conf file for differences (use the sam TDS version) No differences. > 3) Check that php is compiled using --wit

[PHP-DB] 2 queries --> 1 array

2007-01-12 Thread Matthew Ferry
Hello, I need to query two different tables and create one "BIG" array. I can query both tables, but can't find a way to combine the results in one array. The problem comes in with the second table. It has a weird layout. The second table only has four fields. They are: contact_id, contact_o

Re: [PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Frank M. Kromann
Hi Claudio, 1) Check the version of FreeTDS on both systems. 2) Check the freetds.conf file for differences (use the sam TDS version) 3) Check that php is compiled using --with-mssql on both systems (--with-sybase will give you aliases to some mssql_( functions but not all) - Frank > Hi all! >

[PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Claudio Saavedra
Hi all! I've stepped into an annoying problem when trying to fetch the tuples returned by a stored procedure in a MSSQL database from a PHP program running in a Centos Linux server running PHP 4.4.4. The stored procedure returns an arbitrary number of tuples, and my code is only working when

RE: [PHP-DB] Session Problem

2007-01-12 Thread Bastien Koert
are you sure that the problem is not in the browser settings (not to accept session cookies)? Bastien From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> CC: Subject: RE: [PHP-DB] Session Problem Date: Fri, 12 Jan 2007 15:34:06 +0900 1. Did you mean that on phpinfo(), the Session Suppo