[PHP-DB] Interbase: How to get table structure via SQL ?

2004-02-18 Thread DiZEM PGC
Hi, does anyone know how to get the Structure of a table using SQL. (ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM RDB$RELATIONS) Isn't there any table containing the CREATE STATEMENT for a table? Maybe I have to use another command? Please help ! Thx, DiZEM -- GMX ProMail (250 MB

[PHP-DB] Interbase: How to get table structure via SQL ?

2004-02-18 Thread DiZEM PGC
Hi, ...table structure without PEAR ? Is it possible to accomplish this by a sql-statement or do I really HAVE TO install this xtension (PEAR) ? Cuz I've already written a few scripts containing many function calls (self written classes, too). I read the PEAR extension organizes everything

[PHP-DB] mysql_connect problem

2004-02-02 Thread DiZEM PGC
I try connecting to an existing mysql DB. The first time I directly called mysql_connect with all required params (Path/Database,User,Password) and established a connection without problems. Second time I have used a script that includes a self-written class containing a few Database functions.

[PHP-DB] PHP crashes...

2004-01-22 Thread DiZEM PGC
Here is the source until something is returned by the first function call (first from top to bottom): ? session_start(); // Template-class require('template.inc.php'); // Some DB-Data [EMAIL PROTECTED] getenv(DOCUMENT_ROOT)./conn.con; if ($dbconn!=1) { sprintf(%s,$dbconn); exit(); } //

[PHP-DB] PHP crashes...

2004-01-21 Thread DiZEM PGC
I have a script called 'login.php' which worked fine until now. Last dayz i've made a few changes at this script which ones just dealt with if-expressions. I've set some vars to values returned by functions and checked (if) these values afterwards. Now the execution of this script results in a

[PHP-DB] ...request synchronization error...

2003-12-17 Thread DiZEM PGC
Hi , Does anyone know what could be the reason for an 'request synchronization error' ? It occurs after calling ibase_fetch_assoc(). The same thing going on with ibase_fetch_object() and ibase_fetch_row(). The resultset is being delivered correctly by ibase_query(). The SQL-String (SELECT)

[PHP-DB] ibase_fetch_* = request sync. error

2003-12-16 Thread DiZEM PGC
Hi ! Habe folgendes Problem : Jeder Aufruf der Funktion ibase_fetch_assoc() resultiert in dem Fehler Request Synchronization Error. Ich habe es auch schon mit der anderen Variante ibase_fetch_object() probiert. Die lieferte die gleiche Fehlermeldung. Die Skripte laufen lokal auf einem APACHE HTTP