Unknown column 'tr' in where clause

Question

I have this MySQL query, which is failing every time:

update exp_companies set company = 'Some Intermodal Container Company', auth_user = 'Some User', c_code = 'SICC', contact = 'Somes Boss', ph = '012-555-1234' where uid = 3

The error I get is:

mySQL Error 1054: Unknown column 'tr' in 'where clause'

I have never encountered this before. I have expressed this query many ways, omitting parts, etc. But nowhere in the query there is column 'tr', mentioned in error, yet it fails.

if($opi == "exp_commit") {

   $dbi = sql_connect($dbhost, $dbuname, $dbpass, $mydb);

   $query = "select * from wmd_companies where uid = $new_scac";

   $result = sql_query($query, $dbi);

    if(!$result) { mydb_error($dbi, $query); }
      $scac_row = mysql_fetch_row($result);
      $scac_company = $scac_row[1];  
      $scac_code = $scac_row[2];   
      $scac_contact = $scac_row[3];
      $scac_ph = $scac_row[4];
      $scac_email = $scac_row[5];

      $exp_query = "update exp_companies set company = '$scac_company', auth_user = '$dr_name', c_code = '$scac_code', contact = '$scac_contact', ph = '$scac_ph', company_email = '$scac_email' where uid = $exp_id"; 

   $result = sql_query($exp_query, $dbi);


  if (!$result) { mydb_error($dbi, $exp_query); }
     echo "Success! <meta http-equiv=refresh content=\"2;      URL=admin.php?opi=admin&what=list\"> $b";

  }

So you hardcode all your queries? or are you hiding the fact that your not using prepared or escaped queries, and its simply a SQL injection problem? — Lawrence Cherone
– Lawrence Cherone, Commented Sep 9, 2017 at 15:10
Is this the complete sql query or something more is missing in question? What is the error when you try to execute via sql editors/developer tools? — Rizwan
– Rizwan, Commented Sep 9, 2017 at 15:12
here is the complete (novice level) code block ... I might add several other similary blocks parse correctly: — Mortifis
– Mortifis, Commented Sep 9, 2017 at 15:17
No my queries are not hard code. I just showed the error reported the query is: "update exp_companies set company = '$scac_company', auth_user = '$dr_name', c_code = '$scac_code', contact = '$scac_contact', ph = '$scac_ph', company_email = '$scac_email' where uid = $exp_id"; — Mortifis
– Mortifis, Commented Sep 9, 2017 at 15:28
add column one by one in update query with where clause.. so that you sure what the issue is coming from. Is that coming from query or column issue.. — ROHIT CHAUHAN
– ROHIT CHAUHAN, Commented Sep 9, 2017 at 15:48

Dharman · Accepted Answer · 2021-02-10 05:49:47Z

0

use '$new_scac' use the string to fix it.

edited Feb 10, 2021 at 5:49

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

answered Feb 10, 2021 at 5:44

Iftekhstudio

172 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ran Marciano Over a year ago

Welcome to Stack Overflow. Please read How to Answer. stackoverflow.com/questions/how-to-answer

Collectives™ on Stack Overflow

Unknown column 'tr' in where clause

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related