Timeline for Custom query on custom table fails
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 21, 2015 at 13:14 | answer | added | DevelopmentBucket | timeline score: 0 | |
| Feb 21, 2015 at 11:43 | comment | added | kuldip Makadiya | Yes Exactly ... So don't remember to give points in right Answer. | |
| Feb 21, 2015 at 11:42 | comment | added | Colin | Thanks that works now. I think I will add single quotes to one of the other variables too as that may contain letters too. | |
| Feb 21, 2015 at 11:27 | comment | added | kuldip Makadiya |
on volume pass single quote in parameter. Now your query is SELECT * FROM cp WHERE year = '1911' AND quarter = '4' AND volume = '2a' AND page <= '1475' ORDER BY page DESC LIMIT 1 Try this code
|
|
| Feb 21, 2015 at 11:17 | history | asked | Colin | CC BY-SA 3.0 |