WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WPDB get row problem (2 posts)

  1. digico
    Member
    Posted 11 months 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
    Member
    Posted 11 months 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.

Reply

You must log in to post.

About this Topic