In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > hi guys, > i wanna make a news letter as follows: > i sell items within certain categories,so whenever a buyer is registered he choose >some categories to contribute to my newsletter with: > whenever a new item is added within this category i send him an email with that. > > i'm storing the mails in database. > > does anyone have something like this that can help me?? > > i tried in my script that whenever an item is added i send aletter to all who is >subscribed under this category,but i need to know the ID of this item that is added >first,so i faild to do that
If you are using mysql, and have a table with an autoincrement key, you can use mysql_insert_id immediately after an INSERT to get the value of the last inserted id. -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php