ntroycondo

I'm switching my blog to Wordpress and importing posts fine via RSS but comments aren't importing cleanly. So figured I could import comments with phpMyAdmin. Current DB is MSSql DB. But not sure the best way to do this and the best way to Join the old comments to the appropriate new post IDs. I will probably use post_name to Join comment to appropriate posts. I'm new to SQL so any tips to point me in the right direction are appreciated.

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.

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');";