PHP SQL数组没有返回任何内容

Question

Can I have some advice on where I'm going wrong with this Query?

 $entry_id = '1';
 $accident_road = $form_data[58]["id"]; //print_r returns "116"

        $accident_road_array = $wpdb->get_results(
          "SELECT id FROM wp_rg_lead_detail
           WHERE field_number = '$accident_road'
           AND 'lead_id' = '$entry_id' ",
           ARRAY_A); 


 print_r returns 'Array()'

Answer 1

I assume lead_id is a field in DB so you don't need quotes for it:

AND lead_id = '$entry_id'

You're also going wrong by putting variables directly into the query, you make your app vulnerable to SQL injections. consider using prepared statements.