Return to Answer

added 8 characters in body

Source Link

edited Feb 21, 2015 at 15:08

50.8k
27
150
244

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

SELECT * FROM cp WHERE year = '1911' AND quarter = '4' AND volume = '2a' AND page <= '1475' ORDER BY page DESC LIMIT 1   Try this code

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

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

Source Link

created Feb 21, 2015 at 13:14

DevelopmentBucket

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