{
$db = db_getDB();
+ if(db_tableExists($tablename)) return true;
+
$sql = "create table \"$tablename\" (\"".$tablename."_id\" INTEGER PRIMARY KEY AUTOINCREMENT";
for($i=1; $i < func_num_args(); $i++) {
$colname = func_get_arg($i);
$db->query($sql);
}
-function db_selectData($tablename, $column, $value)
+function db_selectData($tablename, $column="", $value="")
{
$db = db_getDB();
- $sql = "select * from \"$tablename\" where $column like '%$value%'";
+ if($column != "") $extra = " where $column like '%$value%'";
+ else $extra = "";
+ $sql = "select * from \"$tablename\"$extra";
$res = $db->query($sql);
$data = $res->fetchAll();
{
$db = db_getDB();
- $sql = "delete from \"$tablename\" where column_$column like '%$value%'";
+ $sql = "delete from \"$tablename\" where $column like '%$value%'";
+ //echo "Sql is $sql\n";
return $db->query($sql);
}