I think your single quotes are preventing variable interpolation.

I think not. What makes you think that single quotes inside strings have a special meaning? The single quotes in

"INSERT INTO tweets (published, content, link) VALUES ('$published', '
+$content', '$link')"
[download]

are just single quotes. They aren't any more special than the e's or the commas in the string.