Increase value

I have a list of items in a table. One of the sells has a numeric value, itemNumber, it is not an incremental ID but somewhat similar.

Now I need to be able to detect what is the highest number in the itemNumber column and create itemNumber+1.

How do I go about that?

SELECT MAX(itemNumber) FROM table LIMIT1;

SELECT MAX(itemNumber) FROM table GROUP BY itemNumber

Paul 🙂

Just seen Thorpe's post ... hey, Thorpe ... isn't the 'GROUP BY' necessary when doing summary calculations?

Well, I just need just one value, so I assume I do not need to GROUP...

I'm getting the following output: Object

I expected the numeric value of the highest number

Show us your 'output' code ... otherwise we have to guess what you are trying.

Just checked out Thorpe's line and no, I didn't need the 'GROUP BY' at all !!

Paul 🙂

I got it.

I'm using a class and my final code looks like:

$highestNum = $db->get_var("SELECT MAX(itemNumber) FROM table");

well that doesnt help at all. what does the classes get_var() method return? can we see it?