accessing auto increment in database through code

[hemashiki]

hi all

i need a help
here,i want to increment an number in database through php code
without using auto increment key in database.it must be incremented automatically by inserting the values in front page..
can anyone help meeeee plz

[Atli]

You could query the database for the highest number in the column you want to increment and then manually increment that number before inserting the data.

[PHP]
/* -- Table structure --
CREATE TABLE Table (
idcol INT NOT NULL Primary Key,
data VARCHAR(255) NOT NULL
)
*/
$RES = mysql_query("SELECT MAX(idcol) as 'Max' FROM Table");

if(mysql_num_rows($RES) == 1) {
$ROW = mysql_fetch_assoc($RES);
$inc = $ROW['Max'] + 1;

$RES2 = mysql_query("INSERT INTO Table(idcol, data) VALUES($inc, 'mydata')";

if(!!$RES2) {
echo "Inserted";
}
else {
echo "Failed";
}
}

[/PHP]

Why don't you want to use Auto_increment tho?