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: php-db@lists.php.net Subject: RE: [PHP-DB] Session Problem Date: Fri, 12 Jan 2007 15:34:06 +0900 1. Did you mean that on phpinfo(),

[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

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] 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,

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

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

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 http://localhost/ , the session running well... But if I

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. ?php $query = SELECT t1.NAME, t1.BUSINESS, t1.ADDRESS, t1.CITY, t1.PHONE, t2.CONTACT_NAME, t2.CONTACT_VALUE FROM Table1 as t1, Table2 as t2 WHERE t1.ID = t2.CONTACT_ID $result = mysql_query($query); while ($row =

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

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

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 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,