Databases
StackOverflow2013
Postsdbo
POWhy is this MySQL INSERT not working in CI?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy is this MySQL INSERT not working in CI?
    primarykey
    data
    text
    <p>For some reason this SQL statement is not working. Can anyone tell me why? (This is a Codeigniter site, if that matters)</p> <p>Here is my Model (where my error is pointing me to)</p> <pre><code>public function edit_profile($ID, $field, $new_info) { $sql = "UPDATE users SET ?=? WHERE id=?"; $query = $this-&gt;db-&gt;query($sql, array($field, $new_info, $ID)); // &lt;&lt;&lt;&lt; LINE 42 return $query; } </code></pre> <p>And this is the error I'm getting</p> <pre><code>Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''first_name'='oooo' WHERE id='151'' at line 1 UPDATE users SET 'first_name'='oooo' WHERE id='151' Filename: /Applications/MAMP/htdocs/MY_SITE/models/member_model.php Line Number: 42 </code></pre> <p>My table is called 'users', and I have a 'first_name' and 'id' column.</p> <p>Ideas?</p> <p><strong>EDIT</strong></p> <p>Just because it seems to come up a bit I want to clarify that the variables I am passing in here have NO QUOTES OR BACKTICKS. They are being added somewhere (and it seems like the ->query method, but I cant imagine that's true? .. dunno though, cause it's my first CI project)</p> <p>Here is the controller that is passing to the model...</p> <pre><code>public function profileEdit() { $ID = $this-&gt;the_user-&gt;id; $field = $this-&gt;input-&gt;post('edit_field') $field = strstr($field,'_edit', true); $new_info = $this-&gt;input-&gt;post('new_info'); $this-&gt;load-&gt;model('Member_model'); if( $this-&gt;Member_model-&gt;edit_profile( $ID, $field, $new_info )){ echo 'success'; } else { echo 'error'; } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USK.K. Smith
    1. USK.K. Smith
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhy is this MySQL INSERT not working in CI?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthe quotes around `first_name` is breaking your query
      singulars
      1. POWhy is this MySQL INSERT not working in CI?
      1. USJohn Conde
    2. CO@JohnConde I thought it might be a quote issue. But I'm not putting those there, the variables are being dynamically assigned and the quotes are getting added in the process. What is the better way to do what I want?
      singulars
      1. POWhy is this MySQL INSERT not working in CI?
      1. USK.K. Smith
    3. COAlso integers in MySQL sintax cannot be surrounded by quetes, (i.e. `WHERE id=151`)
      singulars
      1. POWhy is this MySQL INSERT not working in CI?
      1. USEpsil0neR
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload