Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
sult); // there are some things that might be said about query result sets being // retained in memory, but I don't think there's any need to go there // try changing to mssql_connect() // write a single left join query, // clean up the ambiguities in re handle vars // use a single mssql_

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
at the .inc files that do the actual queries ... > I've attached the two related php files that deal with the process, I > can't see anything too horrible (other than my coding style) :-) ooops ... files attached only reiterate the problem and do not serve to further illuminate

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
ow the db.table.field in question is a column type meant to hold the data you expect? You seem to be indicating a consistent return of 255 when you ask for 400 - seems to be a clue about the field specification. More data::better answers. Pan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Question about PHP Arrays syntax

2002-04-21 Thread pan
From: "Vania Smrkovski" <[EMAIL PROTECTED]> > host with PHP and MySQL support. > > a) How would you change the following the automatically find the tables and > run through the iteration. You should rtfm as php/mysql makes a lot of the torturous VB/MS/Access methods very simple. All the function

[PHP-DB] about create index in interbase

2001-05-12 Thread Pan Gang
I create a table in PHP and next to create the index for it . But the create index statment can't work in PHP. It can work in ISQL . It's a bug in PHP? The program like that: $sql = "CREATE TABLE $table_name (id integer ,name char(20))"; $ibase_query($conn,$sql); $sql = "CREATE INDE