7 replies to this topic

[Hamed]

I have simple code which should edit list of records

    if($_GET['submit'] == 'list')
    {
        $lid = $_GET['lid'];
        $group = $_GET['group'];
        //print_r($_POST);
        foreach($_POST as $vname => $value)
        {
          //$value = $db->escapeString($value);
          $db->readQuery("UPDATE `langvars` SET `langText` = '$value' WHERE `langVar` ='$vname' AND `langID` ='$lid' AND `langGroup` = '$group';");
        }
        Func::showMsg($Lang->getVar('lang.varsedited'),'./lang.php',4);
    }

$db->readQuery("UPDATE `langvars` SET `langText` = '$value' WHERE `langVar` ='$vname' AND `langID` ='$lid' AND `langGroup` = '$group';");
doesn't work for me and I don''t know why!!

[DEViANT]

Theres a semicolon in your SQL query... This might cause problems?

Quote

$db->readQuery("AND `langGroup` = '$group';");

[plb]

No, query is correct. Check the spelling of table names.

[Orjan]

php's built in functions for MySQL doesn't allow ending semicolon on sql queries, so I agree with DEViANT, remove it and it should work.

[Hamed]

This query generated by phpMyAdmin
With ; or without ; doesn't work for me.

[Alexander]

"doesn't work" doesn't help. Try to provide us an error (check your documentation on how to retrieve it), it could be an error at any number of steps. As said before most DB engines cannot cache multiple results, strip the semicolon (PHPMyAdmin does not know what you are using, it only provides a query)

[Hamed]

I user or die(mysql_error());
But I don't get any error!

[Alexander]

Hamed said:

I user or die(mysql_error());
But I don't get any error!

You should always check if mysql_affected_rows() will return anything greater than zero, to see if the query actually did anything. You should know what debugging steps can be taken for each action in PHP, this is great knowledge when writing an application.