Re: [PHP-DB] Re: Multi search function (help)

2004-05-27 Thread nabil
yes, this is true, we should add empty() function too. Ross Honniball [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm not 100% sure, but you may want to also check if the field is empty (using empty() function) before including in your search. (in addition to isset) Also, just

[PHP-DB] Re: Informix and PHP

2004-05-27 Thread D. Sandmann
Thought I would post how I finally resolved this problem since it is not specific to Informix. The problem had nothing to do with the setup of my environment. It boiled down to my registries where corrupt. Found many entries in my registry that had the paths to various files starting with c?\Some

[PHP-DB] postgresql field size information

2004-05-27 Thread Scot L. Harris
I need to get the size of the fields defined in a postgresql table for use in my PHP script. For instance: $fieldname = pg_field_name($stat,$i); $size = pg_field_size($stat,$i); $type = pg_field_type($stat,$i); I tried using pg_field_size but for char type fields it returns a -1 indicating the

Re: [PHP-DB] postgresql field size information

2004-05-27 Thread Cornelia Boenigk
Hi Try select attname, format_type(atttypid, atttypmod), col_description(attrelid, attnum) from pg_attribute, pg_class c where c.oid = attrelid and attnum 0 and c.relname = 'tablename' ; Regards Conni -- Datenbanklösungen + PostgreSQL + Webdesign http://www.cornelia-boenigk.de |