Re: UPDATE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Quoting Steve Marquez <smarquez@xxxxxxxxxxxxxxxxxx>:

> 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.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux