Re: newsletter

In article <200204180701.g3I71ne08092@mail4.bigmailbox.com>, fotna@egypt.net 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