CodeIgniter not correctly performing a sql query [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed last year.

Improve this question

In Ci I'm getting the following error:

A Database Error Occurred

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 '', '1f37540fc54292b018a9e993da38cb5647dc5587', NOW(), '0')' at line 1

INSERT INTO users (userpid, Email, Password, dateTimeRegistered, isLeader) VALUES ('147344f0e33367f9e6', erf', '1f37540fc54292b018a9e993da38cb5647dc5587', NOW(), '0')

Filename: C:\Workspace\htdocs\Misc-2\DruvlaCi-1\system\database\DB_driver.php

Line Number: 330

But everything seems to be right in the SQL query. Below is my query, any thoughts?

$query = $this->db->query("INSERT IGNORE INTO users (userpid, Email, Password, dateTimeRegistered, isLeader) VALUES ('{$idgen}', {$postedEmail}', '{$hashedPass}', NOW(), '0')");

Fad · Accepted Answer · 2012-01-12 13:20:08Z

3

You're forgetting the opening single quote for the email column

Try this instead

$query = $this->db->query("INSERT IGNORE INTO users (userpid, Email, Password, dateTimeRegistered, isLeader) VALUES ('{$idgen}', '{$postedEmail}', '{$hashedPass}', NOW(), '0')");

answered Jan 12, 2012 at 13:20

Fad

9,8683 gold badges48 silver badges65 bronze badges

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

Comments

ChristophN · Accepted Answer · 2012-01-12 13:49:26Z

1

Uhm, and please, use this syntax for inserting instead:

http://codeigniter.com/user_guide/database/active_record.html#insert

works so much safer.

answered Jan 12, 2012 at 13:49

ChristophN

111 bronze badge

Collectives™ on Stack Overflow

CodeIgniter not correctly performing a sql query [closed]

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related