try using
// set up query
$sql = "UPDATE thistable
SET FNAME = \"$esc_fname\", LNAME = \"$esc_lname\", EMAIL
= \"$esc_email\", WEB = \"$esc_web\"
WHERE ID = \"$id\"
";
variables aren't expanded inside ' so you need to use "
Paul Roberts
[EMAIL PROTECTED]
++++++++++++++++++++++++
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 4:47 PM
Subject: [PHP] Modifying a record works but not in actual database?
> 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:
>
> <?php
>
> // 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();
> exit;
> }
>
> // close connection
> mysql_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
> wrong?
>
> Thanks!
>
> Laurie Landry
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
