MYSQL INSERT ERROR

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hari4php
Forum Newbie
Posts: 5
Joined: Wed Mar 03, 2010 11:07 pm

MYSQL INSERT ERROR

Post by hari4php »

Hi,I was trying to insert values for a table in mysql,When inserting ..the follwing error occurs
Insertion Failed: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 ''full_name','user_name','user_email','pwd','address','tel','date','users_ip','ac' at line 1
My insert query is :

Code: Select all

$sql_insert = "INSERT into users ('full_name','user_name','user_email','pwd','address','tel','date','users_ip','activation_code') 
          VALUES ('full_name','$user_name','$usr_email','$md5pass','address','tel',now(),'$user_ip','$active_code')";
where $date is

Code: Select all

function filter($data) {
	$data = trim(htmlentities(strip_tags($data)));
	
	if (get_magic_quotes_gpc())
		$data = stripslashes($data);
	
	$data = mysql_real_escape_string($data);
	
	return $data;
}
Wat What will be the problem
Last edited by Benjamin on Thu Apr 29, 2010 11:53 am, edited 3 times in total.
Reason: Added [syntax=php] tags.
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: MYSQL INSERT ERROR

Post by Darhazer »

The fieldnames should not be enclosed with ', but with `
$sql_insert = "INSERT into `users` (`full_name`,`user_name`,`user_email`,`pwd`,`address`,`tel`,`date`,`users_ip`,`activation_code`)
VALUES ('full_name','$user_name','$usr_email','$md5pass','address','tel',now(),'$user_ip','$active_code')";
Post Reply