Hello!
Sorry, I forgot to write it when I simplified the code. In the real code I wrote
If ($result = maxdb_query($db_connection, $sql)) {
/*....*/
}
resulting in the mentioned error. Seems I can't use maxdb_query in a recursive
function ?? ... it worked when I used ODBC driver.
Bye
Claus
> Hi,
>
> For working on a result set with maxdb_fetch_assoc() you have to
> retrieve the result set with maxdb_query() first.
> The right way to write the if condition is
>
> If ($result = maxdb_query($db_connection, $sql)) {
> /* ... */
> }
>
> Regards,
>
> Thomas Simenec
> SAP Labs Berlin
>
> -----Original Message-----
> From: Claus Windeler [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 9. Februar 2005 13:01
> To: [email protected]
> Subject: PHP problem mith maxdb_query() and maxdb_real_query()
>
>
>
> I have a recursive function to process data which is organized in a
> tree. The
> data is stored in a database.
>
> I am using PHP 5 with MaxDB-Module 1.0
>
> First I tried the following version of my function
>
> function process_data($leaf) {
>
> $sql = 'SELECT id, data FROM datatree WHERE parent='.$leaf;
>
> if (maxdb_query($db_connection, $sql)) {
>
> while ($row = maxdb_fetch_assoc($result)) {
>
> use_data($row['DATA']);
>
> // check if childs should be processed. Not always true.
> if (process_childs($row['ID'])) process_data($row['ID']);
>
> }
>
> maxdb_free_result($result);
>
> }
>
> }
>
> This results in an maxdb_query error when function is called the second
> time
> during recursion:
>
> function.maxdb-query: Commands out of sync. You can't use this command
> now.
>
>
> I modified the function to use maxdb_real_query():
>
> function process_data($leaf) {
>
> $sql = 'SELECT id, data FROM datatree WHERE parent='.$leaf;
>
> if (maxdb_real_query($db_connection, $sql)) {
>
> $result = maxdb_store_result($db_connection);
>
> while ($row = maxdb_fetch_assoc($result)) {
>
> use_data($row['DATA']);
>
> if (process_childs($row['ID'])) process_data($row['ID']);
>
> }
>
> maxdb_free_result($result);
>
> }
>
> }
>
> When I execute it my Apache-Webserver hangs an I have to restart it.
>
> Can someone show me the right way to implement the function or point me
> to my
> mistake ??
>
> Bye
> Claus Windeler
>
>
> -------------------------------------------------
> This mail sent through IMP: http://horde.org/imp/
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
