I am trying to use SQLite to create a simple database however I just canít seem to get it to work. I am using the code supplied when I first downloaded SQLite. I am also unsure what should come after the blob data type?? Like after a char I have (100) is there something that needs to come after blob???

Cheers for any help
Code:
<?php
		try { 
			$db = sqlite_open("distributorlogin1.db"); 
			//sqlite_query($db , "CREATE TABLE tbllogin (username CHAR(100), password CHAR(100), company CHAR(200), timestamp CHAR(200) salesimage BLOB); 
		}catch (Exception $e){ 
			echo 'Caught Exception ', $e->getMessage(), "\n";  
		} 
		echo 'Created Database distributorlogin1.db.';
		// close database connection 
		sqlite_close($db); 
?>