debug INSERT statement

[ntroycondo]

I have a simple INSERT statement that isn't inserting anything into one of the columns: coin_name

I've gone over everything and can't figure out why. All other columns get data.

HTML form passes everything fine. Is there a good way to debug this? I've triple checked everything and there are no type-o's that I see. Driving me mad...

 

$query = "INSERT INTO Coin (coin_name, coin_value, coin_condition, year_minted, face_value, purchase_price) VALUES 
('$coin_name', '$coin_value', '$coin_condition', '$year_minted', '$face_value', '$purchase_price');";

[Pikachu2000]

You have an extra semicolon inside the closing quote. Typo?

 

Have you by chance echoed $query to make sure it contains the values you'd expect it to contain? If that looks OK, make sure the field name matches exactly, including capitalization, and that the field's data type is appropriate for what you're trying to insert.

[ntroycondo]

I removed the extra ";" ...  good catch. But it doesn't make a difference.

 

echo $coin_name; returns nothing.

if I echo any other, like $coin_value; it will return the correct string.

 

 

[fenway]

I removed the extra ";" ...  good catch. But it doesn't make a difference.

 

echo $coin_name; returns nothing.

if I echo any other, like $coin_value; it will return the correct string.

 

 

Then you've got a php problem.

[chintansshah]

Please paste your PHP code where you set the value of $coin_name, $coin_value...bla...blaaa

[Pikachu2000]

Please paste your PHP code where you set the value of $coin_name, $coin_value...bla...blaaa

 

But please do so in the PHP help forum, or ask that this thread be moved there.

[chintansshah]

Sorry Pikachu, who can move thread?