Large SQL statements in a quest?

[Trackye]

Thank you I will read up and look into both of those.


-------EDIT----------

So having looked into both of those.

Im still stuck.

The download links for DBD-MYSQL are not working I found a copy of DBD-mysql.4.0.32 but cannot seem to get it to install correctly.

If i try to install DBI using PPM install DBI it says no packages missing So it seems I have that installed.
But the code still returns #questerrors with a number of squares as the subject.

I do also have the mysql plugin and the DB is configured correctly there.

What im currently working with...

sub EVENT_SAY 
{ 
	my $wares = quest::saylink("wares", 1);
	if($text=~/Hail/i)
	{
		plugin::Whisper("Would you like me to reset my $wares ?") ;
	}
	if($text=~/wares/i)
	{
	plugin::Whisper("Restocking now!") ;
	$connect = plugin::LoadMysql();
	$query = "Delete from Merchantlist_temp where npcid =999260;";
        $query_handle->execute;
	plugin::Whisper("Restock complete!") ;
	}
	    quest::debug("$DBI::errstr") if $DBI::errstr;
}

For this type of code would DBD-mysql be required or is DBI enough?
Or am I doing something foolish incorrectly?