Jump to content

Bartolo

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Bartolo's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I'm trying to learn PHP and sqlite from a tutorial which has the following code: <?php $sqlite = new SQLiteDatabase('music.db') or die ("Could not open database"); $sql = "SELECT artist_id, artist_name FROM artists"; if ($result = $sqlite->query($sql)) { if ($result->numRows() > 0) { while($row = $result->fetch()) { echo $row[0] . ":" . $row[1] . "\n"; } } else { echo "No records matching your query were found."; } } else { echo "ERROR: Could not execute $sql. " . sqlite_error_string($sqlite->lastError()); } unset($sqlite); ?> But I get this error: I'm not able to figure out where the error is. The database exists, but the contents can't be interpreted for some reason. When I query the DB from sqlite itself, I don't have any problem though. Could it be there's a version conflict? I'm using sqlite3, while the tutor is meant to be for sqlite2x. I hope someone can hep me with this. Thanks, Bart
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.