Hi,

I'm currently developing a database on my site and I ran into a little bit of a problem. Actually its more of I'm trying to make something more convienient. The database is a list of all the movies that I own and I want to make it so that the field "mplayernum" automatically gets it's number by using the field "mdiscnum" from the previous entry and adds 1. I'm not sure how easy this is, but if anyone can help it would be greatly appriciated.

Thanks,

FallenRayne

you need to select the mdiscnum and instead of looping around all the results just call fetch_row (mysql's eqiuv).

so instead of calling

while ($row = mysql_fetch_row())){

}

just call $row = mysql_fetch_row()

$id = $row['mdiscnum']

this then return the last row in the table and hey presto you have your last mdiscnum.

Now simply update your new entry

update TABLE set mplayernum = $row['mdiscnum'] +1;

You could also make the mplayernum 'auto increment' so that you just keep adding 1 to it anyway.

Ibbo

Thanks for the quick reply on that. I will try it and see how it works. Still new to PHP so it will probably take me a bit to figure this one out

FallenRayne