Guriddo » Topic: Error editing & displaying data

Error editing & displaying data

Guriddo
Error editing & displaying data

This topic has 2 replies, 2 voices, and was last updated 14 years, 6 months ago by cheech74.

Creator

Topic

January 9, 2012 at 3:09 am #79491

Participant

I have managed to create a basic grid, but i am now getting this error when trying to make the new data in editable cells save to the database – also the data is not being displayed in the grid anymore

Couldn t execute query.You have an error in your SQL syntax; check the manual that corresponds to your</code><code> MySQL server version for the right syntax to use near &#39;-10 , 10&#39; at line 1

1	Couldn t execute query.You have an error in your SQL syntax; check the manual that corresponds to your</code><code> MySQL server version for the right syntax to use near '-10 , 10' at line 1

Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies
January 9, 2012 at 2:36 pm #99324

BioFox
Participant

Take a second look at your SQL query, the error says it all.
You are not allowed to have a LIMIT with a negative number, which is your case.
You start with LIMIT -10, 10, instead of LIMIT 0,10.

January 15, 2012 at 4:45 am #99346

cheech74
Participant

right thanks – I'm slowly getting there.

However I cant get the data to save to the database – I know its probably something really simple, but coding is not really my thing – just trying to help out a friend. Here is my latest html. I seem to be going round in cicrcles when i google…

many thanks

<html xmlns="http://www.w3.org/1999/xhtml” xml:lang=”en” lang=”en”>

Oneline Surveys Weekend Call-Out Rota
Author

Replies