mySQL query error SELECT?

Question

I got this error when I'm trying a script.

mySQL query error: SELECT * FROM ibf_store_shopstock WHERE is_hidden='0' AND category=1 ORDER BY item_name ASC  LIMIT 0,

mySQL error: 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 '' at line 1
mySQL error code: 
Date: Monday 23rd 2012f July 2012 05:37:44 PM`

This is odd, since the very same script I tried on my localhost (MySQL 5.5.14) works just fine, but when I try it on live server (MySQL 5.1.63), it results in this error. I thought there's no big difference between the MySQL version?

Anyway here is a part of the suspected script (it's quite long): http://pastebin.com/YaQwVPqT

@zerkms: I'm not sure, it's from the PHP script. It's in here: pastebin.com/YaQwVPqT — deathlock
– deathlock, Commented Jul 23, 2012 at 10:57
well - it's your job, so make some research and show us the exact query that fails — zerkms
– zerkms, Commented Jul 23, 2012 at 10:58

Omesh · Accepted Answer · 2012-07-23 10:55:38Z

1

I think you are missing something after LIMIT clause "LIMIT start_record", "offset"

try

SELECT * 
FROM   ibf_store_shopstock 
WHERE is_hidden='0' AND 
      category=1 
ORDER BY item_name ASC  
LIMIT 0, 10;

answered Jul 23, 2012 at 10:55

Omesh

29.4k6 gold badges44 silver badges51 bronze badges

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

2 Comments

deathlock Over a year ago

Hmm... so what should I edit in the PHP script? If you don't mind to check it out here: pastebin.com/YaQwVPqT

deathlock Over a year ago

Wait, nevermind. I've found it. I indeed missed that something after the LIMIT clause. Thanks a lot!

Collectives™ on Stack Overflow

mySQL query error SELECT?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related