Re: UPDATE

Quoting Steve Marquez <smarquez@marquez-design.com>: > I am trying to insert information into the database, have it automatically > place an ID Number, then update that particular record and replace the word > "delete" with the link. > > The "mysql_insert_id()" does seem to be working. It does put in an id number > of "0" However, the code in general gives me an error everytime. It says > that it is near 'delete = <a href...' > > $update_data = "UPDATE images_upload_description SET delete = <a > > href=\"http://www.domain.org/gallery/admin/delete.php?gallery_name=$gallery_ > name&id_num=$id_num\" target=\"bottom\">Delete</a> WHERE id_num = > \"$id_num\""; try to change the field name in your database from "delete" to something else and see if that helps. mysql may be complaining since delete is a reserved keyword. HTH -R'twick ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.