Timeline for db_query not returning expected results - updated
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 4, 2012 at 17:09 | vote | accept | EmmyS | ||
| Jul 10, 2012 at 19:21 | answer | added | EmmyS | timeline score: 2 | |
| Jul 10, 2012 at 19:19 | comment | added | EmmyS | Thanks for the link. I inherited Drupal along with my current job, and I've never had time to really get through best practices - I'm just trying to keep my head above water learning what I need as I need it. | |
| Jul 10, 2012 at 19:00 | comment | added | avpaderno♦ | See Database abstraction layer, where it is stated that placeholders should not placed between quotation marks. What you have written as comment is the answer for your own question; you should write an answer, and accept it. | |
| Jul 10, 2012 at 18:41 | comment | added | EmmyS | I did figure out the issue; the placeholders should not be in quotes (in the query, not the args array.) An example I was working from showed them formatted in single quotes, so that's what I did. I just assumed somehow Drupal was replacing things, but if they're in single quotes they're being passed my mysql as literal strings and obviously there are no results that match. | |
| Jul 10, 2012 at 18:38 | history | edited | EmmyS | CC BY-SA 3.0 |
update to show issue is in where clause
|
| Jul 10, 2012 at 16:56 | answer | added | Bart | timeline score: 0 | |
| Jul 10, 2012 at 16:52 | history | asked | EmmyS | CC BY-SA 3.0 |