mySQL insert problems

paaaaaaaaaa · 08-20-2005, 09:59 AM

Im having some problems with mySQL,

Ive been trying to INSERT a new record I know you have to do it like:

PHP Code:

  INSERT INTO artists (id, name, date, location)

????: NamePros.com http://www.namepros.com/programming/117092-mysql-insert-problems.html
VALUES ('', '$name', '$date', '$location')

This is the code im useing but an example, it normally works for me but not this time. So to do some debugging I made phpmyadmin pump out some php for an insert and it adds in two extra values like:

PHP Code:

  INSERT INTO artists (id, name, date, location)

VALUES ('', '$name', '$date', '','', NULL)

This works but when I tell the last value to be a variable the extra values move about so I just cant get it right. Anybody know whats going on here?

mholt · 08-20-2005, 11:13 AM

if id is primary key, auto-increment, change '' to NULL.

sdsinc · 08-20-2005, 01:32 PM

If ID is primary key, auto-increment, there is not need to supply a value for that field...

aween · 08-20-2005, 06:33 PM

Originally Posted by sdsinc

If ID is primary key, auto-increment, there is not need to supply a value for that field...

You took my words!

Jamison54 · 08-20-2005, 07:15 PM

This should be the correct, and working code:

Code:

INSERT INTO `artists` (id, name, date, location) VALUES ('','$name','$date','$location');

paaaaaaaaaa, where you been?

08-20-2005, 09:59 AM	THREAD STARTER #1 (permalink)
paaaaaaaaaa NamePros Regular Join Date: Mar 2005 Posts: 442	mySQL insert problems Im having some problems with mySQL, Ive been trying to INSERT a new record I know you have to do it like: PHP Code: `INSERT INTO artists (id, name, date, location) ????: NamePros.com http://www.namepros.com/programming/117092-mysql-insert-problems.html VALUES ('', '$name', '$date', '$location')` This is the code im useing but an example, it normally works for me but not this time. So to do some debugging I made phpmyadmin pump out some php for an insert and it adds in two extra values like: PHP Code: `INSERT INTO artists (id, name, date, location) VALUES ('', '$name', '$date', '','', NULL)` This works but when I tell the last value to be a variable the extra values move about so I just cant get it right. Anybody know whats going on here? __________________ Please add to my rep points if i was helpful. Thanks. Content management system and online shop software Last edited by paaaaaaaaaa; 08-20-2005 at 10:29 AM.

08-20-2005, 07:15 PM	#5 (permalink)
Jamison54 NamePros Regular Join Date: Jan 2005 Location: Milwaukee, WI Posts: 305	This should be the correct, and working code: Code: INSERT INTO `artists` (id, name, date, location) VALUES ('','$name','$date','$location'); paaaaaaaaaa, where you been? __________________ JamisonJerving.com - My Personal Design & Development Portfolio \| MakeThatGame.com - Gamer developer's discussion board. \| MyHostPlaza.com - Solution to the most dedicated web hosting service.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM
cannot find script	sickle	Web Design Discussion	5	04-03-2004 06:36 PM

08-20-2005, 11:13 AM	#2 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	if id is primary key, auto-increment, change '' to NULL.

08-20-2005, 01:32 PM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,963	If ID is primary key, auto-increment, there is not need to supply a value for that field...

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)