Auto Increment code not working

run2web

I have some code that is supposed to be taking the last highest number and adding 1 to it. Problem is, it isn't working correctly. It is separate from the Primary key because the Owner ID is up to 6 numbers.

Here is the code that I am using.

$result_ownerid = mysql_query("SELECT MAX(OwnerID)+1 AS newOwnerID FROM Owners",$connection) or die(mysql_error());
//echo $newOwnerID;  //for testing
;
$row = mysql_fetch_array($result_ownerid);
$newOwnerID = $row["newOwnerID"];

Then later in the code it is supposed to echo the next available number

<input name="OwnerID" type="text" class="blue" value="<?php echo $newOwnerID ?>" size="15" maxlength="12">

Any ideas why it isn't showing the next highest number?

TIA

tomhath

What is it doing?

Move the echo down to where it belongs and see what's going on:

$result_ownerid = mysql_query("SELECT MAX(OwnerID)+1 AS newOwnerID FROM Owners",$connection) or die(mysql_error());

$row = mysql_fetch_array($result_ownerid);

$newOwnerID = $row["newOwnerID"];

echo $newOwnerID;  //for testing

run2web

Originally posted by tomhath
What is it doing?

Showing 1 always, even if 1 is used.

RoadKingHD

When you first select the ownerid from MySQL, are you getting the result you expect when you echo $newOwnerID after the select? Is this the expected result value for newOwnerID?

When you call your <INPUT> statement, is this called from within a function or class? If you reference your var (newOwnerID) in a function, you need to pass the value to the function...not seeing all the code, I am just talking about what comes to mind.

Maybe upload the script as a text file.

run2web

Originally posted by RoadKingHD
When you first select the ownerid from MySQL, are you getting the result you expect when you echo $newOwnerID after the select? Is this the expected result value for newOwnerID?

No, it is not called from within a function or a class. You are seeing all of the code that is related to it.

I just looked in the database and I have it as a varchar. Could that be the problem?

RoadKingHD

Change the varchar column to int and see what happens.

run2web

That was it, I changed it in the DB to MEDIUMINT and it works fine now.

Thanks! 😃