was trying to make auto databse installer for robets quiz. seems i missing something

$dbHost="localhost";
$dbUser="root";
$dbPass="";
$dbase = "simplequiz";
$mysqlcon = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("".mysql_error()."");
mysql_select_db("$dbase", $mysqlcon) or die ("".mysql_error()."");

function mysql_table_exists($table){
$exists = @mysql_query("SELECT 1 FROM `$table` LIMIT 0", $mysqlcon);
if ($exists) return true;
return false;
}
if (mysql_table_exists("answer")==false){
global $mysqlcon;
$this_file = fopen("simplequiz.sql", "r");
$loadcontent = fread($this_file, filesize("simplequiz.sql"));
$lines = explode("\n", $loadcontent);
$line[] = explode("\n", $loadcontent);
$count = count($lines);
@fclose($this_file);
for ($a = 1; $a < $count; $a++) {
$query = $lines[$a];
echo $query;
}
mysql_db_query($query, $mysqlcon);

}

Are you getting an error message?

no
echo is printing the file, but not created in DB.

Each query ends in a semicolon. Split that file by semicolons and run one query for each. You should have better luck.

hmm, tryed that and split #, nothing.

tryed different variations of this, says query empty

$query=explode(";",$loadcontent);
for ($a = 1; $a < count($query)-1; $a++) {
mysql_db_query($dbase,$query[$i],$mysqlcon) or die(mysql_error());
}

doh, i see what i did, works now.

ok, re wrote it a bit,

<?PHP
/** Header File
*
* This file contains constants used elsewhere
* modify the $mysqlcon variable to connect SimpleQuiz
* to your own MySQL database
*
* @package SimpleQuiz
* @author Robert Peake <robert@peakepro.com>
* @copyright &copy; 2004
* @link http://www.simplequiz.com
* @license http://www.gnu.org/licenses/gpl.txt
* @version 1.0
*/
$contact = ""; //fill this in to give out your administrator's contact email address in case of errors
$smartydir = "Smarty-2.6.0/";

$dbHost="localhost";
$dbUser="root";
$dbPass="";
$dbase = "simplequiz";
$mysqlcon = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("".mysql_error()."");
mysql_select_db("$dbase", $mysqlcon) or die ("".mysql_error()."");
$dbfile = "simplequiz.sql";
if (!@mysql_query("SELECT 1 FROM `answer` LIMIT 0", $mysqlcon)){
$loadcontent = fread(fopen("$dbfile", "r"), 85760);
$query=explode(";\n",$loadcontent);
for ($a = 1; $a < count($query)-1; $a++) {
mysql_db_query($dbase,$query[$a],$mysqlcon) or die(mysql_error());
}
}

?>

seems it thinks it is installed on the http root, could not login.

but changed
$smarty_login->assign('action','".$PHP_SELF."');

also apears it uses url rewrite, i not have it on my test puter.
i late, later

Yeah ... the .htaccess thingies are for Apache to support the url rewriting. I should probably make this optional so that confused Windows uers can still use the package. The URL rewriting isn't really necessary for SEO or anything, just looks nicer IMHO. It's not hard to do -- just replace '/login' calls with '/login.php' calls, etc.

btw, those of you that wonder what we're talking about:

http://www.simplequiz.com/