- Impact
- 6
Im having some problems with mySQL,
Ive been trying to INSERT a new record I know you have to do it like:
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:
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?
Ive been trying to INSERT a new record I know you have to do it like:
PHP:
INSERT INTO artists (id, name, date, location)
VALUES ('', '$name', '$date', '$location')
PHP:
INSERT INTO artists (id, name, date, location)
VALUES ('', '$name', '$date', '','', NULL)
Last edited:
