Tool Tips are Being Cut Short 1

[6kleg]

I'm pulling data from a mySQL database into a php array to display a list of events using fields named event_date and event_name and event_description. For each record in which the event_description field is NOT empty, the PHP should wrap the event_name in a set of <a> and </a> tags and set the anchor's title attribute to be the event_description, so that mouse over the event_name shows a Tool Tip with the full description of the event.

The php is delivering the page properly except that the every Tool Tip only shows the first word in the event_description field.

Any ideas why this might be happeneing?

 

[phpgramma]

it's hard to say. can you show the code? maybe there are weird characters or something coming through...

 

[skiflyer]

I'll bet dollars to donuts you're just not quoting it properly.

Check the source of the output page, if it reads ...

<a href="[URL unfurl="true"]www.google.com"[/URL] title=Take me to google>GOOGLE</a>

Then the tooltip will only display Take

 

[6kleg]

I think skiflyer is on the right track.

Here's the code:

    if (!empty($row['event_descr'])){
    echo '<a title=' . $row['event_descr'] . '><u>';
    }
    echo $row['event_name'];
    
    if (!empty($row['event_descr'])){
    echo '</u></a>';
    }

How should I do the quotes so that they cover the event_description field?

 

[skiflyer]

if (!empty($row['event_descr'])){
      echo '<a title=[red]"[/red]' . $row['event_descr'] . '[red]"[/red]><u>';
    }
    echo $row['event_name'];
    
    if (!empty($row['event_descr'])){
      echo '</u></a>';
    }

You actually want to do a

htmlentities($row['event_descr'])

in place of your $row['event_descr']

Otherwise it would be incredibly easy for people to toy with your site.

 

[6kleg]

skiflyer,

The quotes fixed the tool tip problem. Thanks (with a star).

Please explain more about the htmlentities.

 

[MJB3K]

look here:

http://uk2.php.net/manual/en/function.htmlentities.php

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz