[resolved] WPDB get row problem (2 posts)

  1. digico
    Posted 2 years ago #

    Using the following code:

    $sql = "SELECT * FROM" . $aDatabaseSettings['table'] . "WHEREorder_id= '" . $iBookingId . "' ORDER BYid` DESC LIMIT 1;";
    $aRecord = $wpdb->get_row($sql,ARRAY_A);

    if( is_array($aRecord)) error_log("YES I AM AN ARRAY");
    else error_log("NONONO".gettype($aRecord));

    error_log("aRecord sql: ".$sql);
    error_log(print_r($aRecord, true)."MEER".$aRecord['transaction_id']);`

    As you can see I am trying to debug already. The thing is that the sql var returns a query which works perfectly when executing in phpmyadmin. So although this query is correct the get_row returns NULL. Also added global wpdb; before this code.

    I am searching like crazy but can't seem to find the problem.

    Probably simple and stupid problem but need someone who can send me into the right direction to solve this.

    Hoping on some advice.

  2. digico
    Posted 2 years ago #

    Problem solved. Caused by bug in code...at moment of executing the code transaction_id was not available yet. However after the full action it was, which was the reason the sql did execute correctly when trying in phpMyAdmin.

Topic Closed

This topic has been closed to new replies.

About this Topic