call item title from database to echo in url

[sfraise]

Hi, I'm working on a Joomla plugin that shows a member's videos added through the seyret component in a tab in their community builder profile. I'm having an issue calling up the video title from the database to then echo it in the url for the link back to the actual video.

 

Here's what I'm using to set the variable, videotitle is the field in the jos_seyret_video table:

//--- Video Title Call
    $database->setQuery("SELECT 'videotitle' FROM #__seyret_video as a " 
                . "\n  WHERE a.published = '1'"
			. "\n AND a.addedby = '$userid' "
			. $where);
    $videotitle=$database->query();

And here's where it makes the url:

$editlink= sefRelToAbs("index.php?option=com_seyret&view=video&id=".$row1->id."&videotitle=$videotitle#tabs-2")

 

But instead of printing the video title in the url it prints this:

index.php?option=com_seyret&view=video&id=1&videotitle=Resource%20id%20#171#tabs-2

 

It should look like this:

index.php?option=com_seyret&view=video&id=1&videotitle=omaha#tabs-2

where omaha is the title of the video.

 

What am I doing wrong here?

[ialsoagree]

$videotitle_array = mysql_fetch_assoc($videotitle);
$videotitle = $videotitle_array['videotitle'];

[sfraise]

No joy, using this leaves the video title in url blank.