Style-tag with a variable

Dr_Flink

I want to use the html 'style'-tag so when the visitor puts the mouse over a word, a box will apear with info. The code I use now looks like this:

print("<font title="); print($row["variable"]); print(">"); print($row["word"]); print("</font>");

The problem is that only the first word in the db-field appears, and I want that at least 100 letters to be shown.

In my db I use VARCHAR as type.

Can anyone help me?

bradgrafelman

First of all, did you know you could condense all that code to this?

print '<font title='. $row['variable'] . '>' $row['word'] . '</font>';

(A period concatenates the strings together).

Now, on to your problem.

You mentioned the type is VARCHAR. That's not a complete column type in MySQL, as VARCHAR requires a char limit too. What's the exact type? VARCHAR(20) ? VARCHAR(255) ?

Also, how is the data inserted into the field 'word' in MySQL? Have you tried manually going into MySQL using a GUI or the CLI and seeing what the 'word' column actually contains?

The column name 'word' sounds like it was meant to only contain a 'word'. More information about your setup is required here.

Dr_Flink

No, I didn't know that 🙂. I replaced the code with the one u gave me (witch is far more neater, of course) but I can't get it to work. I get this: Parse error: parse error, unexpected T_VARIABLE in....

The exact type I'm using is: VARCHAR(255)

And yes, I do know what the column contains. I'm using phpMyAdmin, and the column contains more than the one word that I'm getting.

Very grateful for all the help I can get! 🙂

Dr_Flink

...aaah, now I see. We missed a (.) so the code should be:

print '<font title=' . $rad['place'] . '>' . $rad['activity'] . '</font>';

Now the code is working...almost. It's still only showing the first word from the db...

Dr_Flink

aaaah, I solved it. The code should be like this:

print '<font title=' . '"' . $rad['place'] . '"' . '>' . $rad['activity'] . '</font>';

Thanks for all the help!

bradgrafelman

Woops! My mistake.

Glad you could resolve your problem nonetheless. If it is indeed resolved, don't forget to MARK THIS THREAD RESOLVED using the link at the bottom of the page.