I'm trying to set up a "modify record" page, and after testing and triple-checking
the syntax and form, and even running the query in the phpMyAdmin interface
to make sure the query is correct.

This is just a snippet of what I've done:


// open connection
include ("connectdatabase.inc");

// format names to protects the O'Haras etc.
$esc_fname = addslashes($fname);
$esc_lname = addslashes($lname);
$esc_email = addslashes($email);
$esc_web = addslashes($web);

// set up query 
$sql = 'UPDATE thistable
                SET FNAME = "$esc_fname", LNAME = "$esc_lname", EMAIL
= "$esc_email", WEB = "$esc_web"
                WHERE ID = "$id"';

// perform query
$sql_result = mysql_query($sql);
if (!$sql_result) {
   echo "Can't execute $sql " . mysql_error();

// close connection

The problem? On the PHP front (my "mofidy record" page) says it's performed
without a problem. However, if I were to do a "view all records" - I
can see that none of the changes has actually been made to the database.

Adding a record is not a problem; nor is deleting a record.

Can someone point me into the right direction as to what I might be doing


Laurie Landry

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

Reply via email to