SQL issue?

john1704

Hello,

I'm having a problem with my SQL statement. It appears that I cannot insert data into a field in a MySQL database. Here's my code:

mysql_query("UPDATE sometable SET somefield = '$text' WHERE somenumber = '$num'");

Now in this example, somefield has a data type of longtext. However, when I go to update it, the PHP script won't insert the characters in the variable $text. There are no errors, but it's weird because it won't insert anything.

Is it something with the UPDATE statement and the longtext data type, or is there something wrong with my script?

Thanks.

NogDog

Are you sure the WHERE clause is working correctly? If it's not matching as expected, then nothing would get updated. You might want to try the following pattern:

$sql = "UPDATE sometable SET somefield = '$text' WHERE somenumber = '$num'";
$result = mysql_query($sql);
if(!$result)
{
   user_error("Update failed: " . mysql_error() . "<br />\n$sql");
}
elseif(mysql_affected_rows() == 0)
{
   user_error("No rows updated by query: $sql");
}

This should give you some potentially useful debug info to help determine what is happening. Note that you may need to add one or both of the following lines to see the errors, depending on you default configuration:

ini_set('display_errors', 1);
error_reporting(E_ALL);

peytonrm

If somenumber is an integer type column the value you are trying to match should not be in quotes. Other than that, I would just var_dump the variables you are using in the query to make sure they match what you're expecting.