$stmt = $db->prepare('SELECT postID, postTitle, postSlug, postDesc, postDate FROM blog_posts WHERE postDate >= :from AND postDate <= :to ORDER BY postID DESC'.$pages->get_limit());
is there something wrong with my query?
RonKevinT.Manuela 0 Junior Poster in Training
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Can you post the full error message? The title is cut off.
pzuurveen 90 Posting Whiz in Training
edit: nevermind
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
BTW, I now see that there is no space between DESC and your limit value. Fix that. Not sure what limit returns, but that appears the cause of your issue.
RonKevinT.Manuela 0 Junior Poster in Training
oh.sorry..its like this sir
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESCLIMIT 0,5' at line 1...
RonKevinT.Manuela 0 Junior Poster in Training
should i post the whole code?
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
No. Like I said. There should be a space between DESC and LIMIT.
RonKevinT.Manuela commented: damn space...:3 thanks alot sir +0
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.