SQLite file ftp'ed from a .NET program

[pschomburg]

I can't seem to get this to work, I made a .net program that backs up its database (sqlite) via ftp. I need to analyze the uploaded data, but can't seem to get it to work.

 

function getNetSales($DBPath)

{

    $Total=0;

    $db=sqlite_open($DBPath);

    $query = $db->query('SELECT OrderTotal FROM Orders');

    echo $query->numRows();

 

    while ($query->fetch(SQLITE_ASSOC))

        {

            $Total+= $entry[0];

        }

 

    return $Total;

}

 

 

What am I doing wrong?