[RESOLVED] INSERT INTO works for real, but not referenced data? Help!

darylmalcolm

This Doesn't work (nothing happens):

$result = mysql_query ("INSERT INTO Reservations
VALUES ('$records','$resName', '$resEmail', '$resGuests', '$resGuest1', '$resGuest2', '$resGuest3', '$resGuest4', '$resDiet', '$resAttend');", $connection);

But this does:

$result = mysql_query ("INSERT INTO Reservations
VALUES (20,'Joe', 'none', 1, 'none', 'none', 'none', 'none', 'none', 'Yes');", $connection);

What gives?

Sayian

Well, in the 2nd query, you are inserting actual strings, so of course its going to get inserted.

Have you tried to echo out the variables to the screen to see if they contain the values you think they do?

darylmalcolm

Echo confirms the variables contain what they're supposed to...

crazychris

add

print mysql_error();

after the query, see if MySQL is returning an error. Probably because one of the variables has a ' (single quote) or a " (double quote) in it.

Also, you can drop the ; off the query, it's not required.

Also, the link doesn't need to be specified, it'll use the last link established.

My version of the query would look similar to this:

$result = mysql_query ("INSERT INTO Reservations VALUES ('".addslashes($records)."','".addslashes($resName)."','".addslashes($resEmail)."','".addslashes($resGuests)."','".addslashes($resGuest1)."','".addslashes($resGuest2)."','".addslashes($resGuest3)."','".addslashes($resGuest4)."','".addslashes($resDiet)."','".addslashes($resAttend)."')");

darylmalcolm

Using the error reporting indicated that I had a duplicate key value.

This is because I manually (phpadmin) removed a record, and was only using a counter to determine the value of a new record's key...

What's a better solution for avoiding duplicate keys? (In this case, I don't actually need a key, but in the future I might need to know...)

Oh yeah, thanks for your help folks!

crazychris

use an auto_increment as your primary key. When inserting a record, it will assign the next value to the key automatically.

When doing an update, you would go:
update table set field1='a', field2='b', field3='c' where id=xxx;

When doing an insert, you would go
insert into table (field1, field2, field3) values ('a','b','c');

note, no reference to the id in the insert, the key creates itself.
Use mysql_insert_id() to get the id of the newly created record if you need to use it immediatly.