Function does not exist

[jordanwb]

This is the query I'm trying to run:

 

INSERT INTO `paul_pages` VALUES ('', 'page title', '<p>page content</p>', 0 , 0, MAX (`page_order`) + 1)

 

What I'm trying to do in the last column is take a highest value in page_order (which is an integer), and add 1. So if there are three pages, page order would 1, 2 and 3, the new page's page_order would be 4. But when I run this query I get this error:

 

MySQL error: FUNCTION paul_pepin.MAX does not exist

[gwydionwaters]

why not set page order to a primary key and then to auto_increment and skip entering in the number, mysql will add one to the last for you

[jordanwb]

I already have a field set as Primary key and its set to Auto Increment.

[fenway]

You could try:

 

INSERT INTO `paul_pages` SELECT '', 'page title', '<p>page content</p>', 0 , 0, MAX (`page_order`) + 1 FROM `paul_pages`

 

Though I would recommend a column list.