HTML in MySQL Tables
Some time ago, I posted a question about using HTML in MySQL tables. For example, if I put the following in a table cell... emCowboy State/em (reinforced by logo depicting cowboy on bucking bronco), emBig Wyoming/em It will be displayed as... Cowboy State (reinforced by logo depicting cowboy on bucking bronco), Big Wyoming except that Cowboy State and Big Wyoming will be italicized. Someone suggested this is a bad strategy, asking what I would do if I later decided to change the italicized words to bold, for example. So what are the options? Is there a way to tag words so that you can later make them italicized, bold, red or blue, etc.? And isn't there a way to render code invisible when displaying MySQL tables? For example, if you don't want the italicized words to appear italicized, couldn't you write some code that would instruct your browser to ignore em tags? Along similar lines, could you write code that would convert em to b? I'm just trying to figure out what the options are, as well as determining the best option. One way or another, I would like to tag certain key words and phrases. I'm assuming that once you do that, you can probably manipulate the tags with PHP in many different ways. __ Do you Yahoo!? Yahoo! Domains Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HTML in MySQL Tables
David Blomstrom wrote: Some time ago, I posted a question about using HTML in MySQL tables. Someone suggested this is a bad strategy, asking what I would do if I later decided to change the italicized words to bold, for example. I'm just trying to figure out what the options are, as well as determining the best option. One way or another, I would like to tag certain key words and phrases. This is getting a *bit* away from DB and into IA, but... If Cowboy State has a semantic meaning, like nickname, you might want to think about either having a field for it or, if it's part of a text segment that doesn't lend itself to that, use a semantic tag for it, like `nicknameCowboy State/nickname, (reinforced ...` and then, for display purposes, transform that XML using XSLT into your appropriate output. I'm assuming that once you do that, you can probably manipulate the tags with PHP in many different ways. Uh, many, yeah; put the coffee on. :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HTML in MySQL Tables
--- Hassan Schroeder [EMAIL PROTECTED] wrote: If Cowboy State has a semantic meaning, like nickname, you might want to think about either having a field for it or, if it's part of a text segment that doesn't lend itself to that, use a semantic tag for it, like `nicknameCowboy State/nickname, (reinforced ... and then, for display purposes, transform that XML using XSLT into your appropriate output. You mean I can make up a name for a semantic tag, designating every nicknname nickname or every emphasized word emphasize, for example? And is this something that can only be done with XML? I do recall reading that XML is a very flexible language that lets you create your own codes, styles, etc. Am I correct in guessing that the pros prefer XML to HTML or XHTML when working with MySQL? If so, that's another thing for me to learn. I've found XHTML pretty simple, but XML looks a little more complex. Thanks. __ Do you Yahoo!? Yahoo! Domains Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HTML in MySQL Tables
--- Hassan Schroeder [EMAIL PROTECTED] wrote: If Cowboy State has a semantic meaning, like nickname, you might want to think about either having a field for it or, if it's part of a text segment that doesn't lend itself to that, use a semantic tag for it, like `nicknameCowboy State/nickname, (reinforced ... and then, for display purposes, transform that XML using XSLT into your appropriate output. You mean I can make up a name for a semantic tag, designating every nicknname nickname or every emphasized word emphasize, for example? And is this something that can only be done with XML? I do recall reading that XML is a very flexible language that lets you create your own codes, styles, etc. Am I correct in guessing that the pros prefer XML to HTML or XHTML when working with MySQL? If so, that's another thing for me to learn. I've found XHTML pretty simple, but XML looks a little more complex. Thanks. __ Do you Yahoo!? Yahoo! Domains Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HTML in MySQL Tables
David Blomstrom wrote: You mean I can make up a name for a semantic tag, designating every nicknname nickname or every emphasized word emphasize, for example? Yep, XML lets you create your own DTD/schema -- though sometimes it makes sense to use (or leverage) an existing one. And is this something that can only be done with XML? No, but 1) it works well for this kind of application, and 2) there are lots of tools available... -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HTML in MySQL Tables
On May 21, 2004, at 9:14 PM, David Blomstrom wrote: --- Hassan Schroeder [EMAIL PROTECTED] wrote: If Cowboy State has a semantic meaning, like nickname, you might want to think about either having a field for it or, if it's part of a text segment that doesn't lend itself to that, use a semantic tag for it, like `nicknameCowboy State/nickname, (reinforced ... and then, for display purposes, transform that XML using XSLT into your appropriate output. You mean I can make up a name for a semantic tag, designating every nicknname nickname or every emphasized word emphasize, for example? And is this something that can only be done with XML? I do recall reading that XML is a very flexible language that lets you create your own codes, styles, etc. Am I correct in guessing that the pros prefer XML to HTML or XHTML when working with MySQL? If so, that's another thing for me to learn. I've found XHTML pretty simple, but XML looks a little more complex. What you want to look into is CSS. If you're already working XHTML, then that's great. It's a cleaner, more straightforward, back the intent of HTML before the browser wars polluted it. Use CSS to define how things appear. Honestly, it takes a while to get. Not the syntax and such (generally easy), but more the methods in how to best apply it. Most CSS refc I have found deal with the mechanics of it. It's hard to find a good refc on how to apply. I recommend the book Eric Meyer on CSS -- it's about practical application. You'll need a companion guide for syntax reference. So, you'd (potentially) end up with: span class=nicknameCowboy State/span It's very easy to initially want to do span class=boldred10ptCowboy State/span and that's pretty typically for everyone's first CSS era, but try to get past that level quickly. I finally hit what I call my third era in CSS this past year, and man, does it make web design so much better. Anyway, quite off topic, so, if you have some questions, hit me up offline. -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]