[kappler0]

Hi - I was trying to use the script - AudiStat - on our site for web
statistic reporting - it works fine on all main folder pages - except when
we try to add the code to our phpMydirectory index page. Any assistance is
appreciated. Thanks

The directory is in a separate folder, here is the basics: ( view the
reporting at www.cablingassist.com/stats )

location of Audistat: cablingassist.com/stats
location of page not reporting: cablingassist.com/directory/index.php

The code instructed to place at the end of all php pages is: <?php
require($REDIRECT_HOMEDIR . "stats/stats.php"); ?>

<?php require($REDIRECT_HOMEDIR . "stats/stats.php"); ?> gives no
reporting at all and seems to do nothing
<?php require($REDIRECT_HOMEDIR . "../stats/stats.php"); ?> gives a
Can't select database : $!

Thanks again...
Scott

[Pineapple]

I would assume that if the latter gives you an error about the database then it is including the file properly. At this point you should probably look at the MySQL configuration for the script, make sure you have the database name set properly.

[kappler0]

Originally Posted by Pineapple

I would assume that if the latter gives you an error about the database then it is including the file properly. At this point you should probably look at the MySQL configuration for the script, make sure you have the database name set properly.

Thanks - you were correct - it was the db user assignments

Scott

[grads]

Originally Posted by kappler0

Thanks - you were correct - it was the db user assignments

Scott

Please could you tell me what you did? I'm having real problems trying to figure this one out. The mySQL details I'm using have worked for other application with no problems.

I've created a new database and new user both called "gradpads_stat".

In AudiStat I've edited the config.php file to:

<?php

$sql_host="localhost";
$sql_login="gradpads_stat";
$sql_passe="MYPASSWORD";
$sql_dbase="gradpads_stat";
$sql_table="stats";

?>


I am still getting the "Can't select database : $!" report.

Can anyone help?

Many thanks!