Getting < and > from MySQL to display on php page

[phpocean]

I have a question but can't search on google since google doesn't do < > search.

 

In my MySQL, I wanted to input < > instead of < and > because < and > only take 2 characters as suppose to 8 with < and >

 

Or is there another way?

[ldougherty]

When you say you want to input them, do you mean you want to be able to write values with < and > into a database field?

 

mysql_escape_string

http://us2.php.net/mysql_escape_string

 

[PFMaBiSmAd]

You can input and store them as a single character any time you want.

 

If you want them to be displayed instead of being treated as part of a HTML tag, you must convert them to < and > before you output them to the browser.

[phpocean]

When I store them in MySQL as < and >, it won't show my on my php page.

 

Say if I store it like <News> in MySQL, it will show as News without the <> on my php page.

 

By the way, are you saying if I input them through php INSERT code instead of phpMyAdmin, it will show?

 

But isn't there a way to do it using phpMyAdmin?

[Ken2k7]

It should work if you just INSERT into it. If you view it via phpMyAdmin, do you see the < > in the table?