Think Quick: Anyone see the error in this line?

robertaccettura

The line is:

$is_success_second = mysql_query("insert into data (username, password, firstname, lastname, email, age, sex, country, occupation, industry, zip, passquest, passans, income, group, preferences, date) values ('$username', '$password', '$firstname', '$lastname', '$email', '$age', '$sex', '$country', '$occupation', '$industry', '$zip', '$passquest', '$passans', '$income', '$group', '', '$datereg')");

Anyone see it? I'm going cross eyed from a few hours of programming I guess. I can't find it for the life of me. But I am pretty sure it's in this line.

robertaccettura

It's not the ''

that's intentional. I want nothing to be entered in that field.

rIkLuNd

if you want nothing to be entered, then you have to write "", not just ".

rIkLuNd

sorry, thought it was a ", not two '...

By the way:
Have you tried adding this code after that line:

if(!$is_success_second)
die(mysql_error());

This could give you lots of useful info about the error! 😉

gtibok

Your code is OK ... please let us know what error message it returns ... or what happens.
It could be your MySQL table (i.e u try to add a duplicated record and u have e unique field, or some bin field and u try to insert string ...)!

robertaccettura

The return was

You have an error in your SQL syntax near 'group, preferences, date) values ('test001', 'PASSWORD', 'Robert', 'Accettura', ' at line 1

Any ideas?

gtibok

would you make a SQL dump and show us your table !?
only the structure, not data.
it could help identify the problem

robertaccettura

phpMyAdmin MySQL-Dump

version 2.3.2

http://www.phpmyadmin.net/ (download page)

Host: localhost

Generation Time: Nov 10, 2002 at 08:30 PM

Server version: 3.23.43

PHP Version: 4.1.2

Database : `db15944a`

--------------------------------------------------------

Table structure for table `data`

CREATE TABLE data (
id int(11) NOT NULL auto_increment,
username text,
password text,
firstname text,
lastname text,
email text,
age int(3) default NULL,
sex text,
country longtext,
occupation text NOT NULL,
industry text NOT NULL,
zip text NOT NULL,
passquest text NOT NULL,
passans text NOT NULL,
income text,
group text NOT NULL,
preferences text NOT NULL,
date text NOT NULL,
PRIMARY KEY (id)
) TYPE=ISAM PACK_KEYS=1;

gtibok

OK ...

You query IS :
INSERT INTO data VALUES (
''
,'$username'
, '$password'
, '$firstname'
, '$lastname'
, '$email'
, '$age'
, '$sex'
, '$country'
, '$occupation'
, '$industry'
, '$zip'
, '$passquest'
, '$passans'
, '$income'
, '$group'
, ''
, '$datereg')

It must work , I tested it on my MySQL 3.23 and it's workin'
Another thing ----
use VARCHAR for this field to optimize tables, and DATE to store date or DATETIME ; preferences should remain text if u intend to insert large text data.

gtibok

Your first query problem was the group
...
you try to tell MySQL to insert data in that field but it tries to group something ... and does not undersand what .
try to change that field name

robertaccettura

Sorry, I'm still a newbee....

Didn't quite understand what your trying to say.

How can I fix this?

notionlogic

the word "group" should not be used in field names - it's a SQL command

robertaccettura

Originally posted by notionlogic
the word "group" should not be used in field names - it's a SQL command

Oh....

Thanks everyone.

So I guess I wasn't crosseyed, just ignorant to mySQL commands when trying to debug this.

Thanks