echo statement stored in mysql

[seanlyons]

Is there any way to store a php echo statement within a field of a my sql database?

I am putting together a school reporting system, and I want some generic comments to be used, each containing the name of the student. eg "this year Jonny has really improved his science score"

what this would read ideally is

<td>this year <?php echo $row_rsName['First_Name']; ?> has really improved his science score</td>

And it does, until I try to put that code into a row in a mysql database.

When I then list all of the rows in the database in a table, the code disappears, and the name is not present.

Any ideas people......its for the kids :-)

[Mordecai]

The code probably doesn't disappear, it's just being ignored by your browser (as it now becomes an HTML tag).
There are two ways you can go about this. Firstly, you could just put a phrase (something like "[FirstName]") that you str_replace() into $row_rsName['First_Name'].
Secondly, you could eval() the PHP code. This can be done by using eval('?>'.$yourHTML) (the ?> at the beginning will ensure that HTML inside the eval() will be parsed as HTML, not PHP--resulting in errors).