Re: [PHP] UPDATE

[John Hicks]

Steve Marquez wrote:
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...'
Can anyone help me with this?
Thanks!
--
Steve
<?php    

   // log into our local server using the MySQL root user.
  $dbh = mysql_connect( "localhost", "username", "password" );
  // select the database.
  mysql_select_db( "imagesdb" ) or die ( mysql_error() . "\n" );
?>
<-- snip -->
<?php
   //This is for the text description of the gallery and the link
   $insert_data2 = "INSERT into images_upload_description (delete, name,
description)
   VALUES ('delete', '<a
href=\"http://www.domain.org/gallery/bomb/bottom_images.php?gallery_name=$ga
llery_name\" target=\"bottom\">$name</a>', '$description');";
   $response = mysql_query( $insert_data2, $dbh );
   $id_num = mysql_insert_id();
   $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\"";
       
       $response = mysql_query( $update_data, $dbh );
   if(mysql_error()) die ('database error'. mysql_error());
   
   ?>
 

You forgot to put single quotes around the string that begins  '<a href= 
... ' in the line beginning:

$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\"";
-John
   

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