PHP SQL Array not returning anything

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()'

Did you intend to name that first variable $accident_road_exp? That's what your query expects. — Michael Berkowski
– Michael Berkowski, Commented Jun 17, 2013 at 15:49
Yes, sorry that was an error on my part. see edited code above. — DrizzlyOwl
– DrizzlyOwl, Commented Jun 17, 2013 at 15:54

Headshota · Accepted Answer · 2013-06-17 15:55:59Z

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.

answered Jun 17, 2013 at 15:55

Headshota

21.4k13 gold badges63 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Irfan Younus · Accepted Answer · 2013-06-17 15:56:26Z

0

you set values in variable $accident_road while down there in query you used '$accident_road_exp' cross check this one man

answered Jun 17, 2013 at 15:56

Irfan Younus

1742 silver badges6 bronze badges

1 Comment

Irfan Younus Over a year ago

please correct 'lead_id' = '$entry_id' ", as lead_id = '$entry_id' ",

Collectives™ on Stack Overflow

PHP SQL Array not returning anything

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related