Function problem?

Fernashes

I seem to be having a problem making functions, as the last time I tried this, I got the same errors. However, then I just did it differently... but in this situation, I need functions!

This is my code:

<?php 
require_once('../../Connections/DB_tests.php'); 



$today = date("Y-m-d");
$start = '2004-01-12';
$end=strtotime('jan 1 1970');

while ($end<=$today) {

echo "<br>Start ".$start;
$end = date('Y-m-d (D)', strtotime($start ."+ 6 days"));
echo "<br>End ".$end;
get_calls($start, $end);
$start=date('Y-m-d (D)', strtotime($end ."+ 1 day"));
$i=$i+1;
}	

?>

When I run this, I get these errors:

Notice: Undefined variable: database_DB_tests in C:\Web\tstadm\adm\Stats\test.php on line 13

Notice: Undefined variable: DB_tests in C:\Web\tstadm\adm\Stats\test.php on line 13

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Web\tstadm\adm\Stats\test.php on line 13
Notice: Undefined variable: DB_tests in C:\Web\tstadm\adm\Stats\test.php on line 15

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Web\tstadm\adm\Stats\test.php on line 15

Does anybody have any ideas what I'm doing wrong?

zedan_80

i think u need to show some code from C:WebtstadmadmStatstest.php specialy those line numbers in the ERROR to let us help U.

bpat1434

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:WebtstadmadmStatstest.php on line 13

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:WebtstadmadmStatstest.php on line 15

Well, you're not properly connecting to the mySQL database. Once you connect, those errors will disappear.

As for the undefined variable, not sure. That can't be all your code because line 13 of your supplied code is:

    $end = date('Y-m-d (D)', strtotime($start ."+ 6 days"));

In order for us to help you more, I would post the code to "DB_tests.php" as well as the full code for "WebtstadmadmStatstest.php".

~Brett

rincewind456

The undefined variable is $i on the line

    $i=$i+1;

put a $i=0:

outside your while loop.

bpat1434

Rincewind, I disagree. PHP would not throw the error of having an undefined variable being database_DB_tests and such if it were "$i". That may be a part of it, but there's something more. Unfortunately, this code does not reveal all of what he's got going on.

~Brett