tags:

views:

17

answers:

2
+1  Q: 

Storing text in database with tags

Can anyone please help me with this? I want to know how to store text in database with the tags. For example, if the text is bold, italics, underlined, justification, paragraphs, space etc., then even that must be retrieved and displayed in the textarea of the jsp page. Please help me out!

A: 

use function getTag("id_of_tag") to get tag.

attached its value and save it to database.Later retrieve it and show in view.

 2010-07-14 07:13:07
A: 

1] Create a field in database with datatype Text

2] Use some javascript text-area such as tinymce so that user can enter the text bold, italic etc.

3] Save the field with proper sql injectioning after form submission.

Salil  2010-07-14 07:20:24

related questions

Updating a table within a select statement
How do I make an expression inside a select statement without it being returned as column?
Updating multiple rows with a value calculated from another column
How to perform grouped ranking in MySQL
MySql : UNION is not getting executed when executed as a view
MySql Union not getting executed in a view
Removing an Appended " In front of Every Column
Best way to prevent a value from going negative in mysql
Copy MySQL structure across servers via PHP
How can I query from 2 dates ranges (mysql)
MySQL function to insert record if update fails?
Rather difficult mySQL problem ...
PHP / MySql Verbosity VS over the wire
SQL to search and replace in mySQL
How to Avoid Throwing An Error When SQL Select Returns Nothing
MySQL permissions issue - should be non-issue
mysql stored procedure question
Mysql efficient "select id else insert" query
MySQL - A difficult INSERT...SELECT on the same table [MySQL 5.051]
Can I concatenate multiple MySQL rows into one field?
search question
Checking if mysql_query returned anything or not
How can I create a MySQL JOIN query for only selecting the rows in one table where a certain number of references to that row exist in another table?
MySQL Query: LIMITing a JOIN
Multiple Updates in MySQL