oen sql command

[runeveryday]

$sql = 'INSERT INTO joke SET joketext="' . $joketext . '", jokedate="today's date"';  

i don't understand the line

 joketext="' . $joketext . '",

why it use the single quote and the concatenation . i feel those are a surplus, use this is joketext="$joketext ", ok, but when i test it ,it's show an error, anyone can tell me the reason.any tips would be appreciated.

 

[trq]

Your getting an error because of the ' in today's

[Kryptix]

Use this:

 

$sql = "INSERT INTO `joke` SET `joketext` = '" . $joketext . "', `jokedate` = 'today\'s date';";  

[fenway]

Or actually escape your input data properly.