Use an autonumber field in MySQL.  It will increment automatically every time 
you insert a record, and not repeat numbers. No extra PHP code needed. After 
the insert query, you can then issue a mysql_insert_id() function that will 
return the autonumber field for the last insert, that way you can know what 
it was (if you need that) Don't do it with PHP. 


On Monday 20 June 2005 09:54 am, [EMAIL PROTECTED] wrote:
> Hello,
> I have a site that allows reporters to enter their articles into a
> forum. I am then spilling their articles onto the main page from a
> MySQL dbase via a php script, read "LATEST ARTICLES".
> I am now entering the data myself after they email it to me, however
> this is becoming more of a task I dont' have time for as the number of
> articles increase per day.
> Right now, I have an addarticle.php page where they can enter their
> information. I have ran a test of this script, and it works great.
> However, I have been entering the PHP IDs myself in ascending order
> (i.e. 0005, 0006, 0007) because I can see all of the articles.
> The reporters however are not able to see these articles, and instead
> of having them enter a random php ID, I'd like my add script to check
> for the last ID entered and then enter the number above (i.e.... add
> row to table, check PHP ID, if 0007 is last row entered, enter 0008 for
> php ID for new article).
> Does anyone know how to add this particular command to a page, and if
> so, where?
> Thank you in advance.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to