Support » Plugins » WPDB get row problem

  • Resolved digico


    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.

Viewing 1 replies (of 1 total)
  • 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.

Viewing 1 replies (of 1 total)
  • The topic ‘WPDB get row problem’ is closed to new replies.