0

I have no idea what's wrong, I googled but I couldn't find the answer :/ it's probably really obvious but i'm rather new to PSQL
Statement:

INSERT INTO drop_users VALUES ('John_Bucky','John_Bucky','a83b3735814aa577651a55b7c838a6a0',02-04-2011_02:20:55,'object', DEFAULT,DEFAULT,13,DEFAULT,DEFAULT

Thanks for your time!
~Josh

2
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by thephpdev
0

I have no idea what's wrong, I googled but I couldn't find the answer :/ it's probably really obvious but i'm rather new to PSQL
Statement:

INSERT INTO drop_users VALUES ('John_Bucky','John_Bucky','a83b3735814aa577651a55b7c838a6a0',02-04-2011_02:20:55,'object', DEFAULT,DEFAULT,13,DEFAULT,DEFAULT

Thanks for your time!
~Josh

Here's my php code

$dbconn = pg_connect("STUFF PPL CANT SEE");
		$name = str_replace(" ", "_", $name);
		$tag = str_replace(" ", "_", $name);
		$query = "INSERT INTO drop_users VALUES ('".$tag."','".$name."','".md5($pass)."','".date('d')."-".date('m')."-".date('Y')."_".date('H').":".date('i').":".date('s')."','".$style."', DEFAULT,'".$clan.",".$age.",".$prestige.",DEFAULT);";
		$result = pg_query($dbconn, $query);

And this is how the table is set up:
varchar[20]
varchar[20]
varchar[10]
date
varchar
int
varchar[20]
int
int

0

Figured it out: when I looked at the data types it was saying 'character varying[]' and i just switched that to just 'character varying'.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.