Need a PHP and MySQL Guru !

[Electronic Punk]

Ok I need a quick hand as my crash course by myself of PHP and MySQL is letting me down!

Here is the current code

<?
$content = "";
$result = mysql_query("SELECT threadid, title, lastpost FROM thread WHERE forumid<>'13' ORDER BY lastpost DESC limit 5");
while (list($threadid, $title, $lastpost) = mysql_fetch_row($result)) {
	if (strlen($title)>'25') {
		$title = substr($title, 0, 22);
		$title .="...";
	}
	$content .= "<font class=tiny><a href=\"./forum/showthread.php?&threadid=".$threadid."&goto=newpost\" target=\"_blank\">".$title."</a><br>";
}
$content .= "";
?>

Now what I want to do is add this

title=\"$title\"

except modified a little so on a mouseover the title will display the FULL topic name if it is over 25 characters long... Anyone got any ideas?

 

[Electronic Punk]

No one knows? :S

 

[Electronic Punk]

Ok I managed to do it myself, in case anyone was actually trying to do it, the changes I am wanting are indicated in bold:

<?
$content = "";
$result = mysql_query("SELECT threadid, title, lastpost FROM thread WHERE forumid<>'13' ORDER BY lastpost DESC limit 5");
while (list($threadid, $title, $lastpost) = mysql_fetch_row($result)) {
[b]$fulltitle = $title;[/b]	
if (strlen($title)>'25') {
		$title = substr($title, 0, 22);
		$title .="...";
		
	}
	$content .= "<font class=tiny><a href=\"./forum/showthread.php?&threadid=".$threadid."&goto=newpost\" [b]title=\"$fulltitle\"[/b] target=\"_blank\">".$title."</a><br>";
}
$content .= "";
?>

 

[Azzuron]

Looks good. i Done some PHP in my day...little dabble really.

http://www.neologic.net/dk/image2html

Its really stupid, but it does alot of PHP magic