Dynamic Value in MySql

[vikkram]

Hi friends,

I am developing internal control system with PHP-MySql & have one problem.

I want to enter dynamic variable into MySql like :

I have checked report of Mr. $userName from $previousDate to $currentDate…..”

Wherein - $username, $previousDate, $currentDate will be called from other table.

My codes :

[PHP]INSERT INTO `checkReport ` (`schID`, `schNo`, `noteNo`, `subschName`, `content`) VALUES (1, 1, 'a', '', ' I have checked report of Mr. ‘.$username.’ from ‘.$previousDate.’ to ‘.$currentDate.’ ….)[/PHP]

which is not working… Please guide me through.

Thanks,
Vikram

[amit007]

INSERT INTO `checkReport ` (`schID`, `schNo`, `noteNo`, `subschName`, `content`) VALUES (1, 1, 'a', '', ' I have checked report of Mr. ‘.$username.’ from ‘.$previousDate.’ to ‘.$currentDate.’ ….)

it will never work

make a variable and store (have checked report of Mr. ‘.$username.’ from ‘.$previousDate.’ to ‘.$currentDate.) in that variable and then store this variable in table.use ' ' when writes value.