Display data from database in a table with different colours

**smithster** · 05-30-2007, 01:20 PM

I already have a database with information stored in it. And I want to display the information on a webpage using PHP.

Is it possible to tell it to be displayed with the first letter in one colour and the rest of the word in another colour.

So, for example, my name on this site is Smithster.

If this word was stored in a database and I wanted to display it on the webpage in the following format......

Smithster

Is this possible and if so, anyone know how to do it?!?!?!?

Thanks in advance.

Smithster.

**Twey** · 05-30-2007, 01:46 PM

Code:

  <style type="text/css">
    .name-firstletter {
      color: red;
    }
    .name-rest {
      color: #48d1cc;
    }
  </style>
</head>
<body>
  <p>
    <span class="name-firstletter">
      <?php echo($name[0]); ?>
    </span>
    <span class="name-rest">
      <?php echo(substr($name, 1)); ?>
    </span>
  </p>

**Twey** · 05-30-2007, 01:48 PM

Argh, no! Don't use a separate <span> for every single letter! That's very far from an easiest way, and is ridiculously inefficient.

**DimX** · 05-30-2007, 02:23 PM

Why multiple spans?

HTML Code:

<style type="text/css">
.name {
    color: #48d1cc;
}
.name:first-letter {
    color: red;
}
</style>
</head>
<body>
  <p>
    <span class="name"><?php echo $name; ?></span>
  </p>

Edit
Oh, I see why, first-letter pseudo class doesn't work for span (at least not in IE).

**Twey** · 05-30-2007, 03:08 PM

:first-letter doesn't work at all in IE.

**DimX** · 05-30-2007, 04:29 PM

It does, it works for <p>.

**Twey** · 05-30-2007, 04:33 PM

Oh no, it does work, but has bugs.

**smithster** · 05-30-2007, 05:21 PM

ok, so now Im really confused!!! The original coding you posted Twey...will it work in IE or not??? And how do I put it into a PHP script. As when I copy it in as it is, but change the $name to what I need, I just get an error....

Parse error: syntax error, unexpected '<' in /home/******/public_html/clanapp/challengeus/viewreportwithname.php on line 40

**Twey** · 05-30-2007, 05:24 PM

ok, so now Im really confused!!! The original coding you posted Twey...will it work in IE or not???

Mine will work fine, yes. It's DimX' that has issues in IE.

Parse error: syntax error, unexpected '<' in /home/******/public_html/clanapp/challengeus/viewreportwithname.php on line 40

The script starts from outside PHP parsing mode. That is to say, it should not be within <?php ?> tags.

**smithster** · 05-30-2007, 06:23 PM

yeah I guessed that!! Have changed it and now the script works again.

But, I still have to get the variable $name to match up with the name in the database. I thought it would be something like this....

Code:

$name = . $row['alias'] .

But it does not want to work!! So I am wrong!!

Thread: Display data from database in a table with different colours

Thread Tools

Search Thread

Displaying Information in more than 1 colour

Bookmarks

Bookmarks

Posting Permissions